Power Digital

Data Engineer, Marketing Science

Power Digital
Apply
13 hours ago
Remote, ColombiaMid Level

Responsibilities

  • Own the Snowflake MMM data layer, including model-ready daily and weekly client marts combining paid media, ecommerce, site, email/SMS, and other marketing drivers.
  • Build and maintain DMA, state, and ZIP-level MMT geo data tables across media platforms, CRM, CMS, Amazon, and retail sources.
  • Automate Snowflake and dbt data quality tests and alerts for gaps, anomalies, duplication, freshness, reconciliation, and restatement issues.
  • Maintain structured, versioned 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 what logic belongs in shared or client-specific layers.
  • Use and document AI-assisted coding workflows to improve development speed and team adoption.
  • Collaborate with data, analyst, data science, and app-user teams and iteratively deliver measurement data capabilities.
  • Meet stated KPIs for MMT coverage, measurement-ready data, data quality, pipeline reliability, onboarding speed, client requests, and reusable AI-assisted development patterns.

Requirements

  • At least 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 covering incremental models, full refreshes, Jinja, macros, tests, snapshots, source freshness, exposures, and DAG management.
  • Strong Snowflake experience, including semi-structured and VARIANT data, dynamic per-client queries, query and cost tuning, and permissions across client databases.
  • Hands-on experience with marketing and ecommerce data, ad-platform APIs, UTMs, attribution windows, platform-versus-warehouse conversions, and Shopify order and refund logic.
  • Understanding of the data requirements of measurement models, including continuous time series, consistent granularity, stable channel definitions, sufficient history, and sensitivity to anomalous periods or markets.
  • Experience building multi-client data models and deciding whether logic belongs in a shared core or client layer.
  • Experience with Git and CI/CD and trusted automated testing.
  • Experience using AI-assisted development workflows and working iteratively from analyst and application-user feedback.
  • Advanced spoken and written English proficiency.
  • Preferred experience with MMM or incrementality tools and methods such as Meridian, Robyn, PyMC-Marketing, synthetic control, causal impact, or geo-lift.
  • Preferred experience with geographic data, DMA and ZIP mappings, population and market-size data, and Hex or comparable BI/notebook tools.
  • Agency, consultancy, or martech experience is helpful but not required.

Benefits

  • Base salary paid in USD with commission opportunities; no specific compensation amount is stated.
  • Unlimited time off 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.
  • $50-per-month healthcare stipend.
  • National holidays and two mental health recharge days per year.
  • Growth and leadership opportunities plus ongoing employee development programs.
  • Quarterly awards with prize money and recognition.
  • Opportunities to 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