SFMC Consultant

Summary

Join Blend, a leading AI services provider, as a Salesforce Marketing Cloud (SFMC) Operations Lead. This remote, 6-month consulting role (with potential extension) requires expertise in managing and enhancing end-to-end data operations within a travel and hospitality client's technical environment. You will act as the technical lead for SFMC data architecture, leveraging advanced SQL skills to optimize marketing campaign performance. Responsibilities include data integration, campaign support and reporting, compliance, and continuous optimization. The ideal candidate possesses extensive experience with SFMC, advanced SQL, data integration, and marketing analytics. Blend offers a competitive benefits package to full-time consultants.

Requirements

• Hands-on Advanced SQL : Must have expert-level SQL skills for data extraction, transformation, and analysis within SFMC and related environments
• Salesforce Marketing Cloud : Proven experience managing SFMC configurations, data architecture (Contact Builder, DEs, SQL, Automations, etc.), and campaign deployment operations
• Data Integration : Experience integrating SFMC with upstream systems using APIs, SFTP, and ETL frameworks
• Marketing Analytics & Reporting : Familiarity with campaign tracking, test cell design, and tools like Google Analytics 360 and Excel for analysis
• Compliance & Data Governance : Understanding of marketing compliance standards, with prior experience working alongside legal teams
• Communication : Ability to communicate clearly with technical and non-technical stakeholders and translate business objectives into technical requirements

Responsibilities

• 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
• 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
• 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
• 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
• 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

Preferred Qualifications

• Experience in the hospitality or vacation services industry
• Familiarity with scripting in AMPscript or SSJS within SFMC
• Exposure to predictive intelligence or AI-enabled marketing tools
• Knowledge of marketing attribution models and customer journey analytics
• Experience using project management tools and collaboration platforms (e.g., Jira, Confluence, Slack)

Benefits

• Health, Vision, Dental
• 401K plan
• Life Insurance
• Pretax Commuter Benefits
• Medical, dental, vision
• 401K
• PTO
• Commuter benefits
• Spending accounts
• Life insurance
• Disability coverage
• EAPs