Data Engineer, Marketing Science
Posted 6hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Engineer owning Snowflake and dbt data foundations for Power Digital’s MMM and incrementality products. Building reliable marketing measurement pipelines for client growth programs.
Responsibilities:
- Own the MMM data layer in Snowflake, building and maintaining model-ready daily and weekly client marts
- Combine paid media, ecommerce revenue and orders, GA4, site, email/SMS, and non-media driver data with consistent channels, currencies, and timezones
- Own the MMT geographic data layer at DMA/Comscore, state, and ZIP levels across major media platforms and commerce sources
- Build and automate Snowflake/dbt data-quality tests and alerts for gaps, anomalies, duplicates, freshness, and reconciliation issues
- Maintain versioned model logs and exported model outputs, including contributions, response curves, adstock, and optimization results
- Support measurement-client onboarding by mapping feeds, checking history and quality, and flagging gaps
- Handle client-specific overrides, channel mappings, marts, and shared-core versus client-layer logic decisions
- Use AI coding tools such as Claude Code, Cursor, Copilot, and Hex’s AI agent, and document effective patterns
- Deliver clean, model-ready MMM and MMT data and improve measurement reliability, onboarding speed, and application performance
Requirements:
- 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 data-quality impacts
- Experience building multi-client data models and deciding whether logic belongs in shared core or client layer
- Git and CI/CD with trusted automated testing
- Real adoption of AI-assisted development workflows
- Comfort shipping iteratively based on feedback from analysts and app users
- Advanced spoken and written English proficiency required
- Helpful but not required: direct MMM or incrementality experience; geographic data experience; Hex or similar BI/notebook tools; agency, consultancy, or martech experience
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
















