SFMC Consultant

Blend is 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) 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’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 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.

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).

The starting pay range for this role is $65.00 per hour. Actual compensation within the range will be dependent on several factors including but not limited to relevant experience, skills, certifications, training, and location. It is not typical for an individual to be hired at or near the top of the range and determining factors for compensation are considered for each individual circumstance. BLEND360 also offers a competitive benefits program to meet the health and financial well-being of our team and their families. You can look forward to a range of benefits including medical, dental, vision, 401K, PTO, commuter benefits, spending accounts, life insurance, disability coverage, and EAPs.

A diverse workforce is a strong workforce
To deliver growth at BLEND360 and for our clients, we believe as a Talent Solutions Company, we have a responsibility and unique opportunity to positively impact the workforce. Diversity has played a critical role in our history, our growth, and continues to have a profound impact on our success.  We are determined to have equality in the workplace, within our team and as an extension of our clients’ team.

BLEND360 is an equal opportunity employer.