Data Engineer, Marketing Science

21 hours, 58 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 and maintain Snowflake data marts for model-ready MMM data across paid media, ecommerce, site, email/SMS, and non-media drivers.
  • Build geo-level MMT media and sales tables across advertising platforms, CMS/CRM, Amazon, and retail data sources.
  • Standardize channel groupings, market names, currencies, timezones, and data granularity across sources.
  • Automate data-quality testing and alerts in Snowflake and dbt for gaps, anomalies, reconciliation issues, duplicates, and source freshness.
  • Maintain versioned, queryable model logs and exported outputs, including contributions, response curves, adstock, and optimization results.
  • Develop repeatable, largely automated onboarding processes for new measurement clients, including feed mapping, history validation, and gap identification.
  • Create client-specific mappings, overrides, and marts while determining whether logic belongs in shared or client-specific data layers.
  • Partner with the Data Team, analysts, and application users to maintain and improve measurement data sources and pipelines.
  • Use AI-assisted coding tools and document reusable development patterns for team adoption.

Requirements

  • 3+ years of data or analytics engineering experience, including 1+ year owning a production dbt project of meaningful size.
  • Advanced spoken and written English proficiency.
  • Advanced SQL and Python skills, including production-grade pipeline development.
  • Deep dbt expertise with incremental models, Jinja, macros, tests, snapshots, source freshness, exposures, and large DAG management.
  • Strong Snowflake experience, including VARIANT data, dynamic client queries, query and cost tuning, and permissions across separate client databases.
  • Hands-on experience with marketing and ecommerce data, including ad-platform APIs, UTMs, attribution windows, conversion reporting, and Shopify order and refund logic.
  • Understanding of measurement-model data needs, including continuous time series, stable channel definitions, consistent granularity, and sufficient history.
  • Experience designing multi-client data models and separating shared-core logic from client-specific layers.
  • Experience with Git, CI/CD, and trusted automated testing.
  • Experience using AI-assisted development workflows and iterating based on analyst and user feedback.
  • Direct MMM, incrementality, geo-lift, synthetic control, or causal impact experience (preferred).
  • Experience with geographic data, Hex or similar BI/notebook tools, or agency, consultancy, or martech environments (preferred).

Benefits

  • Base salary plus commission opportunities.
  • Prepaid medicine plan, paid social security, and legal benefits including Prima and Cesantias.
  • 15 paid vacation days annually, 17 Colombian national holidays, and 2 mental health recharge days.
  • Up to 4 hours of paid volunteer time off per quarter.
  • Flexible remote, hybrid, or in-office work options.
  • One-time COP 320,000 work-from-home stipend.
  • Employee Assistance Program.
  • Professional development programs, growth and leadership opportunities, quarterly performance awards, and 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, 43 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, 58 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, 58 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, 13 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