Job: Data Analyst (O+O and business Data)
Reports to: CDMO
KEY JOB ACCOUNTABILITIES:
Ownership of O+O and Business data process, ensuring robust data architecture, storage allowing for visualisation, dashboard and beauty tech application.
Work with internal, Digital, Commercial and External data and Advertising vendors to gather, structure, automate, store, administer and transform data on a daily basis.
Access and enhance O+O data integration to implement global Digital, Media and Marketing ROI tools
Work on reporting and systems projects, improving data accessibility in different business areas.
Work with business teams to understand reporting requirements and develop solutions in Power BI sourced from data stored in Google Cloud Platform
Conduct BI training courses to upskill new members of the Commercial and Marketing teams
Be first point of contact for business system issues, working with IT to resolve
Work closely with the global data and Product Owner teams
Be responsible for administering system access rights and delegations for core business systems
Take the initiative to suggest process improvements to established ways of working in order to gain further efficiencies and share best practice
TECHNICAL, PROFESSIONAL COMPETENCIES REQUIRED:
Experience preferably within a consumer driven and fast past sales environment
Educated degree level
Power BI and Excel (MUST HAVE)
DAX (intermediate) & VBA (essential)
GCP (Must have), SQL, Python (Nice to have)
Experience of generating reports from Business Intelligence applications (essential), preferably from GCP
Experience of creating reports & visualisations using Power BI
Highly numerate, analytically strong and a great eye for detail
Experience of analyzing large data sets
Financial reporting knowledge (preferable, not essential)
Strong organisational skills
Ability to work in an ever changing & demanding environment
Analytical skills
Demonstrates entrepreneurship
Manages Complexity
Achieves results with integrity
Acts/Leads with human sensitivity
Interacts effectively
L'ORÉAL COMPETENCIES
Innovator
Strategist
People Developer
Integrator
Entrepreneur