Data Engineer, Marketing Science

Power Digital Marketing

Medellín

Híbrido

COP 398.420.000 - 630.831.000

Jornada completa

hace 23 horas
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Ventajas ofrecidas por este puesto de trabajo

Unlimited Time Off
Fully flexible work environment
Healthcare stipend

Descripción de la vacante

Power Digital Marketing is seeking a data analytics engineer to own the MMM data layer in Snowflake and build model-ready marts that merge paid media, ecommerce, and website data. You will develop MMT geo data layers, automate data quality checks, and maintain model outputs for analysts and clients.

The role requires advanced SQL, Python, and dbt expertise, with hands-on marketing data experience. A fully flexible work environment is available, with USD salary and commission opportunities.

Formación

  • 3+ years in data or analytics engineering or similar
  • Advanced SQL and Python in production pipelines
  • Deep dbt expertise including incremental models and tests
  • Strong Snowflake skills with VARIANT data and multi-client setup
  • Hands-on marketing and ecommerce data experience including UTMs and platform APIs
  • Experience building multi-client data models and AI-assisted development workflows

Responsabilidades

  • Own the MMM data layer in Snowflake and build model-ready marts
  • Own the MMT geo data layer with multi-channel data
  • Automate data quality checks and alerts in Snowflake/dbt
  • Maintain model logs and exported outputs for querying
  • Support onboarding of new measurement clients and data feeds
  • Write client-specific overrides and data layer mappings as needed
  • Collaborate with data teams and analysts to accelerate modeling

Conocimientos

Advanced SQL
Python
dbt
Snowflake
Marketing data experience

Educación

Bachelor's degree in a related field

Herramientas

Snowflake
dbt
Python
Hex/BI tooling

Descripción del empleo

Power Digital is an AI-Native Growth Firm built at the intersection of world-class talent and proprietary technology. We help leading and emerging brands grow by combining deep vertical expertise, strategic thinking, and enterprise intelligence to drive measurable business outcomes.

For more than a decade, we have built our business around one belief: the best technology makes great people better. Our teams of strategists, creatives, analysts, and technologists use Omega, our AI operating system, to surface opportunities faster, investigate what is driving performance, and execute approved work with greater speed and precision. Behind Omega is Iris, our proprietary intelligence layer, built on years of real performance data, strategic frameworks, testing, and learnings from across our client portfolio. AI expands the capacity of our people to think, create, solve harder problems, and make better decisions. Human judgment, creativity, and accountability remain central to how we work.

As a people-first firm, we value diversity in backgrounds and experiences. We strongly believe our people and culture are key to our success. We partner closely with our clients as an extension of their teams, working across strategy, execution, and measurement to identify what is truly blocking growth and determine what to do next. Our culture is built on people who are curious, ambitious, accountable, and committed to delivering meaningful results for our clients and for one another.

At Power Digital, we believe the future belongs to teams that combine the best talent with the best technology. We are building that future today.

***Proficiency in spoken and written English at an advanced level is required for this role.

A day in the life:

You'll sit on the fusepoint Marketing Science Team and own the data behind Power Digital's measurement products: Media Mix Modeling (MMM) and incrementality testing (Matched Market Testing, MMT). Our measurement tools are used by internal and external teams to read model results, plan budgets, pick test markets and report on incrementality tests. Your job is to make sure the data needed for measurement analysis is clean, reconciled and ready for modeling, so the analysts and data scientists spend their time on modeling, not cleanup.

You'll work closely with the Data Team to support, maintain, and engineer data sources related to measurement and marketing metrics.

Key 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 is read out.
  • 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.

Role Requirements:

  • 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.

Helpful but not required

  • Direct MMM or incrementality experience (Meridian, Robyn, PyMC-Marketing, synthetic control/causal impact, geo-lift).
  • Experience with geographic data: DMA/zip mappings, population and market-size data.
  • Hex experience (SQL/Python notebooks, semantic models, published apps), or similar BI/notebook tools.
  • Experience at an agency, consultancy or martech company.

