Job Summary: Senior Analytics Engineer to build and optimize data pipelines, ensuring accuracy and accessibility for analysis and monitoring, operating at the intersection of business, DataViz, and data infrastructure. Key Highlights: 1. Acts at the intersection of business requirements, DataViz, and data infrastructure. 2. Dynamic, collaborative environment focused on continuous improvement and autonomy. 3. Strong, vibrant culture with inspiring leadership and innovative teams. We are looking for a **Senior Analytics Engineer** with experience in **digital marketing** to join Vitrio’s Data Team! The professional will be responsible for building and optimizing data pipelines, ensuring data accuracy, accessibility, and readiness for analysis and monitoring. This role operates at the intersection of business requirements, the DataViz team, and data infrastructure, aiming to deliver reliable data for strategic decision-making. The work environment prioritizes dynamism, collaboration, continuous improvement, and autonomy. **Responsibilities and Duties** Responsibilities * Data Modeling: Design and maintain efficient, scalable data models in the Silver and Gold layers of the medallion architecture using SQL, to optimize consumption by BI tools and marketing analytics. * Data Quality Assurance: Implement and monitor data quality rules (with support from tools such as Dataplex), identify and resolve inconsistencies, ensuring data accuracy and reliability. * Optimization and Performance: Collaborate on optimizing query performance and data infrastructure to ensure agility in information delivery. * Documentation: Maintain up-to-date and clear technical and business documentation for pipelines, models, and data rules. * Support and Collaboration: Receive and address requests from marketing and data intelligence teams, transforming business requirements into robust data solutions. **Requirements and Qualifications** Technical Requirements * Programming: Practical experience with SQL (mandatory) and Python or R for script automation and data manipulation. * ETL/Orchestration Tools: Familiarity with pipeline orchestration tools (e.g., Apache Airflow, dbt) is a plus. * Google Cloud Platform (GCP): Knowledge of BigQuery, Looker Studio, and other GCP services. * Code Versioning: Experience with version control systems, preferably Git (BitBucket). * Database Concepts: Understanding of relational and non-relational databases, medallion architecture, and data flow design. * Tagging Concepts (GTM): Understanding of data flows collected via GTM. Digital Marketing Knowledge (Prerequisite) * Web Analytics: Experience with Google Analytics 4 (GA4 API, native GA4 \ BQ integration) and/or Adobe Analytics. * Advertising Platforms: Knowledge of data from Google Ads, Facebook Ads, TikTok Ads, etc. * E-commerce and CRM: Familiarity with data from platforms such as VTex, Magento, Salesforce, RDStation, Active Campaign. * Digital Marketing Concepts: Understanding of marketing metrics (ROI, CAC, LTV, conversion) and campaign data flows. **About Vitrio** Vitrio is a full-service agency within the B\&Partners ecosystem. We combine creativity, data, and technology to deliver comprehensive marketing solutions. With over 200 professionals, we operate in an integrated, results-oriented manner, headquartered in São Paulo and with talent distributed across Brazil—and even internationally. In practice, this means we foster a strong, vibrant culture where leadership inspires by example and every team is encouraged to experiment, learn, and innovate daily. **What We Do** We operate across the pillars of data, interaction, content, creation, development, experience, awareness, and performance—always focused on positively impacting our clients’ results, whether through lead generation, increased sales, or innovative digital solutions. **Our Way of Working** Being Vitrio means working as a team, respecting diversity, and continuously innovating. Here, we believe the best outcomes emerge from a safe, transparent, and healthy environment—where people’s well-being matters as much as the numbers. See how our team describes the experience of being here: *“An agency with a strong culture that puts into practice what leadership preaches.”* *“A place where people can grow and develop professionally through a solid, established career plan.”* *“A transparent agency where I feel safe, knowing what’s happening both internally and in the market we operate in.”* *“An environment where people truly care about their colleagues’ well-being and maintaining a healthy work routine.”* **What We’re Looking For** Curious, committed individuals who are passionate about results and skilled at teamwork. If you believe it’s possible to combine data and creativity to do things differently, this could be your place.