• 02.2019 – 01.2024

    Senior Analytics & Insights Specialist

    F. Hoffmann-La Roche AG · Basel

    Hide summary

    As Senior Analytics & Insights Specialist I was the point of contact for regional procurement stakeholders and accountable for their data reporting. The focus was on harmonising spend data from different sources and presenting it in Tableau so that decisions could be derived from it.

    View employment reference · PDF, 74 KB
    Hide details

    Duties and responsibilities

    • Responsible for business partnering with specified regional Procurement stakeholders
    • Accountable for timely communication and data reporting to identified stakeholders
    • Design and implement data insights for end users in a visual and compelling way, particularly in tools such as Tableau, showing advanced proficiency
    • Support data transformation and conformation activities as well as standardise data to be used in an integrated enterprise data warehouse

    Projects

    • Supplier Relationship Management dashboard: created the first dedicated SRM spend dashboard, enabling the SRM team to easily identify strategic suppliers across categories and regions
    • Americas dashboard: designed the consolidated dashboard combining spend data, metrics and KPIs from multiple sources into a single platform
    • Global procurement addressable spend report: instrumental at the early stages of its definition, testing, implementation and maintenance, used by procurement professionals across the Roche network
    • Tool evaluation: explored Alteryx, SAP Analytics Cloud and ThoughtSpot, identified opportunities to apply new process flows and shared knowledge and best practices with team members

    Achievements

    • Established the first SRM spend dashboard used across the Roche network
    • Consolidated several Americas data sources into a single platform
    • Continuously shared analytics knowledge and best practices within the team

    Methods and tools

    Tools
    • Tableau
    • Enterprise Data Warehouse
    • Alteryx
    • ThoughtSpot
    • Excel
    Languages and queries
    • SQL
    Platforms
    • SAP Analytics Cloud