SFMC Product Lead

Company Description

Blendis a premier AI services provider, committed to co-creating meaningful impact for its clients through the power of data science, AI, technology, and people. With a mission to fuel bold visions, Blend tackles significant challenges by seamlessly aligning human expertise with artificial intelligence. The company is dedicated to unlocking value and fostering innovation for its clients by harnessing world-class people and data-driven strategy.

We believe that the power of people and AI can have a meaningful impact on your world, creating more fulfilling work and projects for our people and clients.

Our client within the travel and hospitality industry is seeking an experienced Salesforce Marketing Cloud (SFMC) Product Operations Lead to manage and enhance the end-to-end data operations within their technical environment. This role is highly technical and strategic, focused on optimizing marketing campaign performance through advanced data management, seamless integration, and user-focused solutions. The ideal candidate is a hands-on SQL expert with a strong background in marketing data infrastructure, campaign operations, and compliance-driven environments.

The Details:

• Location: Remote within the U.S.
• Duration: Approximately a 6-month consulting role through Blend
  360 with the possibility of extension
• Benefits: We do offer benefits to our full-time consultants, including Health, Vision, Dental, 401K plan, Life Insurance, Pretax Commuter Benefits, and an incredibly supportive team cheering you on!

What you’ll do:

1. SFMC Data Infrastructure & Integration

• Act as the technical lead for Salesforce Marketing Cloud data architecture, managing data pipelines, ETL processes, and automation within SFMC.
• Collaborate with IT and data engineering teams to scope, implement, and validate end-to-end data integrations between SFMC and upstream systems (CRM, data lakes, cloud storage, etc.).
• Configure and maintain synchronized data extensions, Contact Builder relationships, and SQL queries to enable dynamic campaign audience creation.
• Oversee data migrations, ensuring completeness, integrity, and accuracy throughout the SFMC environment.

2. Advanced SQL & Data Operations

• Leverage advanced SQL to build, troubleshoot, and optimize complex queries supporting
• marketing segmentation, campaign testing, and audience selection logic.
• Analyze, refine, and optimize recurring SQL queries used in automated journeys,
• triggered sends, and batch campaigns.
• Ensure accuracy of data counts, audience pulls, and source validation against campaign
• requirements across all channels including email, SMS, direct mail, and digital.

3. Campaign Support & Reporting

• Partner with Campaign Managers to translate marketing strategies into executable technical solutions within SFMC.

• Build tracking and reporting frameworks for multi-channel campaigns using SFMC native
• tools, SQL reports, and Google Analytics dashboards.
• Develop and support statistically sound A/B and multivariate testing frameworks,
• ensuring proper cell tracking and attribution setup.
• Maintain documentation and SOPs for campaign data flows, reporting schemas, and test
• result archiving.

4. Compliance & Governance

• Collaborate with Legal, Compliance, and Privacy stakeholders to ensure all campaign universes and data activations align with federal, state, and contractual regulations (e.g., CAN-SPAM, TCPA, GDPR, CCPA).

• Serve as the first line of review for incoming campaign data requests, assessing clarity,
• regulatory alignment, data feasibility, and technical complexity.

5. Continuous Optimization & Enablement

• Identify and implement improvements in marketing data processes to increase operational efficiency, reduce latency, and scale personalization.

• Document and train business users on data enablement tools and processes within
• SFMC to improve adoption and self-service capabilities.
• Contribute to the evolution of a comprehensive marketing attribution model that reflects the true impact of each channel, creative content, and segment over time.

• Hands-on Advanced SQL:
  Must have expert-level SQL skills for data extraction, transformation, and analysis within SFMC…