Remote Data Engineer, Marketing Science & MMM

Power Digital Marketing

Colombia

Hybrid

COP 298,408,000 - 497,347,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Base salary in USD
Commission opportunities
Unlimited Time Off
Fully flexible: remote/on-site/hybrid
Healthcare stipend
Mental Health Days
Growth opportunities

Job summary

Power Digital Marketing is seeking a data/analytics engineer to own MMM and MMT data layers, build model-ready data marts, and automate data quality for multiple clients. You will collaborate with Data, Analytics, and Engineering teams to ensure scalable, reliable pipelines and AI-assisted development practices.

You will work on multi-client data models, leverage Snowflake, dbt, and Python to deliver measurement-ready data, and support onboarding of new clients while maintaining high data

Qualifications

  • 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.
  • An understanding of what measurement models need from data: a continuous time series, consistent granularity, stable channel definitions, enough history, and the reasons one bad week or market can skew results.
  • Experience building multi-client data models, with the judgment to know when logic belongs in the shared core and when it belongs in a client layer.
  • Git and CI/CD with automated testing you trust.
  • Real adoption of AI-assisted development workflows.
  • Comfort shipping iteratively based on feedback from analysts and app users.

Responsibilities

  • Own the MMM data layer in Snowflake. Build and maintain model-ready daily and weekly marts for each client that combine paid media (spend, impressions, clicks by channel and campaign), ecommerce revenue and orders (new vs. returning, gross and net, refunds, discounts), site and email/SMS data from GA4, and any non-media drivers.
  • Every mart has consistent channel groupings, currencies and timezones.
  • Own the MMT geo data layer. Build geo-level media and sales tables at DMA (or Comscore), state and zip level for every major platform (Meta, Google, TikTok, Pinterest, Amazon, Microsoft, Programmatic, etc.) and for CMS/CRM/Amazon/Retail Datsets, with standard market names that line up across sources.
  • These tables feed automated market selection, pre-period validation, synthetic control models and test readouts.
  • Build and automate a data quality process. Turn the checks we currently run manually into automated Snowflake/dbt tests and alerts: date gaps, zero-spend or zero-revenue days, cost without impressions (and the reverse), duplicated or unmatched markets, outlier spikes, restatement drift and source freshness.
  • Problems should be flagged before a model is trained or a test readout.
  • Own and maintain model logs and exported model outputs (contributions, response curves, adstock, optimization results) well structured, versioned and easy to query.
  • Support onboarding of new measurement clients. Own and maintain a repeatable, mostly automated process: map their data feeds, check history depth and quality, and flag gaps before modeling starts.
  • Handle client-specific data needs as they come up. You are not responsible for client workflow, but you may need to jump in to assist the team as things come up.. Write client-specific overrides, channel mappings and marts when a client needs them, and decide whether each piece of logic belongs in the shared core or in the client’s own layer.
  • Use AI coding tools to work faster (Claude Code, Cursor, Copilot, Hex’s AI agent), and document the patterns that work so the team adopts them.

Skills

Advanced SQL
Python
dbt
Data Modeling
ETL Pipelines
Git & CI/CD
AI-assisted development
Marketing analytics
Team collaboration

Tools

Snowflake
dbt
Git

Job description

Power Digital Marketing is seeking a data/analytics engineer to own MMM and MMT data layers, build model-ready data marts, and automate data quality for multiple clients. You will collaborate with Data, Analytics, and Engineering teams to ensure scalable, reliable pipelines and AI-assisted development practices.

You will work on multi-client data models, leverage Snowflake, dbt, and Python to deliver measurement-ready data, and support onboarding of new clients while maintaining high data

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer - Marketing Science & MMM (Remote)
Senior Data Engineer - Marketing Science & MMM (Remote)

Power Digital • Colombia

Hybrid
COP 265,331,000 - 364,830,000
Marketing Science Data Engineer: MMM & MMT on Snowflake
Marketing Science Data Engineer: MMM & MMT on Snowflake

Power Digital Marketing • Medellín

Hybrid
COP 398,420,000 - 630,831,000
Unlimited Time Off
Fully flexible work environment
Healthcare stipend
Data Engineer, Marketing Science
Data Engineer, Marketing Science

Power Digital Marketing • Medellín

Hybrid
COP 398,420,000 - 630,831,000
Unlimited Time Off
Fully flexible work environment
Healthcare stipend
AI-Powered Data Engineer for Analytics & Pipelines
AI-Powered Data Engineer for Analytics & Pipelines

Power Digital Marketing • Colombia

On-site
COP 133,920,000 - 200,880,000
Data Engineer, Marketing Science
Data Engineer, Marketing Science

Power Digital Marketing • Colombia

Hybrid
COP 298,408,000 - 497,347,000
Base salary in USD
Commission opportunities
Unlimited Time Off
+4
Data Engineer, AI & Analytics
Data Engineer, AI & Analytics

Power Digital Marketing • Colombia

On-site
COP 133,920,000 - 200,880,000
Marketing Analytics & Insights Specialist
Marketing Analytics & Insights Specialist

powerdigitalmarketing • Colombia

On-site
COP 79,684,000 - 139,447,000
Marketing Analytics & Insights Analyst
Marketing Analytics & Insights Analyst

Power Digital • Colombia

Remote
COP 42,000,000 - 65,000,000
Data Engineer, Marketing Science
Data Engineer, Marketing Science

Power Digital • Colombia

Hybrid
COP 265,331,000 - 364,830,000
Sr Data Engineer
Sr Data Engineer

Nearshore Business Solutions • Bogotá

Remote
COP 345,781,000 - 502,955,000