Analytics Engineer III (Data Directorate - FP&A)

One of the largest beauty groups in the world, the Grupo Boticário is a Brazilian company present in more than 40 countries. It owns the brands O Boticário, Eudora, Quem Disse, Berenice?, Vult, O.U.i, Dr. JONES, TRUSS, and the marketplace Beleza na Web, in addition to operating licensed products such as Australian Gold, Bio Oil, Nuxe, and Pampers and its B2B division. This interaction among different brands, assets, platforms, franchise network, representatives, distributors, retailers, sellers and suppliers forms the beauty ecosystem of the Grupo Boticário which also offers digital business management solutions for Brazilian retail through its brands Mooz and GAVB. It has more than 19 thousand direct employees, with more than 4 thousand stores in 1,780 Brazilian cities.

Come make beauty with us!

As Analytics Engineer III in the Data Directorate of the Grupo Boticário, you will be the technical link between the Data Platform and the FP&A business areas.

On a day-to-day basis, you will:
• Lead data modeling:Design and maintain robust data layers, ensuring that business rules are translated into clean, efficient and versioned code.
• Ensure reliability:Implement automated data tests, quality monitoring and technical documentation, ensuring that critical product safety and efficacy indicators are 100% reliable.
• Otimizar performance:Work on improving query and pipeline performance, ensuring scalability for the Group's large data volume.
• Act as a business partner:Actively collaborate with Product Managers and Functional Analysts to understand complex pain points and propose proactive data architecture solutions.
• Spread a data culture:Mentor more junior team members (code reviews, best practices) and promote a Self-Service culture for business stakeholders.
• Critical Thinking and Problem Solving:Ability to go beyond the initial request, investigating the root cause of business pain points to propose architectures that solve the real problem. Actively take part in discussions, questioning assumptions and suggesting proactive improvements to processes and the team's development pipeline.

For this position of Analytics Engineer III, we are looking for someone with technical knowledge of modern data architecture who acts as a technical reference for the team, ensuring the scalability and governance of QEC data.
What is indispensable (Must-haves):

• Requirements Analysis and Autonomy: Ability to work directly with the functional team to lead requirements gathering, translate business needs into technical scope, and independently drive the execution of demands end to end.
• Advanced SQL Proficiency: Proven experience writing complex and performant queries for data transformation in the Google BigQuery.
• Data Modeling: Solid experience with dimensional modeling, creation of tables optimized for analytical consumption and modern data architectures (Data Lakehouse), translating business rules into efficient technical schemas.
• Cloud GCP: Knowledge of Google Cloud Platform services, especially storage and processing strategies.
• Pipeline Orchestration: Hands-on experience with data flow orchestration tools (Airflow) to manage dependencies, scheduling and failure monitoring.
• Software Engineering applied to Data: Experience with code versioning (Git), Code Reviews, Pull Requests and CI/CD pipelines.

What will make your eyes light up (Differentiators):

• Generative AI and Agents: Practical use of GenAI tools (Gemini, Copilot, Cursor, etc.) to accelerate code development, or experience implementing agentes de IA for task automation, data quality and integration of agents into data pipelines.
• Python: Proficiency in Python for script automation, orchestration or exploratory analysis.
• Ingestion via APIs: Experience extracting data via third-party APIs (e.g., Google, Meta, Salesforce, etc.), handling authentication, pagination and incremental loads.
• FinOps and Optimization: Experience monitoring processing costs and latency, proactively refactoring queries for cloud cost efficiency.
• Advanced data knowledge: Knowledge of data science, statistical models and machine learning is considered a differentiator for the position.

Additional information

Benefits that care and stand out:

No Grupo Boticário, care is our foundation for achieving exponential results. We have a portfolio of more than 20 benefits to take care of your health, well-being and family. Check below.

Saúde:

• Flexible medical and dental plans
• Medication allowance and health voucher for family members
• Free psychotherapy sessions and 24h telemedicine
• Continuous programs for prevention, mental care and vaccination

Food & well-being

• Meal voucher (or local restaurant) and food voucher (with extra voucher at Christmas)
• Discount of up to 40% on brands in our ecosystem
• Gympass/TotalPass for gyms and sports studios
• Home office allowance for hybrid and remote arrangements
• Birthday day off to celebrate your way
• Pet health plan, agreement benefits and travel/lodging programs

For your family

• Extended parental leave (180 days for mothers and 120 days for fathers)
• Support for Atypical Parents and nanny / early childhood education allowance
• School supplies allowance and children's nutrition credit
• Dedicated legal, psychological and social guidance

Insurance for protection and financial peace of mind

• Private pension and life insurance
• Support upon death of parents and payroll-deductible loan
• Transportation voucher and parking (depending on work model)

Note: Benefit packages are adapted according to each position's eligibility and work model.