Loreal Internships 2022 – Business Analyst

Website L'Oréal

Job Description:

We are looking for a forward-thinking and resilient individual with entrepreneurial spirit to join our emerging Analytics department. This individual would e nsure all BI reports and data sets are populated with correct data, and being leveraged by the organization. Train users on existing self-service BI tools, as well as build out new data sets and data models for cross collaborative teams.

Job Responsibilities:

  • Deliver best-in-class analytical dashboards using Power BI
  • Ownership and mastery of all data sources leveraged by NYX BI team, including shared national/global systems as well as databases created in house
  • Collaborate with other brands and shared services on IT projects relating to BI
  • Timely delivery of all ETL processes that feed downstream reporting
  • Act as the primary point of contact for Sales and Marketing teams in need of analytical assistance, not limited to historical shipments, brick and mortar consumption, online consumption, SKU-level analysis, etc.

Job Requirements:

  • Hands-on experience developing data models and reports in Power BI using Power Query and DAX
  • Hands-on experience working with relational databases/large datasets to derive insights and make recommendations
  • 2 years of experience working in an analytically focused role
  • Advanced Excel knowledge required (pivot tables, formulas, automation)
  • Ability to work cross-functionally, build relationships and excel in team and cross-functional environment
  • Well-developed verbal and written communication and interpersonal skills

Job Details:

Company: L’Oréal

Vacancy Type: Full Time

Job Location: El Segundo, CA, US

Application Deadline: N/A

Apply Here