Analytics Engineer - Campaign Intelligence [Ads]

vtex

Brasil

Remote

BRL 250,000 - 450,000

Full time

9 days ago

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Benefits offered by this job

Profit-sharing program

Health, dental, and life insurance

Professional development budget

Language development program

Remote-first culture

Work-from-home setup support

Wellness program

Discounted shipping on VTEX stores

Job summary

VTEX is seeking a Senior Analytics Engineer to build robust, integrated data models for the VTEX Ads platform. You will model data across advertisers, publishers, events (clicks, views, impressions) to support product, clients, data science, and business teams, delivering scalable pipelines from requirements to production in our Lakehouse.

Join Campaign Intelligence to shape data serving for pacing, ROAS, budget forecasting, and auction optimization.

Qualifications

Experience building large-scale analytics data models.
Proficient in SQL, Python, and Spark for data transformations.
Strong knowledge of AWS data warehouses (Redshift, S3, Glue).
Experience with ETL/ELT pipelines and orchestration (Airflow).
Familiarity with ad tech/m martech metrics (ROAS, CTR, CPC).
Knowledge of semantic data layers (dbt, LookML) is a plus.

Responsibilities

Build and maintain scalable analytical models in AWS Cloud.
Define data requirements with product and tech teams.
Develop ingestion, transformation, and data modeling pipelines.
Support stakeholders with technical and analytical topics.
Monitor performance and optimize queries in SQL and Python.
Spread best practices and evolve the data stack.

Skills

Ad tech metrics

Data modeling

AWS data warehousing

SQL

Python

Spark

Airflow

dbt semantic layer

GenAI tools

Communication

Analytical mindset

Autonomy

Tools

Athena

Redshift

Looker/BI tools

ETL tools

Job description

ABOUT THE ROLE

We are looking for a Senior Analytics Engineer to bring robust, integrated data models and products to life within the VTEX Ads platform. You will be the data modeling reference point across the entire Ads ecosystem-advertisers, publishers, events (clicks, views, impressions), and performance-translating these domains into reliable data for product, client, data science, and business teams. From requirements gathering to production pipelines in our Lakehouse, you will ensure scalability and reliability for decisions that sustain the platform's operations and revenue.

ABOUT THE TEAM

You will join Campaign Intelligence, the newest team in our Data & Analytics organization, focused on the engine behind the VTEX Ads platform: pacing, target ROAS, budget forecasting, and auction optimization. We are responsible for structuring and serving this platform's data, giving product, data science, business teams, and clients reliable visibility into advertisers, publishers, and Ads performance-accelerating data-driven decisions on a global scale.

WHAT YOU WILL DO

Build and maintain robust, scalable analytical models in AWS Cloud.

Participate in defining data requirements alongside product and technology teams.

Develop ingestion, transformation, and data modeling pipelines using the VTEX data platform.

Support stakeholders with technical and analytical topics, translating needs into practical solutions.

Monitor performance, optimize queries, and ensure reliability across SQL and Python environments.

Contribute to spreading best practices and driving the evolution of the data stack.

WHO YOU ARE

Hard Skills

Familiarity with metrics and concepts from ad tech/martech platforms (campaign performance, attribution, ROAS/CTR/CPC, etc.).

Experienced in data modeling for large-scale analytics.

Experienced with databases and data warehouses on AWS (Athena, Trino, Redshift, etc.).

Advanced SQL, Spark, and Python, along with query optimization skills.

Hands-on experience with orchestration and data transformation tools (Airflow, Python, Spark, EMR, Glue, etc.).

Knowledge of AWS Cloud environments (preferably Redshift, S3, Glue, EMR).

Practical experience using GenAI tools (e.g., GitHub Copilot, Claude Code, ChatGPT) to accelerate daily development, debugging, and documentation.

Knowledge of semantic data layers (dbt semantic layer, LookML, Cube, etc.).

Knowledge of software engineering is considered a plus.

Soft Skills

Excellent communication skills with the ability to engage both technical and business audiences.

Analytical mindset, strong problem-solver, and results-oriented.

Autonomy, proactivity, and comfort working in dynamic, iterative environments.

Collaborative mindset with a strong focus on organizational impact.

Curious mindset, always seeking to understand the \"why\" behind problems before proposing solutions.

About VTEX

VTEX (NYSE: VTEX) is the composable and complete commerce platform that delivers more efficiency and less maintenance to organizations seeking to make smarter IT investments and modernize their tech stack. Through our pragmatic composability approach, we empower brands, distributors, and retailers with unparalleled flexibility and comprehensive solutions, enabling them to invest solely in what provides a clear business advantage and boosts profitability. VTEX is trusted by 2,400 global B2C and B2B customers, including Carrefour, Colgate, Motorola, Sony, Stanley Black & Decker, and Whirlpool, having 3,400 active online stores across 43 countries (as of FY ended on December 31, 2024). Founded in the year 2000, VTEX has a history of being unstoppable. Completely against the odds, VTEX is leading a high-tech industry and positioned above market giants. We are building an extraordinary future with more than 1,300 employees scattered across 25 locations in 16 countries in Latin America, North America, Europe, and Asia. For more information, visit www.vtex.com .

BENEFITS