People Analytics Analyst II

Description

*One of the world's largest beauty groups, 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,* *Tô.que.tô**, 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 market through its brands Mooz, Casa Magalhães, 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** HR Data Pipeline and Architecture: Develop, maintain, and optimize data pipelines (ETL/ELT) integrating different HR data. Data Modeling: Create and maintain relational and non\-relational data models (Data Warehouse / Data Lake) focused on employee lifecycle metrics (Attraction, Performance, Turnover, Engagement, Compensation). Automation and Quality: Automate data extraction routines and implement validation tests to ensure the integrity, consistency, and reliability of the data (Data Quality and Governance). Compliance and Security: Ensure the application of data privacy regulations (LGPD) in all HR databases and pipelines. Data Support and Availability: Create optimized views and tables for direct consumption by the HR Analytics teams, in addition to developing advanced dashboards when necessary. Documentation: Document data sources, ETL flows, data dictionaries, and business rules of the People area. **Requirements and qualifications** Advanced SQL: Proficiency in complex queries, manipulation, query optimization, and creation of tables/views. Programming Language: Intermediate/advanced experience with Python for routine automation, API consumption, and data processing.. ETL / ELT and Modeling: Practical experience in building data integration flows and multidimensional modeling (Star Schema, Snowflake). Cloud \& Data Warehouse: Practical knowledge in cloud environments (AWS, GCP, or Azure) and Data Warehouse tools (e.g., BigQuery, Snowflake, Redshift). Data Visualization: Knowledge of data viz tools (Power BI, Tableau, Looker) for building models and dashboards. **Additional information** **OUR BENEFITS** We already said that Grupo Boticário is the **best** and **largest** beauty ecosystem, right? And when it comes to Benefits, we care about our people and therefore offer a benefits package**\*** that allows for a more balanced and complete life: * Here, your **Health** is a priority . Medical and dental plan . Medication assistance . Health voucher for family members . Free psychotherapy sessions . Telemedicine and second medical opinion . Free flu vaccine . Health care programs * To take care of your **Nutrition** . Meal voucher or local restaurant (depending on work model) . Food voucher . Christmas food voucher * **Ensuring Well\-Being and Quality of Life in all aspects of life** . Gym and physical activity studio plan . Home office assistance (hybrid and remote work models) . Pet health plan . Birthday day off . Discount of up to 40% on our products . Association for employees (agreements and partnerships, multi-brand store, total pass gyms, courses, and much more!) . Travel and lodging program * For the **Family**, our most precious asset . Early childhood education assistance . Child nutrition credit . Nanny assistance . School supplies assistance . Legal, psychological, and social guidance . Support for atypical parents . Extended parental leave (180 days for mothers and 120 days for fathers) * **Mobility** for your in-person journey . Transportation voucher and Parking (hybrid and in-person models) * **Security** for protection and financial peace of mind . Life Insurance . Support for the death of parents . Private Pension . Payroll loans * *Benefits packages are configured according to eligibility rules.* 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 hearts 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!