Data Engineer, Marketing Science

Posted 9 hours ago

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

📋 Description

• Take ownership of the data related to Power Digital’s Media Mix Modeling (MMM) and incrementality testing (Matched Market Testing, MMT) offerings.

• Construct and sustain model-ready daily and weekly Snowflake marts that integrate paid media, ecommerce revenue and orders, GA4, site, email/SMS, and non-media-driver data.

• Develop geo-level media and sales tables at DMA/Comscore, state, and zip levels across major advertising platforms and CMS/CRM/Amazon/Retail datasets.

• Automate data-quality tests and alerts in Snowflake/dbt to identify gaps, anomalies in spend/revenue, mismatched markets, outliers, restatement drift, and source freshness.

• Keep structured, versioned model logs and exported outputs of the models.

• Assist in the onboarding process of new measurement clients by mapping feeds, verifying historical data and quality, and highlighting any gaps.

• Address client-specific data requirements, including overrides, channel mappings, and marts.

• Utilize AI coding tools and document efficient development practices.

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


⛳️ Requirements

• Advanced proficiency in both spoken and written English is essential for this position.

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

• Expertise in SQL and Python, with production-level pipeline code experience.

• In-depth knowledge of dbt: understanding incremental models versus full refreshes, Jinja and macros, tests, snapshots, source freshness, exposures, and managing a large DAG effectively.

• Strong skills in Snowflake: working with semi-structured/VARIANT data, creating dynamic queries per client, 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, discrepancies between platform-reported and warehouse-reported conversions, as well as Shopify order and refund logic.

• Comprehension of measurement-model data requirements: continuous time series, consistent granularity, stable channel definitions, adequate historical data, and the impact of anomalous weeks or markets.

• Experience in constructing multi-client data models, with insight into shared-core versus client-layer logic.

• Knowledge of Git and CI/CD practices with automated testing.

• Genuine engagement with AI-assisted development methodologies.

• Willingness to deliver iteratively based on insights from analysts and application users.


🏝️ Benefits

• Base salary paid in USD plus commission opportunities.

• Unlimited Time Off available from day one.

• Fully flexible work environment: full-remote, in-office, or hybrid options.

• Healthcare stipend of $50/month to assist with healthcare or insurance expenses.

• National Holidays plus 2 Mental Health Recharge Days annually.

• Unlimited opportunities for advancement and leadership within a rapidly expanding company.

• Continuous employee development programs aimed at personal and professional growth (Hedgehog and Vital 5s).

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

• Opportunities to engage in company DEI initiatives.

People also viewed

Power Digital Marketing5 hours ago

Data Engineer, Marketing Science

CO flagColombia OnlyFull-timeData Engineer
ApplyView job
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
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