Description
One of the largest beauty groups in the world, 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 with licensed products such as Australian Gold, Bio Oil, Nuxe, and Pampers, and its division for the B2B market. This interaction between different brands, assets, platforms, franchise network, representatives, distributors, retailers, sellers, and suppliers forms the beauty ecosystem of Grupo Boticário, which also offers digital business management solutions for the Brazilian retail sector through its brands Mooz and GAVB. There are more than 19,000 direct employees, with more than 4,000 stores in 1\.780 Brazilian cities.
Come make beauty with us!
**Responsibilities and attributes** **As an Analytics Engineer Specialist I in the Consumer Directorate (Pricing and Campaigns) of Grupo Boticário**, you will be the technical link between the data platform and the business area. Your mission will be to ensure that raw data is transformed into strategic assets for pricing (B2B and B2C) and campaign decisions, directly impacting our margin and competitiveness in the market.
**In your day-to-day, you will:**
* **Lead data modeling:** Design and maintain robust data layers in GCP (BigQuery), ensuring that complex business rules for Pricing and Campaigns are translated into clean, efficient, and versioned code.
* **Ensure reliability and governance:** Implement automated data tests, quality monitoring, and technical documentation. You will ensure that critical indicators — which guide millions in price pass-through and margin decisions — are 100% reliable and compliant with LGPD.
* **Optimize performance and costs:** Work on improving the performance of *queries* and pipelines, ensuring scalability for the large volume of data from Grupo Boticário and efficiency in the cloud processing budget.
* **Act as a strategic business partner:** Actively collaborate with Product Managers and business areas (RGM, Consumer) to understand complex pain points. Conduct end-to-end *discovery* and propose proactive solutions in the architecture, including the construction of semantic layers (Looker).
* **Disseminate the data culture:** Act as a technical reference, mentoring team members (code reviews, pairings, best practices) and promoting the *Self\-Service BI* culture for *stakeholders*.
* **Have critical thinking and autonomy in problem-solving:** Go beyond the initial request, investigating the root cause of business pain points to propose architectures that solve the real problem. Actively participate in discussions, questioning premises and handling demands end-to-end (from requirement to production homologation).
**Requirements and qualifications**
For this **Analytics Engineer Specialist I** position, we are looking for someone who is a true technical reference for a highly senior team, taking the strategic lead on Pricing and Campaigns (GCAN) data.
**What is indispensable:**
* **Critical, Analytical Vision and End-to-End Action:** We are looking for a consultative profile, not just an executor. You must have full autonomy to lead the end-to-end process: *discovery* with business and technology stakeholders, refinement, documentation, development, homologation, and production delivery.
* **Critical-Level Data Quality:** Our data underpins the price pass-through of Grupo Boticário, which means we deal with approximately 2 billion in margin. An error directly impacts revenue and *market share*. It is fundamental to have strong rigor with tests, governance, LGPD compliance (classification of sensitive information), and reduction of recurring incidents.
* **Advanced Mastery of SQL \& BigQuery (Focus on Efficiency):** Proven experience in data transformation and consumption using Google BigQuery. Since our budget for *cloud* processing is very tight, you need to have rigorous governance over the efficiency and costs of your *queries* and processes.
* **Data Modeling and Semantic Layer:** Solid experience in refining data sources and creating semantic layers to support the post\-mathematical model, supporting essential analyses of competition and performance of our Pricing models (B2C and B2B).
* **Official Data Visualization in Looker:** Looker is our official tool. You need to have strong experience in building metric layers and interactive dashboards in this tool (we are in the process of fully deactivating Tableau, so the focus is 100% Looker).
* **Orchestration and Software Engineering:** Practical experience with Airflow to orchestrate our entire structuring data pipeline, in addition to experience with code versioning (Git), *Code Reviews*, and CI/CD pipelines.
**What is a differentiator (You gain many points if you have):**
* **Python applied to Data:** Proficiency in Python not only for exploratory analyses, but mainly for the creation and maintenance of *Stored Procedures* (PROCs), which we use extensively in our architecture on GCP.
* **Artificial Intelligence in Real Projects:** In addition to using GenAI tools in the day-to-day to accelerate development, having experience with AI applied to data will be a huge differentiator. Currently, we are handling two of the main AI projects of the Consumer Directorate: catalog checking and the creation of a segment base via AI.
* **Ingestion via APIs:** Experience in data extraction via third-party APIs (e.g., Google, Meta, Salesforce, etc.), dealing with authentication, pagination, and incremental loads.
**Additional information** **Benefits that care and differentiate:**
At Grupo Boticário, care is our foundation for achieving exponential results. We have a portfolio with more than 20 benefits to take care of your health, well-being, and family. Check below.
**Health:**
* Flexible medical and dental plans
* Medication assistance and health vouchers 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 assistance for hybrid and remote modalities
* Birthday day off to celebrate your way
* Pet health plan, advantages in partnerships, 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 assistance
* School material assistance and infant nutrition credit
* Dedicated legal, psychological, and social guidance
**Security for protection and financial peace of mind**
* Private Pension and Life Insurance
* Support for the death of parents and payroll loan
* Transportation Voucher and Parking (depending on the work model)
*Note: Benefit packages are adapted according to the eligibility of each position and work model.*
From a small compounding pharmacy to the largest cosmetics franchise on the planet.
We are a Group with 15 brands present in more than 40 countries, with more than 4,000 physical stores, leader in beauty e\-commerce in Brazil, and more than 19,000 direct employees. We have our own beauty ecosystem, which goes from industry to point of sale, from logistics to retail, from the laboratory to the heart of consumers and our innovations in the palm of your hand. We believe that the most beautiful future is the one we build together, which is why, by 2030, we have ambitious commitments focused on positive impact in human, environmental, and productive process dimensions.
We won the **"Employer Branding Awards 2025"** ranking from Glassdoor, which elected us the best company to work for in the retail sector in Brazil! Recognition based on voluntary and anonymous evaluations from our employees and former employees about what it is like to work here.
We reinvent beauty through technology, innovation, diversity, and sustainability with: O Boticário, Eudora, Quem Disse, Berenice?, Vult, O.U.i, Dr. JONES, TRUSS, and the marketplace Beleza na Web, in addition to operating with licensed products such as Australian Gold, Bio Oil, and the Pampers care line.
Come make beauty with us!