
Data Engineer, Marketing Science
Posted 6 hours ago

Posted 6 hours ago
This is a fully remote position, open to applicants in Mexico.
• Take ownership of the MMM data layer within Snowflake, ensuring the construction and upkeep of model-ready daily and weekly client marts.
• Integrate paid media, ecommerce revenue and orders, GA4, site data, email/SMS, and other non-media driver data while maintaining consistency in channels, currencies, and timezones.
• Manage the MMT geographic data layer at DMA/Comscore, state, and ZIP levels across leading media platforms and commerce sources.
• Develop and automate data-quality tests and alerts in Snowflake/dbt to identify gaps, anomalies, duplicates, freshness, and reconciliation issues.
• Keep versioned model logs and exported model outputs, encompassing contributions, response curves, adstock, and optimization results.
• Facilitate measurement-client onboarding by mapping feeds, reviewing historical data and quality, and identifying gaps.
• Address client-specific overrides, channel mappings, marts, and decisions related to shared-core versus client-layer logic.
• Utilize AI coding tools such as Claude Code, Cursor, Copilot, and Hex’s AI agent, documenting effective practices.
• Provide clean, model-ready MMM and MMT data to enhance measurement reliability, onboarding efficiency, and application performance.
• Minimum of 3 years in data or analytics engineering, including at least 1 year managing a significant production dbt project.
• Proficient in SQL and Python, with experience in production-grade pipeline coding.
• Extensive dbt knowledge: incremental models versus full refreshes, Jinja and macros, tests, snapshots, source freshness, exposures, and managing a large DAG effectively.
• Strong expertise in Snowflake: handling semi-structured/VARIANT data, dynamic per-client queries, query optimization, and managing permissions across distinct 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, and Shopify order and refund processes.
• Solid understanding of measurement model data requirements: continuous time series, consistent granularity, stable channel definitions, adequate historical data, and implications of data quality.
• Experience in constructing multi-client data models and determining whether logic should reside in the shared core or client layer.
• Familiarity with Git and CI/CD practices, including reliable automated testing.
• Genuine utilization of AI-assisted development workflows.
• Comfortable with iterative shipping based on feedback from analysts and application users.
• Advanced proficiency in spoken and written English is required.
• Beneficial but not mandatory: direct experience with MMM or incrementality; familiarity with geographic data; experience with Hex or comparable BI/notebook tools; background in agency, consultancy, or martech.
• Competitive base salary paid in USD, along with 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 your healthcare or insurance expenses.
• National Holidays plus two Mental Health Recharge Days each year.
• Unlimited opportunities for growth and leadership within a rapidly expanding organization.
• Ongoing employee development programs aimed at personal and professional growth (Hedgehog and Vital 5s).
• Quarterly awards that include 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.