Data Engineer – Marketing Science

Posted 7hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Data Engineer building Snowflake and dbt data foundations for MMM and incrementality testing. Supporting Power Digital’s AI-powered growth marketing services with reliable marketing measurement pipelines.

Responsibilities:

  • Own the data behind Power Digital's Media Mix Modeling (MMM) and incrementality testing (Matched Market Testing, MMT) measurement products.
  • Work closely with the Data Team to support, maintain, and engineer data sources related to measurement and marketing metrics.
  • Build and maintain model-ready daily and weekly Snowflake marts combining paid media, ecommerce revenue and orders, site and email/SMS data, and non-media drivers.
  • Build 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 gaps, zero-spend/revenue days, mismatches, duplicates, outliers, restatement drift, and source freshness.
  • Maintain versioned model logs and exported model outputs, including contributions, response curves, adstock, and optimization results.
  • Support onboarding of new measurement clients by mapping feeds, checking history depth and quality, and flagging gaps.
  • Handle client-specific overrides, channel mappings, and marts, determining whether logic belongs in the shared core or client layer.
  • Use AI coding tools including Claude Code, Cursor, Copilot, and Hex's AI agent; document reusable patterns.
  • Deliver clean, model-ready MMM and MMT data, prevent data issues from reaching models or test readouts, and build a scalable measurement data foundation.

Requirements:

  • Proficiency in spoken and written English at an advanced level is required for this role.
  • 3+ years in data or analytics engineering, including 1+ year owning a production dbt project of meaningful size.
  • Advanced SQL and Python, with production-grade pipeline code.
  • Deep dbt expertise: incremental models vs. full refreshes, Jinja and macros, tests, snapshots, source freshness, exposures, and keeping a large DAG under control.
  • Strong Snowflake skills: semi-structured/VARIANT data, dynamic per-client queries, query and cost tuning, permissions across separate client databases.
  • Hands-on marketing and ecommerce data experience: ad-platform APIs, UTMs, attribution windows, platform-reported vs. warehouse-reported conversions, Shopify order and refund logic.
  • An understanding of what measurement models need from data: a continuous time series, consistent granularity, stable channel definitions, enough history, and the reasons one bad week or market can skew results.
  • Experience building multi-client data models, with the judgment to know when logic belongs in the shared core and when it belongs in a client layer.
  • Git and CI/CD with automated testing you trust.
  • Real adoption of AI-assisted development workflows.
  • Comfort shipping iteratively based on feedback from analysts and app users.

Benefits:

  • Base salary paid in USD + commission opportunities
  • Unlimited Time Off available on day one
  • Fully flex work environment: full-remote, in-office, or hybrid
  • Healthcare stipend: $50/month to support your healthcare or insurance costs
  • National Holidays + 2 Mental Health Recharge Days per year
  • Unlimited opportunities for growth & leadership within a rapidly growing firm
  • Ongoing employee development programs for personal and professional growth (Hedgehog and Vital 5s)
  • Quarterly awards including prize money and recognition for outstanding performance
  • Opportunities to be involved in company DEI initiatives