R&D Data Analyst

Overview

The R&D Data Analyst's role will be primarily focused on the development of strategic insights and deliver smart analytics in support of R&D priorities. This includes connecting data across multiple data sources through curated metrics and developing insights focused on portfolio analysis and reporting. Critical elements of this role will provide accurate visualization fit-for-purpose to generate the insights. Position will interface with finance team, establish appropriate QC checks to ensure accuracy of the information, review Portfolio reports, generate requirements for new reports, gather insights from reports and socialize within R&D team

Responsibilities

• Execute against team charter (SLA) for Reporting & Analytics

Create / Maintain / Upgrade excel utility tools (templates & model) leveraging VB / macros and complex formulas

Execute portfolio level reporting of R&D spend (people & projects) (utilizing dashboards, templated decks, and reporting tools)

Provide business performance explanations, incorporating considerations beyond data into the reporting

Explain business performance, drivers, and optimization opportunities

Provide responses to ad-hoc follow-ups when double-click (additional questions) required with tables / charts / stories using relevant data

Deliver against needs of stakeholders, requestors and end service users

Responsible for managing multiple priorities; being able to manage deadlines and deliverables

Monitor and act upon regular feedback inputs from end-users and Business Partners for deliverables

Maintaining Data integrity across multiple platforms, like Excel (AOP Data Collection), Clarity (Portfolio Management) & Anaplan (Finance system)

Support the preparation of data loads on period basis

Ensure data accuracy after period data loads by Finance

Coordinate with Power BI reporting team on latest data for reports / dashboards

Solicit new reporting / dashboarding requirements with R&D team

Generate insights and socialize with R&D team

Support efforts to establish Insights sub-team within service center as a delivery point of contact for all regular insights needs for Business Partners

Support simplification, standardization and digitalization efforts (in coordination with global R&D stakeholders)

Qualifications

Skills Required

Vb Macros, Power Bi, Excel