Analyste intelligence d'affaires - CPD

Hello, we’re L’Oréal. We're not just building brands, we're shaping how the world experiences beauty (and it takes a lot of cool jobs to do it). Intrigued? Keep reading, this might be the opportunity you've been searching for.A Day in the Life Joining our collaborative One Data Team in Montreal/Toronto, you will bridge raw retail data with strategic business insights to drive L’Oréal Canada's largest division (CPD) forward.Data Modeling & Insights: Design and maintain high-impact Power BI dashboards and advanced Excel models to track commercial performance.ETL Pipelines: Build reliable data flows (Dataflows, Power Query) to consolidate internal and syndicated retail datasets (NielsenIQ, POS).Business Partnership: Translate complex market-share and retail dynamics into actionable commercial insights for marketing and sales stakeholders.We Are Looking For An analytical thinker eager to grow and drive our data-driven decision-making culture. We value potential:BI Stack Mastery: Strong proficiency in Power BI, DAX, Power Query (M Query), and advanced Excel.ETL Integration: Experience with data flows, data modeling, and automated pipelines.Functional Analysis: Ability to translate complex business needs into scalable technical solutions.Process Automation: Familiarity with Power Automate or VBA tools.Languages: Bilingual professional proficiency in English and French, for the interactions with English-speaking clients outside of Quebec.What’s In It For YouA place for you to leave your comfort zone and grow beyond your potential (here, you’ll be encouraged to try new things and take risks!)Real responsibility from day 1, there’s no sitting on the sidelines at L’OréalAn environment where people of every ethnicity, social background, age, religion, gender and sexual orientation as well as people with disabilities are accepted, can speak up, will thrive and are celebrated!A place where you can contribute to something bigger! Many of our brands have societal /environmental causes to make concrete differenceWho We Are L’Oréal is present in 150 markets on five continents. For more than a century, L’Oréal has devoted itself solely to ‘Create beauty that moves the world’; it is now the industry world leader. Today, L’Oréal includes over 9k experts in beauty tech, digital, data and e-comm. The Consumer Products Division is on a mission to democratize beauty at its best, elevating the mass beauty market with premium innovations across brands like L’Oréal Paris, Garnier, and Maybelline New York.We’re committed to guaranteeing inclusive recruitment processes and to advocating for hiring and promoting each candidate in an ethical and equitable way. The Group strictly prohibits discrimination against any applicant for employment because of the individual’s gender identity or expression, sexual orientation, visible and/or invisible disabilities, socio-economic and/or multicultural origins, health conditions, age, religion, or any other characteristics protected by law.