Power Digital

Data Engineer, Marketing Science

Power Digital
Apply
13 hours ago
Remote, MexicoMid Level

Responsibilities

  • Own and maintain Snowflake data marts for MMM, combining paid media, ecommerce, site, email/SMS, and non-media driver data with consistent channels, currencies, and timezones.
  • Build and maintain geo-level MMT media and sales tables across DMA, state, and ZIP levels for major advertising, CMS, CRM, Amazon, and retail data sources.
  • Automate Snowflake and dbt data quality tests and alerts for gaps, zero values, mismatches, duplicates, outliers, restatement drift, and source freshness.
  • Maintain structured, versioned, queryable model logs and exported outputs such as contributions, response curves, adstock, and optimization results.
  • Support measurement-client onboarding by mapping feeds, validating history and quality, and identifying data gaps before modeling.
  • Develop client-specific overrides, channel mappings, and marts while determining which logic belongs in shared or client-specific layers.
  • Use AI coding tools and document effective AI-assisted development patterns for team adoption.
  • Collaborate with data, analytics, data science, analysts, and app users to iteratively improve measurement data systems.

Requirements

  • 3+ years of experience in data or analytics engineering, including at least 1 year owning a meaningful production dbt project.
  • Advanced SQL and Python skills with production-grade pipeline development experience.
  • Deep dbt expertise including incremental models, full refreshes, Jinja, macros, tests, snapshots, source freshness, exposures, and DAG management.
  • Strong Snowflake experience with semi-structured or VARIANT data, dynamic client queries, query and cost tuning, and permissions across client databases.
  • Hands-on marketing and ecommerce data experience, including ad-platform APIs, UTMs, attribution windows, conversion reconciliation, Shopify orders, and refund logic.
  • Understanding of measurement-model data requirements including 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 or client-specific layers.
  • Experience with Git, CI/CD, and trusted automated testing.
  • Experience adopting AI-assisted development workflows and comfort shipping iteratively based on feedback.
  • Advanced spoken and written English proficiency.
  • Preferred: MMM or incrementality experience with tools or methods such as Meridian, Robyn, PyMC-Marketing, synthetic control, causal impact, or geo-lift.
  • Preferred: geographic data experience, including DMA or ZIP mappings, population data, and market-size data.
  • Preferred: Hex or similar BI/notebook tools and experience in an agency, consultancy, or martech company.

Benefits

  • Base salary paid in USD and commission opportunities are available; no specific compensation amount is stated.
  • Unlimited time off is available from day one.
  • Fully flexible work environment with full-remote, in-office, or hybrid options.
  • Offices are available in Buenos Aires, Medellin, San Diego, New York, and Atlanta.
  • Healthcare stipend of $50 per month is provided.
  • National holidays and two mental-health recharge days are provided annually.
  • Unlimited opportunities for growth and leadership are available.
  • Ongoing employee development programs include Hedgehog and Vital 5s.
  • Quarterly awards include prize money and recognition.
  • Employees may participate in company DEI initiatives.

Tech Stack

dbtGitPythonSnowflakeSQL

Categories

Data Engineering
Power Digital

About Power Digital

1,001-5,000 employees

Power Digital is a privately held marketing services firm that provides SEO, PPC, social, creative, web development, and conversion rate optimization to consumer and ecommerce brands. Founded in 2012 and headquartered in San Diego, it augments client work with nova, a proprietary platform that analyzes first-party data to inform channel and budget decisions. Engagements are typically retainer- or project-based.

Contact me