Analytics Engineer III (Data Directorate - FP&A)

Boticário Group

United States

Remote

USD 53,000 - 74,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Flexible medical and dental plans
Meal voucher and food benefits
Home office allowance for hybrid/REM
Birthday day off

Job summary

Grupo Boticário is seeking an Analytics Engineer III to be the technical link between the Data Platform and FP&A. You will design data models, ensure reliability with automated tests, and optimize performance for large data volumes while partnering with Product Managers and Analysts.

Ideal candidates have strong experience in modern data architecture, Google Cloud, and data governance, with a focus on scalable, self-service data solutions across the organization.

Qualifications

  • Requirements Analysis and Autonomy: lead requirements gathering and execute end-to-end.
  • Advanced SQL Proficiency: write complex and performant SQL for data transformation (BigQuery).
  • Data Modeling: dimensional modeling and analytical schemas for Data Lakehouse.
  • Cloud GCP: knowledge of Google Cloud Platform services for storage and processing.
  • Pipeline Orchestration: experience with Airflow for dependencies, scheduling, and monitoring.
  • Software Engineering applied to Data: Git, code reviews, PRs and CI/CD pipelines.

Responsibilities

  • Lead data modeling and maintain robust data layers translating business rules into code.
  • Implement automated data tests, quality monitoring and documentation for reliability.
  • Improve query and pipeline performance for large data volumes.
  • Collaborate with Product Managers and Analysts to architect data solutions.
  • Mentor junior team members and promote self-service data culture.
  • Investigate root causes and propose architectures addressing real business pains.

Skills

Advanced SQL Proficiency
Google BigQuery
Data Modeling
Python
APIs ingestion
Airflow
Git
CI/CD
Generative AI
BigQuery

Tools

Google Cloud Platform

Job description

Location: Brazil

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Product Designer III (Ecommerce e Consumer) - Affirmative Vacancy for People with D
Product Designer III (Ecommerce e Consumer) - Affirmative Vacancy for People with D

Boticário Group • United States

Remote
USD 22,000 - 33,000
Flexible health plans
Meal and food vouchers
Home office allowance
+2
Platform Engineer III
Platform Engineer III

Boticário Group • United States

Remote
USD 63,000 - 102,000
Flexible health plans
Meal vouchers
Home office allowance
+3
Product Manager Especialista I- Gestão de Resultados
Product Manager Especialista I- Gestão de Resultados

Boticário Group • United States

Remote
USD 120,000 - 180,000
Plano de saúde
Vale alimentação
Vale refeição
+3
Product Manager - Especialista I (Tech Colaborador)
Product Manager - Especialista I (Tech Colaborador)

Grupo Boticário • United States

Hybrid
USD 140,000 - 210,000
Plano médico
Plano odontológico
Telemedicina 24h
+3
SENIOR DEVELOPER (BACK-END)
SENIOR DEVELOPER (BACK-END)

Quality Digital • United States

Remote
USD 21,000 - 32,000
Learning environment
Performance evaluation/feedbacks
Food and/or meal voucher
+9
Product Manager Especialista II - Rotinas (Backoffice Franqueado)
Product Manager Especialista II - Rotinas (Backoffice Franqueado)

Grupo Boticário • United States

Hybrid
USD 140,000 - 190,000
Plano médico
Plano odontológico
Telemedicina 24h
+5
Product Manager Especialista II - Rotinas (Backoffice Franqueado)
Product Manager Especialista II - Rotinas (Backoffice Franqueado)

Boticário Group • United States

Remote
USD 140,000 - 210,000
Plano de saúde
Auxílio medicamentos
Sessões de psicoterapia
+5
Pessoa Promotora de Merchandising
Pessoa Promotora de Merchandising

confidential • United States

Remote
USD 4,400 - 6,500
Plano médico e odontológico flexíveis
Auxílio medicamentos e vale saúde para
Sessões de psicoterapia gratuitas e 24
Product Designer III (Ecommerce e Consumer) - Vaga Afirmativa para Pessoas com Deficiência (PcD)
Product Designer III (Ecommerce e Consumer) - Vaga Afirmativa para Pessoas com Deficiência (PcD)

Boticário Group • United States

Remote
USD 90,000 - 150,000
Plano médico e odontológico
Vale refeição/restaurante local
Auxílio home office para híbrido/remot
+1
Pessoa Desenvolvedora Flutter III - Demanda, Operação e Finanças
Pessoa Desenvolvedora Flutter III - Demanda, Operação e Finanças

Boticário Group • United States

Remote
USD 120,000 - 180,000
Plano médico
Auxílio medicamentos
Sessões de psicoterapia
+5