Analytics Engineer - Campaign Intelligence [Ads]

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

• Annual profit-sharing program and equity eligibility;
• Health, dental, and life insurance with national coverage provided by VTEX;
• Annual budget for professional development in Tech;
• Language development incentive program (English, Spanish, Portuguese);
• Flexible meal allowance;
• Extended parental leaves;
• Child-care assistance;
• Flexible work schedule and remote-first culture;
• Financial assistance to build your work-from-home setup;
• Wellness program;
• Free shipping on 1000+ VTEX stores

#LI-Remote