Data Engineer, Marketing Science

powerdigitalmarketing

Brasil

On-site

BRL 150,000 - 210,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Power Digital is an AI-Native Growth Firm. You will own the data behind measurement products like MMM and MMT, ensuring clean, reconciled data for modeling and reporting. Collaboration with the Data Team is key to maintaining source data quality and scalable pipelines.

The role emphasizes production dbt projects, advanced SQL/Python, and Snowflake expertise to support client analytics and growth initiatives.

Qualifications

  • 3+ years in data or analytics engineering.
  • 1+ year owning a production dbt project of meaningful size.
  • Advanced SQL and Python, with production-grade pipeline code.
  • Deep dbt expertise: incremental models, tests, and macros.
  • Strong Snowflake skills with VARIANT data and per-client queries.

Responsibilities

  • Own and maintain the data layer and model-ready marts for clients.
  • Build and automate data quality checks and alerts.
  • Maintain model logs and exported outputs, versioned and queryable.
  • Assist onboarding of new measurement clients and data feeds.
  • Collaborate with AI coding tools and document patterns for reuse.

Skills

SQL
Python
dbt
Snowflake
ETL pipelines

Tools

dbt
Snowflake

Job description

Who We Are:

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, permissi
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer, Marketing Science
Data Engineer, Marketing Science

Power Digital • Brazil

Remote
BRL 680,000 - 1,020,000
Fully remote work environment
Healthcare stipend
Unlimited time off
+1
Data Engineer, AI & Analytics
Data Engineer, AI & Analytics

Power Digital Marketing • Brazil

On-site
BRL 180,000 - 300,000
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Sorocaba

Hybrid
BRL 603,000 - 933,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Florianópolis

Hybrid
BRL 439,000 - 658,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Curitiba

Hybrid
BRL 603,000 - 905,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine • Recife

Hybrid
BRL 384,000 - 494,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine • São Bernardo do Campo

Remote
BRL 494,000 - 658,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • São Paulo

Hybrid
BRL 494,000 - 658,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Salvador

Remote
BRL 494,000 - 713,000
Professional growth
Competitive USD pay
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Campinas

Hybrid
BRL 494,000 - 713,000
Professional growth
Competitive compensation
Exciting projects
+1