Data Analyst - Johannesburg, South Africa - L'ORÉAL

    L'ORÉAL
    L'ORÉAL Johannesburg, South Africa

    1 week ago

    Default job background
    Description

    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