
Data Engineer – Marketing Science
Posted 6 hours ago

Posted 6 hours ago
This is a fully remote position, open to applicants in Argentina.
• Take ownership of the data supporting Power Digital's Media Mix Modeling (MMM) and incrementality testing (Matched Market Testing, MMT) measurement products.
• Collaborate closely with the Data Team to assist, sustain, and develop data sources related to measurement and marketing metrics.
• Create and maintain model-ready daily and weekly Snowflake marts that integrate paid media, ecommerce revenue and orders, site and email/SMS data, along with non-media drivers.
• Construct geo-level media and sales tables at DMA/Comscore, state, and ZIP code levels across significant advertising platforms and CMS/CRM/Amazon/Retail datasets.
• Automate data quality tests and alerts in Snowflake/dbt for gaps, zero-spend/revenue days, discrepancies, duplicates, outliers, restatement drift, and source freshness.
• Maintain versioned model logs and exported model outputs, which include contributions, response curves, adstock, and optimization results.
• Assist in onboarding new measurement clients by mapping data feeds, verifying history depth and quality, and identifying gaps.
• Manage client-specific overrides, channel mappings, and marts, deciding whether logic should reside in the shared core or client layer.
• Utilize AI coding tools such as Claude Code, Cursor, Copilot, and Hex's AI agent; document reusable patterns.
• Deliver clean, model-ready MMM and MMT data, prevent data issues from affecting models or test readouts, and establish a scalable measurement data foundation.
• Advanced proficiency in both spoken and written English is essential for this position.
• A minimum of 3 years in data or analytics engineering, with at least 1 year managing a production dbt project of significant scale.
• Advanced skills in SQL and Python, with experience in production-grade pipeline code.
• Extensive dbt knowledge: understanding of incremental models vs. full refreshes, Jinja and macros, tests, snapshots, source freshness, exposures, and managing a large DAG effectively.
• Strong capabilities in Snowflake: working with semi-structured/VARIANT data, dynamic queries per client, query and cost optimization, and managing permissions across different client databases.
• Practical experience with marketing and ecommerce data: familiarity with ad-platform APIs, UTMs, attribution windows, and the nuances between platform-reported and warehouse-reported conversions as well as Shopify order and refund processes.
• Insight into the data requirements for measurement models: continuous time series, consistent granularity, stable channel definitions, sufficient historical data, and the impact of one poor week or market on results.
• Experience in constructing multi-client data models, with the discernment to determine when logic should reside in the shared core versus a client layer.
• Proficient in Git and CI/CD practices with reliable automated testing.
• Genuine implementation of AI-assisted development workflows.
• Comfortable with iterative shipping based on feedback from analysts and application users.
• Base salary paid in USD with commission opportunities.
• Unlimited Time Off available from day one.
• Fully flexible work environment: fully remote, in-office, or hybrid options.
• Healthcare stipend of $50 per month to support healthcare or insurance expenses.
• National Holidays plus 2 Mental Health Recharge Days each year.
• Unlimited opportunities for growth and leadership within a rapidly expanding company.
• Continuous employee development programs focused on personal and professional growth (Hedgehog and Vital 5s).
• Quarterly awards including monetary prizes and recognition for exceptional performance.
• Opportunities to participate in company DEI initiatives.
Power Digital Marketing
Power Digital Marketing
Power Digital Marketing
Get handpicked remote jobs straight to your inbox weekly.