This role requires a unique set of skills and capabilities, associating strong data modelling and technical skills, with functional finance business knowledge. As Corporate Global Functions (CGF) IT team grows and evolves to partner with and support the Finance of the Future program, we need to ensure we bring & keep this type of talent.
The role is responsible for translating the business requirements for the data design and technical development of the SPOT (Single Point Of Truth) data repository for Total PEP (All International Sectors + Domestic Sectors), partnering with multiple IT delivery teams data engineers to implement, enhance and sustain a portfolio of solutions.
As the senior global finance solutions data analyst, this role will be responsible for key project deliverables, and will become the subject matter expert (SME) to the junior analysts in the team supporting them to complete their own deliverables. As the senior analyst & SME this role will also be responsible for developing the capability of the junior analysts such that they can grow into senior analysts. This role will support the recruitment of new junior analysts into the team when needed.
Work is delivered via agile methodologies (typically using the Scaled Agile ‘SAFe’ framework) and as such the role will be responsible for taking the customers requested features and working with them to define the overall functional and technical user stories each Program Increment (6 to 8 2-week iterations). This role will work with the technical delivery teams to clarify the scope of technical deliverables, and will be responsible for the scope of functional deliverables.
This role is critical for the Digital Planning transformation will work across multiple workstreams such as, but not limited to:
1. Cockpit – Finance Performance Dashboards
2. Predictive Analysis
3. Post-Mosaic SPOT – global financial performance data lake
Scope and accountabilities:
As SPOT expands, the scope of the role includes the functional & data design of following:
1. SPOT 2.0 – integration of Mosaic data beyond Europe (TM1, DAPLR, etc.)
2. SPOT 2.0 – integration of new business sectors into SPOT 2.0 design, including understanding and managing any variances to the existing design, and working to align all sectors to the same standard data model where possible
3. SPOT AI – integration of AI Forecasting into SPOT 1.0/2.0
4. Migration from Teradata to Azure cloud based architecture
On top of that, part of the job is to ensure we:
1. Uplift the capability of the team through mentoring and coaching the junior team members with the objective that they all should be able to grow into this senior role in the future
2. Lift & shift existing designs (i.e. Europe Mosaic SPOT 2.0) to avoid duplication
3. Support design & development of new capabilities from scratch (as and when needed)
4. Influence the design to create a best-in-class end-to-end data lake
SPOT is the backbone behind Cockpit which is a key pillar of the global digital reporting transformation program, the aim of which is to fundamentally evolve our planning and reporting capabilities such that: all BUs are on a single standardized reporting platform, enabling real-time, decision support, creating efficiency by eliminating Excel, PPT and PDF business reviews/reporting and delivering a user-friendly, agile performance management tool.
This role holds full responsibility of the IT functional design and data architecture of the Finance SPOT development. The role will be actively engaged with the Global SPOT Finance (FP&A) team and Global D&A/S&T team to drive significant enhancements in the end to end flow, keeping manager informed, but driving the direction and resolution.
Develop and maintain SPOT solution design & data architecture:
Translate and communicate business requirements across all IT delivery teams and/or partners:
Coach & grow the SPOT IT solution team:
The Global SPOT Snr Finance Solutions Data Analyst requires a unique skill set:
Tech Skills:
Data modelling for analytics solutions
SQL - to analyze data stored in:
Awareness of how Tableau & PowerBI consume data
Non Tech skills:
Managing senior stakeholders
Knowledge of financial reporting
Coaching and growing junior team members
Managing the deliverables across the team
Managing multiple priorities
Delivering through agile project methodologies