Key Performance Indicators (KPIs)

  • MMT coverage: Geo-level MMT tables for all data sources are created and in use by the Measurement team in the first 3 months of the role
  • Measurement-ready data: Within 6 months, ≥95% of active MMM and MMT clients have automated, tested Snowflake marts feeding Hex, with no client-specific cleaning logic left in app notebooks for core sources.
  • Data quality: ≥99% completeness and accuracy on critical measurement fields. Zero model refreshes or test readouts delivered with an undetected date gap, duplicated market or unreconciled revenue source.
  • Reliability: ≥95% success rate for scheduled measurement pipelines, excluding documented vendor outages.
  • Speed and efficiency: Cut new-client measurement onboarding time (data mapping and validation) by 30% within 12 months. Measurably reduce load and refresh times for the main Hex measurement apps.
  • Client requests: Deliver ≥90% of client-specific measurement data requests within the agreed turnaround
  • AI-assisted development: At least 1 reusable AI-assisted development pattern documented within 120 days and 2 within 12 months, each used in at least 2 production workflows.

Most Important Things (MITs)

  • Deliver clean, model-ready MMM and MMT data in Snowflake so the measurement team’s data can be trusted without extra cleanup.
  • Build a process to catch data issues before they reach a model or test readout.
  • Build a single, documented measurement data foundation that grows with the client list and is ready for AI use.
  • Base salary paid in USD + commission opportunities
  • Unlimited Time Off available on day one
  • Fully flex work environment: full-remote, in-office, or hybrid
  • Healthcare stipend: $50/month to support your healthcare or insurance costs
  • National Holidays + 2 Mental Health Recharge Days per year
  • Unlimited opportunities for growth & leadership within a rapidly growing firm
  • Ongoing employee development programs for personal and professional growth (Hedgehog and Vital 5s)
  • Quarterly awards including prize money and recognition for outstanding performance
  • Opportunities to be involved in company DEI initiatives

Power Digital’s people and culture are at the core of our success, which is why diversity in our team’s backgrounds and experiences are paramount. We are an Equal Opportunity Employer and our employees are people with different strengths, experiences, and backgrounds, who strive to make an impact inside and outside of the workplace. Diversity not only includes race and gender identity, but also age, disability status, veteran status, sexual orientation, religion and many other parts of one’s identity. All of our employees' points of view are key to our success, and inclusion is everyone's responsibility.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Data Engineer, Marketing Science
Data Engineer, Marketing Science

Power Digital Marketing • Colombia

Híbrido
COP 298.408.000 - 497.347.000
Base salary in USD
Commission opportunities
Unlimited Time Off
+4
Data Engineer, Marketing Science
Data Engineer, Marketing Science

Power Digital • Colombia

Híbrido
COP 265.331.000 - 364.830.000
Data Engineer, AI & Analytics
Data Engineer, AI & Analytics

Power Digital Marketing • Colombia

Presencial
COP 133.920.000 - 200.880.000
CPG Marketing Account Director
CPG Marketing Account Director

Power Digital • Colombia

A distancia
COP 120.000.000 - 180.000.000
Commission opportunities
PTO 15 days
VTO 4 hours/quarter
+5
Fashion Paid Media Senior Performance Analyst
Fashion Paid Media Senior Performance Analyst

Power Digital Marketing • Colombia

Presencial
COP 60.000.000 - 120.000.000
Reporting Analyst, Consumer Services
Reporting Analyst, Consumer Services

Power Digital Marketing • Colombia

Presencial
COP 42.000.000 - 70.000.000
Senior Media Manager, Fashion
Senior Media Manager, Fashion

Power Digital • Colombia

A distancia
COP 97.094.000 - 174.769.000
Senior Paid Advertising Strategist, Fashion
Senior Paid Advertising Strategist, Fashion

Power Digital • Colombia

A distancia
COP 12.000.000 - 20.000.000
Paid Advertising Strategist - Ecommerce
Paid Advertising Strategist - Ecommerce

Power Digital Marketing • Colombia

A distancia
COP 60.000.000 - 90.000.000
CPG Paid Advertising Strategist, Client Experience
CPG Paid Advertising Strategist, Client Experience

Power Digital Marketing • Colombia

A distancia
COP 60.000.000 - 90.000.000