Data Engineer, Marketing Science

Posted 5 hours ago

This is a fully remote position, open to applicants in Colombia.

📋 Description

• Take ownership of the MMM data layer in Snowflake by developing and sustaining model-ready daily and weekly client marts that integrate paid media, ecommerce, site, email/SMS, and non-media data.

• Manage the MMT geographic data layer by constructing media and sales tables at the DMA/Comscore, state, and ZIP code levels across major platforms and data sources.

• Create and automate data-quality tests and alerts in Snowflake/dbt to identify gaps, zero activity, mismatches, duplicates, outliers, restatement drift, and source freshness.

• Maintain organized, versioned model logs and exported outputs that include contributions, response curves, adstock, and optimization results.

• Assist in the onboarding of new measurement clients by mapping feeds, verifying historical data and quality, and flagging any gaps prior to modeling.

• Address client-specific data requirements through overrides, channel mappings, and marts while determining the balance between shared-core and client-layer logic.

• Utilize AI coding tools such as Claude Code, Cursor, Copilot, and Hex's AI agent, while documenting reusable patterns.

• Collaborate with the Data Team to support, maintain, and engineer measurement and marketing-metric data sources.

• Ensure the delivery of clean, model-ready data and prevent data issues from impacting models or test readouts.


⛳️ Requirements

• Minimum of 3 years in data or analytics engineering, including at least 1 year managing a production dbt project of significant size.

• Proficient in SQL and Python, with experience in writing production-grade pipeline code.

• Extensive dbt knowledge: understanding of incremental models versus full refreshes, Jinja and macros, tests, snapshots, source freshness, exposures, and managing a large Directed Acyclic Graph (DAG).

• Strong expertise in Snowflake: working with semi-structured/VARIANT data, creating dynamic per-client queries, optimizing queries and costs, and managing permissions across separate client databases.

• Practical experience with marketing and ecommerce data: familiarity with ad-platform APIs, UTMs, attribution windows, differences between platform-reported and warehouse-reported conversions, and Shopify order and refund logic.

• Knowledge of measurement model data requirements: continuous time series, consistent granularity, stable channel definitions, adequate history, and impacts on data quality.

• Experience in building multi-client data models and determining whether logic should reside in the shared core or a client layer.

• Proficient in Git and CI/CD practices with reliable automated testing.

• Genuine engagement with AI-assisted development workflows.

• Ability to deliver iteratively based on feedback from analysts and application users.

• Advanced proficiency in spoken and written English is mandatory.

• Beneficial but not essential: direct experience with MMM or incrementality; experience with geographic data; familiarity with Hex or similar BI/notebook tools; background in agency, consultancy, or martech sectors.


🏝️ Benefits

• Competitive base salary plus commission opportunities.

• Prepaid Medicine Plan.

• 15 days of paid vacation (PTO) each year.

• Up to 4 hours per quarter for paid Volunteer Time Off (VTO) for charitable activities.

• Flexible work environment: fully remote, in-office, or hybrid options available.

• One-time Work From Home (WFH) stipend of 320.000 COP automatically included in your first paycheck.

• Access to an Employee Assistance Program (EAP).

• 17 recognized Colombian national holidays plus 2 mental health recharge days annually.

• Legal benefits such as Prima and Cesantias.

• Paid Social Security contributions.

• Unlimited opportunities for growth and leadership in a rapidly expanding company.

• Continuous employee development programs for both personal and professional advancement (Hedgehog and Vital 5s).

• Quarterly awards that include monetary prizes and recognition for exceptional performance.

• Opportunities to participate in company Diversity, Equity, and Inclusion (DEI) initiatives.

People also viewed

Power Digital Marketing5 hours ago

Data Engineer, Marketing Science

BR flagBrazil OnlyFull-timeData Engineer
ApplyView job
Power Digital Marketing6 hours ago

Data Engineer, Marketing Science

MX flagMexico OnlyFull-timeData Engineer
ApplyView job
Power Digital Marketing6 hours ago

Data Engineer – Marketing Science

AR flagArgentina OnlyFull-timeData Engineer
ApplyView job
Nimble Gravity6 hours ago

Data Engineer

Latin AmericaFull-timeData Engineer
ApplyView job
Power Digital Marketing9 hours ago

Data Engineer, Marketing Science

CO flagColombia OnlyFull-timeData Engineer
ApplyView job
Nimble Gravity10 hours ago

Senior Data Architect

US flagUnited States OnlyFull-timeData Engineer
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers