The travel and hospitality client needs to manage and enhance end-to-end data operations within their technical environment to optimize marketing campaign performance through advanced data management, seamless integration, and user-focused solutions.
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.
- 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.
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.
- Build tracking and reporting frameworks for multi-channel campaigns using SFMC native tools, SQL reports, and Google Analytics dashboards.
Other
- Remote within the U.S.
- Approximately a 6-month consulting role through Blend360 with the possibility of extension
- Partner with Campaign Managers to translate marketing strategies into executable technical solutions within SFMC.
- 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.
