Senior Marketing Data Engineer

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.What You’ll Do1. SFMC Activation Modeling (Primary Focus)

Power Salesforce Marketing Cloud: Architect and build production-grade dbt models in Snowflake specifically designed to sync to SFMC Data Extensions.

Support the Migration: Partner with Marketing Operations to migrate data logic from our legacy automation tool to SFMC. You will define the data schema required to support journeys, dynamic content, and subscriber management.

Unified Customer Profile: Consolidate 1st-party behavioral data (web/mobile), CDP data, and CRM data into a "Golden Record" for marketing activation.

Data Hygiene: Ensure that Contact Keys, Subscriber statuses, and opt-in preferences are modeled correctly to maintain compliance and data integrity within SFMC.

2. Performance Model Refactoring (Secondary Focus)

Refactor for Salesforce CRM: We have existing performance models (Pipeline Velocity, Cost Per Lead) that need to be pointed to a new source of truth. You will refactor these models to consume Salesforce CRM data (Leads, Opportunities) instead of legacy CRM data.

Enhance Analytics: As business maturity evolves, you will extend these models to incorporate new channels and deeper attribution logic, ensuring Business Analysts have a reliable dataset for Power BI reporting.

3. ELT Pipeline Ownership

Own the Stack: Manage the end-to-end data lifecycle using Fivetran (ingestion), Snowflake (warehousing), dbt (transformation), and Prefect (orchestration).

Reliability: Monitor pipelines to ensure data arrives in SFMC and Power BI on time every morning.

Who You Are

Experience: 5+ years of Data Engineering experience, with a specific focus on Marketing Technologies (MarTech).

The Stack (Must Haves):

SQL & dbt: Expert-level SQL and deep experience building modular, tested models in dbt.

Snowflake: Proficiency in warehouse architecture and optimization.

Python: Strong scripting skills for orchestration and custom integrations.

Domain Knowledge:

Salesforce Marketing Cloud (SFMC): You understand how data enters SFMC (Data Extensions, Contact Builder). You know how to model data in a warehouse so it is ready for immediate use in a marketing journey.

Salesforce CRM: Sufficient knowledge of the Sales Cloud schema (Leads, Contacts, Opportunities) to support the reporting refactor.

Mindset: You are "product-minded." You understand that your "users" are Marketers who need to launch campaigns and Analysts who need to report on leads, and you build your models to serve them.

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.

Why you’ll love working here:

Join an amazing team of passionate individuals from across the globe.

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

Yearly tuition reimbursement up to 1500 USD

Discounts at local venues and businesses.