Data Engineer, Marketing Science

21 hours, 48 minutes ago
Full-time
Mid Level
Software Development
Power Digital Marketing

Power Digital Marketing

Power Digital Marketing is a full-service digital marketing agency that specializes in creating innovative, data-driven marketing strategies to enhance brand presence and drive measurable growth across various service sectors.

Media
501-1000
Founded 2012

Description

  • Own Snowflake data marts for MMM, combining paid media, ecommerce, site, email/SMS, and non-media driver data at daily and weekly granularity.
  • Build geo-level MMT media and sales tables across advertising platforms, CMS/CRM, Amazon, and retail data sources.
  • Standardize channel groupings, currencies, time zones, and market naming across measurement data sources.
  • Automate data-quality tests and alerts for gaps, anomalies, reconciliation issues, duplicates, and source freshness using Snowflake and dbt.
  • Maintain versioned, queryable model logs and exported outputs, including contributions, response curves, adstock, and optimization results.
  • Create repeatable, largely automated onboarding processes for new measurement clients, including data-feed mapping and validation.
  • Develop client-specific overrides, channel mappings, and marts while determining whether logic belongs in shared or client-specific layers.
  • Partner with the Data Team, analysts, and application users to maintain and improve measurement data sources and pipelines.
  • Use AI coding tools to accelerate development and document reusable AI-assisted development patterns.

Requirements

  • 3+ years of data or analytics engineering experience, including 1+ year owning a production dbt project of meaningful size.
  • Advanced SQL and Python skills, including production-grade pipeline development.
  • Deep dbt expertise, including incremental models, Jinja, macros, tests, snapshots, source freshness, exposures, and DAG management.
  • Strong Snowflake experience with semi-structured/VARIANT data, dynamic per-client queries, query and cost tuning, and permissions across client databases.
  • Hands-on experience with marketing and ecommerce data, including ad-platform APIs, UTMs, attribution windows, conversion reporting, and Shopify order/refund logic.
  • Understanding of measurement-data requirements, including continuous time series, consistent granularity, stable channel definitions, and sufficient historical data.
  • Experience building multi-client data models and deciding between shared-core and client-specific logic.
  • Experience with Git, CI/CD, and automated testing.
  • Experience adopting AI-assisted development workflows and shipping iteratively based on analyst and user feedback.
  • Advanced spoken and written English proficiency.
  • Direct MMM or incrementality testing experience, geographic data experience, Hex or similar BI/notebook tool experience, and agency, consultancy, or martech experience are preferred.

Benefits

  • Base salary paid in USD plus commission opportunities.
  • Unlimited time off from day one.
  • Flexible remote, hybrid, or in-office work options.
  • $50/month healthcare stipend.
  • National holidays plus two mental health recharge days annually.
  • Professional and leadership development programs.
  • Quarterly performance awards with prize money and recognition.
  • Opportunities to participate in company DEI initiatives.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Head of Fund Analytics & Automation — Credit Fund

Xsolla 201-500 Internet Software & Services

Xsolla is seeking a Head of Fund Analytics & Automation to build and operate the data, automation, underwriting, and reporting platform for its emerging Credit Fund.

Apache Airflow PostgreSQL Power BI Python React SQL Tableau TypeScript
21 hours, 33 minutes ago

Data Engineer

Nimble Gravity 51-200 IT Services

Nimble Gravity is seeking a LATAM-based Data Engineer to build and scale production-ready data systems that support critical business needs.

Apache Airflow Apache Spark CI/CD Dagster Databricks dbt Feature Engineering LLM Machine Learning Python SQL
21 hours, 48 minutes ago

Lead Data Engineer

Egen.ai IT Services

Egen is hiring a Senior Data Engineer in Nashville to build and optimize GCP data and ML solutions that support data-driven healthcare decisions and improved patient outcomes.

Apache Airflow Apache Spark CI/CD dbt GCP Linux Machine Learning Python Salesforce Shell Scripting SQL Unix
21 hours, 48 minutes ago

Senior Data Engineers

Movement Labs 11-50 Media

Movement Labs is hiring Mid-level and Senior Data Engineers to build and operate data systems that support progressive advocacy, organizing, and electoral campaigns.

Apache Airflow Dagster dbt GCP Python SQL
22 hours, 3 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers