
Data Engineer, Marketing Science
Posted 5 hours ago

Posted 5 hours ago
This is a fully remote position, open to applicants in Brazil.
• Take charge of the data integral to Power Digital's Media Mix Modeling (MMM) and incrementality testing (Matched Market Testing, MMT) measurement products.
• Collaborate with the Data Team to support, maintain, and develop data sources related to measurement and marketing metrics.
• Create and sustain model-ready daily and weekly Snowflake marts that integrate paid media, e-commerce, GA4, email/SMS, and non-media data.
• Construct geo-level media and sales tables at DMA/Comscore, state, and ZIP levels across major advertising platforms and CMS/CRM/Amazon/Retail datasets.
• Automate Snowflake/dbt data-quality tests and alerts for identifying gaps, zero values, mismatches, duplicates, outliers, restatement drift, and source freshness.
• Keep versioned model logs and exported model outputs, which include contributions, response curves, adstock, and optimization results.
• Assist in onboarding new measurement clients by mapping feeds, verifying history and quality, and identifying gaps.
• Create client-specific overrides, channel mappings, and marts, determining whether logic should reside in the shared core or client layer.
• Leverage AI coding tools and document effective development practices for team implementation.
• Advanced proficiency in spoken and written English is mandatory for this position.
• Minimum of 3 years in data or analytics engineering, including at least 1 year managing a significant production dbt project.
• Strong skills in SQL and Python, with production-quality pipeline code experience.
• Extensive dbt knowledge: incremental models vs. full refreshes, Jinja and macros, tests, snapshots, source freshness, exposures, and managing a large DAG effectively.
• Proficient in Snowflake: handling semi-structured/VARIANT data, creating dynamic per-client queries, optimizing queries and costs, and managing permissions across different client databases.
• Practical experience with marketing and e-commerce data: ad-platform APIs, UTMs, attribution windows, differences between platform-reported and warehouse-reported conversions, as well as Shopify order and refund processes.
• Familiarity with the data requirements for measurement models: continuous time series, consistent granularity, stable channel definitions, adequate history, and understanding the impact of anomalous weeks or markets.
• Experience in developing multi-client data models, with discernment on shared-core versus client-layer logic.
• Knowledge of Git and CI/CD practices, including reliable automated testing.
• Genuine utilization of AI-assisted development workflows.
• Willingness to deliver iteratively based on feedback from analysts and application users.
• Base salary paid in USD plus commission opportunities.
• Unlimited Time Off available from day one.
• Fully flexible work environment: options for full-remote, in-office, or hybrid arrangements.
• Monthly healthcare stipend of $50 to assist with healthcare or insurance expenses.
• National Holidays plus two Mental Health Recharge Days each year.
• Unlimited opportunities for growth and leadership within a rapidly expanding company.
• Continuous employee development programs aimed at personal and professional advancement (Hedgehog and Vital 5s).
• Quarterly awards featuring prize money 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.