Data Analyst - Johannesburg, Gauteng at L'Oréal

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