Data Engineer, Marketing Science
Posted 7hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Engineer building Snowflake and dbt data foundations for Power Digital’s MMM and incrementality products. Supporting AI-native growth marketing measurement across clients, channels, and ecommerce sources.
Responsibilities:
- Own the data behind Power Digital’s Media Mix Modeling (MMM) and incrementality testing (Matched Market Testing, MMT) products.
- Build and maintain model-ready daily and weekly Snowflake marts combining paid media, ecommerce revenue and orders, GA4, site, email/SMS, and non-media-driver data.
- 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, spend/revenue anomalies, mismatched markets, outliers, restatement drift, and source freshness.
- Maintain structured, versioned model logs and exported model outputs.
- Support onboarding of new measurement clients by mapping feeds, checking history and quality, and flagging gaps.
- Handle client-specific data needs, including overrides, channel mappings, and marts.
- Use AI coding tools and document effective development patterns.
- Support, maintain, and engineer data sources related to measurement and marketing metrics in collaboration with the Data Team.
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.
- Understanding of measurement-model data requirements: continuous time series, consistent granularity, stable channel definitions, sufficient history, and effects of anomalous weeks or markets.
- Experience building multi-client data models, with judgment about shared-core versus client-layer logic.
- Git and CI/CD with automated testing.
- 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
















