This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
EF Tours is looking for an experienced Marketing Data Engineer to architect the data foundation for our transition to the Salesforce Ecosystem. We are currently migrating our marketing automation to Salesforce Marketing Cloud (SFMC) and our CRM to Salesforce Sales Cloud. As the primary Data Engineer on the Digital Experience team, your main mission is to build the 'fuel' for this new engine. You will design and build the data models that populate Salesforce Marketing Cloud, ensuring our campaigns have the precise segmentation and personalization data they need. Secondarily, you will refactor our existing performance reporting models to align with this new Salesforce architecture. You will work with a modern data stack—Snowflake, dbt, Prefect, Python, and Fivetran—serving as the technical bridge between our data warehouse and our marketing platforms.
Job Responsibility:
Architect and build production-grade dbt models in Snowflake specifically designed to sync to SFMC Data Extensions
Partner with Marketing Operations to migrate data logic from legacy automation tool to SFMC
Define the data schema required to support journeys, dynamic content, and subscriber management
Consolidate 1st-party behavioral data (web/mobile), CDP data, and CRM data into a 'Golden Record' for marketing activation
Ensure that Contact Keys, Subscriber statuses, and opt-in preferences are modeled correctly to maintain compliance and data integrity within SFMC
Refactor existing performance models (Pipeline Velocity, Cost Per Lead) to consume Salesforce CRM data (Leads, Opportunities) instead of legacy CRM data
Extend models to incorporate new channels and deeper attribution logic
Manage the end-to-end data lifecycle using Fivetran (ingestion), Snowflake (warehousing), dbt (transformation), and Prefect (orchestration)
Monitor pipelines to ensure data arrives in SFMC and Power BI on time every morning
Requirements:
5+ years of Data Engineering experience, with a specific focus on Marketing Technologies (MarTech)
Expert-level SQL and deep experience building modular, tested models in dbt
Proficiency in Snowflake warehouse architecture and optimization
Strong Python scripting skills for orchestration and custom integrations
Understanding of how data enters Salesforce Marketing Cloud (Data Extensions, Contact Builder)
Knowledge of how to model data in a warehouse so it is ready for immediate use in a marketing journey
Sufficient knowledge of the Salesforce Sales Cloud schema (Leads, Contacts, Opportunities) to support the reporting refactor
Product-minded mindset, understanding that users are Marketers who need to launch campaigns and Analysts who need to report on leads
Nice to have:
Experience supporting Power BI datasets
Experience with Lytics or similar CDPs
Knowledge of SFMC Data Views (querying backend SFMC data) to extract campaign performance metrics back into Snowflake
What we offer:
Hybrid Model – up to one day working from home per week after completion of initial training period
22 paid vacation days, in addition to 12 paid national holidays
Comprehensive health insurance. Eligible after 3 month probation period
World-class office facilities that include parking, in-house gym, coffee station, and collaboration spaces
Seasonal and monthly office events including Holiday parties, Summer Party, and Mix & Mingles
EF Product Discounts (discounts on travel, international language schools, childcare with our Au Pair product and more)
STEP Program – Get an experiential travel opportunity in order to know more about our product from the travelers' perspective