
Data Engineer, Marketing Science
Posted 9 hours ago

Posted 9 hours ago
This is a fully remote position, open to applicants in Colombia.
• 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.
• 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.
• 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.
Power Digital Marketing
Power Digital Marketing
Power Digital Marketing
Power Digital Marketing
Get handpicked remote jobs straight to your inbox weekly.