Analytics Engineer – Campaign Intelligence, Ads

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Develop and maintain robust, scalable analytical models within the AWS Cloud environment.

• Engage in defining data requirements in collaboration with product and technology teams.

• Create ingestion, transformation, and data modeling pipelines utilizing the VTEX data platform.

• Assist stakeholders with technical and analytical issues, translating their needs into actionable solutions.

• Monitor performance, optimize queries, and ensure reliability in SQL and Python settings.

• Play a key role in promoting best practices and enhancing the evolution of the data stack.

• Convert advertiser, publisher, event, and performance data into reliable information for product, client, data science, and business teams.

⛳️ Requirements

• Knowledge of metrics and concepts related to ad tech/martech platforms (campaign performance, attribution, ROAS/CTR/CPC, etc.).

• Proficient in data modeling for large-scale analytics.

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

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

• Practical experience with orchestration and data transformation tools (Airflow, Python, Spark, EMR, Glue, etc.).

• Familiarity with AWS Cloud environments (preferably Redshift, S3, Glue, EMR).

• Hands-on experience using GenAI tools (e.g., GitHub Copilot, Claude Code, ChatGPT) to enhance daily development, debugging, and documentation processes.

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

• Knowledge of software engineering is an added advantage.

• Exceptional communication skills with the ability to engage both technical and non-technical audiences.

• An analytical mindset, strong problem-solving abilities, and a results-driven approach.

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

• A collaborative approach with a strong emphasis on organizational impact.

• A curious mindset, always striving to comprehend the underlying reasons behind issues before suggesting solutions.

🏝️ Benefits

• Annual profit-sharing program and eligibility for equity.

• Health, dental, and life insurance with national coverage provided by VTEX.

• Annual budget allocated for professional development in technology.

• Language development incentive program (English, Spanish, Portuguese).

• Flexible meal allowance.

• Extended parental leave options.

• Child-care assistance.

• Flexible work schedule and a remote-first culture.

• Financial support to establish your work-from-home setup.

• Wellness program.

• Free shipping across 1000+ VTEX stores.