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…