> Markdown version of [/jobs/ext/4719486-analytics-engineer-campaign-intelligence-ads](https://www.wearedevelopers.com/jobs/ext/4719486-analytics-engineer-campaign-intelligence-ads). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Analytics Engineer - Campaign Intelligence [Ads] - **Company:** VTEX Commerce Cloud Solutions LLC - **Location:** Brazil, IN, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Airflow, Amazon Web Services, Amazon S3, Data Analysis, Databases, Data Infrastructure, Data Transformation, Data Warehousing, Software Debugging, Python (Programming Language), Query Optimization, Requirements Management, Software Engineering, SQL Databases, Cloud Platform System, Sql Optimization, GitHub Copilot, Claude Code, Apache Spark, Electronic Medical Records, Generative AI, Data Layers, Data Analytics, Performance Monitor, GPT - **Published:** November 14, 2026 - **Apply:** https://www.careerbuilder.com/job-details/analytics-engineer-campaign-intelligence-ads-brazil-in--fdca56bb-d679-4b94-a61e-f0e4f83d80ed ## About the Role Campaigns, Ecosystems, Data Modeling, Data Science, Requirements Management, Customer/Client Research, Budget Forecasting, Campaigns, Data Analysis, Amazon Web Services (AWS), * 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. ## Description 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.