Analytics Engineer - Campaign Intelligence [Ads]

vtex

United States

Remote

USD 150,000 - 230,000

Full time

14 days+

Get a reply from this employer

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

Get past ATS filters

Benefits offered by this job

Profit-sharing program
Health, dental & life insurance
Professional development budget
Language learning incentive
Home office stipend

Job summary

VTEX is seeking a Senior Analytics Engineer to own integrated data models powering pacing, budget forecasting, target ROAS, and auction optimization within a Campaign Intelligence team. You will translate advertiser, publisher, and event data into reliable datasets for product, data science, business, and client teams, spanning requirements to production pipelines in a cloud lakehouse.

.Lean on your AWS/Redshift experience to design scalable models, optimize SQL/Python, and drive data-driven

Qualifications

  • Senior-level experience in data modeling and large-scale data warehousing on AWS (Redshift, Athena/Trino, Glue, EMR, S3).
  • Advanced proficiency in SQL, Spark, and Python, including hands-on work with query optimization.
  • Experience with orchestration/transformation tools such as Airflow, Spark, Glue, and EMR.
  • Familiarity with ad tech and martech metrics (ROAS, CTR, CPC, attribution, campaign performance).
  • Working knowledge of semantic data layers (dbt semantic layer, LookML, Cube).
  • Hands-on use of AI-assisted development tools to accelerate coding, debugging, and documentation.
  • Strong communication skills with the ability to engage both technical and business audiences, plus an analytical, autonomous and collaborative style.

Responsibilities

  • Design, build, and maintain scalable analytical data models in an AWS-based lakehouse environment.
  • Partner with product and technology stakeholders to define data requirements and shape the evolution of the data stack.
  • Develop ingestion, transformation, and modeling pipelines using modern orchestration and data processing tools.
  • Translate analytical and technical needs from non-technical audiences into practical data solutions.
  • Monitor pipeline and query performance, optimize SQL and Python code, and uphold reliability standards.
  • Champion engineering best practices and contribute to community knowledge sharing across the data organization.

Skills

Data modeling
SQL
Python
Spark
AWS Redshift
ETL pipelines
Airflow
dbt semantic layer
LookML
Cube

Tools

dbt
LookML
Cube

Job description

Role overview

A senior analytics engineering role sits within a Campaign Intelligence team powering a large-scale ads platform. The position owns the integrated data models behind pacing, budget forecasting, target ROAS, and auction optimization, translating advertiser, publisher, and event domains into reliable datasets for product, data science, business, and client teams. Work spans the full lifecycle from requirements gathering through production pipelines in a cloud lakehouse.

Responsibilities
  • Design, build, and maintain scalable analytical data models in an AWS-based lakehouse environment.
  • Partner with product and technology stakeholders to define data requirements and shape the evolution of the data stack.
  • Develop ingestion, transformation, and modeling pipelines using modern orchestration and data processing tools.
  • Translate analytical and technical needs from non-technical audiences into practical data solutions.
  • Monitor pipeline and query performance, optimize SQL and Python code, and uphold reliability standards.
  • Champion engineering best practices and contribute to community knowledge sharing across the data organization.
Requirements
  • Senior-level experience in data modeling and large-scale data warehousing on AWS (Redshift, Athena/Trino, Glue, EMR, S3).
  • Advanced proficiency in SQL, Spark, and Python, including hands-on work with query optimization.
  • Practical experience with orchestration and transformation tools such as Airflow, Spark, Glue, and EMR.
  • Familiarity with ad tech and martech metrics, including ROAS, CTR, CPC, attribution, and campaign performance concepts.
  • Working knowledge of semantic data layers (e.g., dbt semantic layer, LookML, Cube).
  • Hands-on use of AI-assisted development tools to accelerate coding, debugging, and documentation.
  • Strong communication skills with the ability to engage both technical and business audiences, plus an analytical, autonomous, and collaborative working style.
Nice to have
  • Background in software engineering practices applied to data workloads.
Benefits and work setup
  • Annual profit-sharing program with equity eligibility.
  • Health, dental, and life insurance coverage.
  • Dedicated annual budget for professional development in technology.
  • Language learning incentive program across English, Spanish, and Portuguese.
  • Flexible meal allowance, extended parental leaves, and child-care assistance.
  • Flexible schedule within a remote-first culture, plus financial support to build a home office setup.
  • Wellness program and additional perks tied to a large partner ecosystem.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Software Engineer
Senior Software Engineer

Audiohook • United States

Hybrid
USD 150,000 - 190,000
Equity opportunities
Performance bonuses
401(k) and health coverage
+1
Analytics Engineer
Analytics Engineer

hextechnologies • United States

Hybrid
USD 153,000 - 205,000
Equity
Health coverage
Flexible paid time off
Data Engineer, Advertising Demand Enablement & Product Ops (DEPO)
Data Engineer, Advertising Demand Enablement & Product Ops (DEPO)

Amazon Inc. • New York (NY)

On-site
USD 145,000 - 197,000
Sign-on RSUs
Health insurance
401(k) matching
+2
Marketing Analytics Engineer
Marketing Analytics Engineer

Gympass • United States

Remote
USD 32,000 - 42,000
Home-office reimbursement
Flexible scheduling
Health insurance
+5
Data Engineer, AI & Analytics
Data Engineer, AI & Analytics

powerdigitalmarketing • United States

Remote
USD 110,000 - 180,000
Senior Analytics Engineer (Data Modeling & BI)
Senior Analytics Engineer (Data Modeling & BI)

feverup • United States

Hybrid
USD 110,000 - 170,000
Home-office setup
Health insurance
Stock options
+3
Senior Data Engineer
Senior Data Engineer

Throttle Up Technologies, LLC • United States

Remote
USD 100,000 - 160,000
Dental insurance
Health insurance
Life insurance
+2
Staff Applied Scientist, AdTech
Staff Applied Scientist, AdTech

launchpotato • United States

Remote
USD 150,000 - 230,000
Remote-first
(Senior) Analytics Engineer
(Senior) Analytics Engineer

tubescience52 • Los Angeles (CA)

On-site
USD 110,000 - 165,000
Revenue Analytics Manager
Revenue Analytics Manager

fundraiseup • United States

Remote
USD 149,000 - 162,000
Health insurance
Dental & vision insurance
401(k) match
+4