Analytics Engineer - Especialista I (Diretoria de Dados) · [CONFIDENCIAL]

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for an Analytics Engineer -- Specialist I (Data Directorate) based in Brazil.

We are seeking an experienced Analytics Engineer to shape reliable, scalable, and well-governed data foundations that support strategic business decisions. In this specialist-level role, you will transform complex business requirements into high-quality data models, trusted metrics, and actionable insights. You will work across data engineering, analytics, and business teams, helping ensure data is accurate, accessible, secure, and cost-efficient. The role combines hands-on technical expertise with end-to-end ownership, from stakeholder discovery and solution design to production delivery. You will also help establish engineering best practices, strengthen data quality, and empower stakeholders through self-service analytics. This is an opportunity to influence data architecture, mentor colleagues, and drive meaningful business outcomes in a collaborative, technology-driven environment.

Accountabilities

• Lead data modeling and transformation: Design, build, and maintain robust data layers in Google BigQuery, translating complex business rules into clean, efficient, scalable, and version-controlled code.

• Conduct exploratory data analysis: Develop ad hoc analyses to investigate business and data-related issues, identify root causes, prevent data-related impacts on Data Science models, and generate actionable insights.

• Ensure data quality and governance: Implement automated data tests, quality monitoring, and technical documentation to maintain the reliability of critical business indicators and support compliance with Brazil's General Data Protection Law (LGPD).

• Optimize performance and costs: Improve query performance and data pipelines, ensuring scalability for large data volumes while managing cloud processing costs effectively.

• Partner with business and product teams: Collaborate with Product Managers and business stakeholders to understand complex challenges, lead end-to-end discovery, and propose proactive architectural solutions, including semantic layers in Looker.

• Promote data-driven decision-making: Support self-service Business Intelligence (BI) by building accessible metrics and analytical layers that enable stakeholders to explore data and make informed decisions.

• Provide technical leadership and mentorship: Serve as a technical reference for the team through code reviews, pair programming, knowledge sharing, and the promotion of engineering best practices.

• Own delivery from discovery to production: Take responsibility for the full development lifecycle, including requirements gathering, critical analysis, solution design, documentation, implementation, validation, and production deployment.

• Challenge assumptions and solve root causes: Go beyond initial requests to identify underlying business problems, question assumptions, and deliver sustainable solutions rather than short-term fixes.

Requirements:

• End-to-end ownership and analytical thinking: Demonstrated ability to work autonomously and consultatively, leading initiatives from stakeholder discovery and technical refinement through documentation, development, validation, and production delivery.

• Advanced SQL and Google BigQuery: Strong practical experience transforming and querying data in BigQuery, with a solid understanding of query optimization, processing efficiency, cost management, and scalable data solutions.

• Python for data engineering: Proficiency in Python, particularly for developing and maintaining stored procedures (PROCs), alongside its application in exploratory data analysis and data problem-solving.

• Data modeling and semantic layers: Extensive experience refining source data, designing reliable data models, and building semantic layers that support business analysis, competitive insights, and the evaluation of analytical models.

• Looker and business intelligence: Strong hands-on experience with Looker, including the development of semantic and metrics layers, interactive dashboards, and reliable reporting solutions.

• Data quality, governance, and LGPD compliance: A rigorous approach to automated testing, data validation, documentation, governance, and the classification and protection of confidential and sensitive information. Experience reducing recurring data incidents is highly valuable.

• Workflow orchestration: Practical experience using Apache Airflow to orchestrate and manage data pipelines and workflows.

• Software engineering practices: Familiarity with Git-based version control, code reviews, collaborative development, and continuous integration and continuous delivery (CI/CD) pipelines.

• Communication and collaboration: Strong communication skills and the ability to work effectively with technical teams, Product Managers, and business stakeholders, translating complex needs into practical data solutions.

• Autonomy and critical thinking: A proactive, detail-oriented mindset, sound technical judgment, and the ability to challenge assumptions, investigate root causes, and manage priorities independently.

Benefits:

* Flexible medical and dental insurance plans.

* Medication assistance and health benefits for family members.

* Free psychotherapy sessions and 24-hour telemedicine access.

* Ongoing preventive healthcare, mental well-being, and vaccination programs.

* Meal vouchers or access to a local restaurant, plus food vouchers and an additional Christmas food allowance.

* Discounts of up to 40% across the partner company's brand ecosystem.

* Gympass/TotalPass access to gyms, fitness studios, and sports activities.

* Home office allowance for eligible hybrid and remote work arrangements.

* Birthday day off.

* Pet health insurance, partner discounts, and travel and accommodation programs.

* Extended parental leave, including up to 180 days for mothers and 120 days for fathers.

* Support for parents of children with additional needs, childcare assistance, and early childhood education support.

* School supply assistance and child nutrition credits.

* Dedicated legal, psychological, and social guidance.

* Private pension plan and life insurance.

* Bereavement support for the loss of parents and payroll-deductible loan options.

* Public transportation allowance and parking, depending on the work arrangement.