Key skills
Power BILookerTableauGoogle Cloud PlatformSQLPythonRRegressionTime Series AnalysisStakeholder ManagementProject ManagementMachine LearningETLAnalyticsBIBusiness IntelligenceDatabricksGCPSalesforceLeadershipCommunicationCollaborationSales
About this role
L'Oréal is a global leader in beauty, dedicated to innovation and scientific excellence. The Assistant Manager of Business Analytics will partner with the LDB Aesthetics business to build business intelligence products and conduct analyses that empower decision-making within leadership and sales operations.
Responsibilities:
- Design, develop, and maintain interactive Power BI dashboards to monitor key financial metrics, trends, and performance indicators (in some cases, act as Analytics Product Owner – APO)
- Collaborate with functional stakeholders (global and local) and business stakeholders to gather and document requirements, define KPIs, and ensure dashboards meet analytical needs
- Extract, transform, and load (ETL) data from various source systems and databases into Power BI
- Implement data quality checks and validation procedures to ensure accuracy and reliability of reported data
- Proactively identify areas for improvement and enhancements to existing dashboards and reporting processes
- Leverage knowledge of analytics trends, best-in-class BI visualizations, technology developments, and best practices to enhance the value of tools and services
- Conduct in-depth data analysis using statistical methods and tools to identify patterns
- Assist with ad-hoc analysis and reporting, as needed
- Support the generation of insights from data
- Translate complex data findings into clear and concise summaries, presentations, and reports for both technical and non-technical stakeholders
- Develop and maintain documentation for all developed dashboards, including data sources, calculations, and business logic
- Provide training and support to end-users on how to effectively utilize and interpret the dashboards
- Develop and maintain a strong working collaboration with BI Community teams and IT partners within the division and across L'Oréal USA
- Be a strong contributor to the relevant analytics communities
Requirements:
- 2–4 years of experience in Data & Analytics
- Proficient in data visualization and reporting tools (Power BI/Looker, Tableau)
- Experience with GCP a must
- Strong SQL (Python/R preferred) skills for data extraction and manipulation
- Experience with data analysis techniques (e.g., regression, time series analysis)
- Good communication and stakeholder management skills
- Developing project management skills
- Experience with GA4, Databricks, Salesforce, Machine Learning / Advanced Statistics