Analytics Engineer - Campaign Intelligence

VTEX

United States

Remote

USD 120,000 - 190,000

Full time

7 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Profit-sharing

Equity eligibility

Health, dental, life insurance

Professional development budget

Language development incentive

Meal allowance

Parental leave

Child-care assistance

Remote-first culture

Work-from-home setup

Wellness program

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, and performance, enabling reliable insights for product, client, data science, and business teams.

You’ll design and implement ingestion, transformation, and data pipelines in a Lakehouse environment, ensuring scalability and reliability for decisions driving platform revenue.

Qualifications

Advanced SQL, Python, Spark, and data modeling experience in large analytics environments.
Experience with AWS data services (Athena, Redshift, S3) and data warehouse concepts.
Familiarity with orchestration and transformation tools like Airflow, Spark, EMR, Glue.

Responsibilities

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

Skills

Advanced SQL

Python

Spark

Data modeling

AWS

dbt LookML

Tools

Airflow

ETL

Spark

EMR

Glue

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.

At VTEX, you will work in a challenge-driven environment and collaborate with amazing peers. If you are powerful individually, join us, and we will be unstoppable together.

BENEFITS