SFMC Consultant

About the Role

Key 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 across all channels including email, SMS, direct mail, and digital.
• Partner with Campaign Managers to translate marketing strategies into technical solutions within SFMC.
• Build tracking and reporting frameworks for multi-channel campaigns using SFMC tools, SQL reports, and Google Analytics dashboards.
• Develop and support A/B and multivariate testing frameworks, ensuring proper tracking and attribution setup.
• Maintain documentation and SOPs for campaign data flows, reporting schemas, and test result archiving.
• Collaborate with Legal, Compliance, and Privacy teams to ensure all campaign data and activations comply with regulations such as CAN-SPAM, TCPA, GDPR, CCPA.
• Serve as the first review point for incoming campaign data requests, assessing clarity, regulatory compliance, 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.
• Contribute to the development of a comprehensive marketing attribution model reflecting channel, content, and segment impact over time.

Requirements

• Hands-on advanced SQL skills for data extraction, transformation, and analysis within SFMC and related environments.
• Proven experience managing SFMC configurations, data architecture (Contact Builder, Data Extensions, SQL, Automations), and campaign deployment operations.
• Experience integrating SFMC with upstream systems using APIs, SFTP, and ETL frameworks.
• Familiarity with campaign tracking, test cell design, and tools like Google Analytics 360 and Excel for analysis.
• Understanding of marketing compliance standards and experience working with legal teams.
• Ability to communicate clearly with technical and non-technical stakeholders and translate business objectives into technical requirements.

Nice to Have

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

Qualifications

• Relevant experience managing SFMC configurations and data architecture.
• Expert-level SQL skills for data extraction, transformation, and analysis.
• Experience with data integration using APIs, SFTP, and ETL frameworks.
• Knowledge of marketing compliance standards and working with legal teams.

Benefits & Perks

• Competitive hourly pay starting at $65.00 per hour, dependent on experience and skills.
• Health, Vision, Dental insurance.
• 401K plan.
• Life Insurance.
• Pretax Commuter Benefits.
• Supportive team environment.
• Additional benefits including PTO, spending accounts, disability coverage, and EAPs.