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 Blend360 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鈥檒l 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.