- Own end‑to‑end integration specifications for all global reports
- Define how data flows between systems and into the reporting layer
- Validate and reconcile data across source systems and reporting outputs
- Act as the central point of ownership for reporting logic and assumptions
- Own assumptions, calculations, and logic behind all reported financial metrics
- Ensure reports support finance use cases such as:
- Management reporting
- Actuals vs budget vs forecast
- Project and margin reporting
- Revenue, cost, and profitability analysis
Requirements & Stakeholder Management
- Elicit, document, and manage clear reporting requirements from global and local stakeholders
- Translate business questions into structured data requirements for the Power BI reporting team
- Support requirements definition for individual reports and dashboards
- Challenge local requirements to ensure consistency, scalability, and alignment with global standards
- Partner with Finance leadership, regional finance teams, FP&A, and Controlling to define clear reporting requirements
- Translate finance questions into structured data requirements for the Power BI team
Data Definitions & Governance
- Own data definitions, KPI definitions, field mappings, and calculation logic
- Establish and enforce reporting standards (naming conventions, metrics, dimensions, hierarchies)
- Ensure consistent KPI definitions across countries, regions, and business units
- Prevent conflicting numbers and multiple versions of the truth
Data Modelling & Architecture
- Design and maintain reporting data models (e.g. star schemas, relationships, measures)
- Define grain, dimensions, facts, and aggregation logic
- Partner with Power BI specialists to ensure models support performant and scalable reporting
Data Integration & Quality
- Connect and reconcile data from multiple systems (e.g. ERP, HR, project management tools, finance systems)
- Work with messy, incomplete, and non‑aligned data sources, identifying gaps and inconsistencies
- Validate data quality, completeness, and accuracy before and after go‑live
- Define rules for data transformations and harmonisation
Issue Resolution & Continuous Improvement
- Support investigation and resolution of data and reporting issues post go‑live
- Perform root‑cause analysis of discrepancies and work with system owners to resolve issues
- Identify opportunities to simplify, standardise, and automate reporting data flows
Documentation
- Maintain comprehensive documentation including:
- Data definitions and KPI dictionaries
- Field mappings and transformations
- Report logic and assumptions
- Data lineage and source‑to‑report traceability
Required Experience & Skills
- Significant experience in a Senior Systems Analyst, Integration Analyst, or Reporting Analyst role
- Strong background in enterprise reporting and analytics in a global environment
- Proven experience working with multiple source systems (ERP, HR, project systems, financial systems)
- Strong understanding of data modelling concepts (star schemas, dimensions, facts, measures)
- Hands‑on experience defining data requirements for BI tools (e.g. Power BI, Tableau, similar)
- Excellent ability to work with complex, messy, and inconsistent data
- Strong documentation and stakeholder communication skills
Desirable
- Experience in finance or operational reporting in a multi‑country organisation
- Knowledge of data governance and KPI standardisation frameworks
- Familiarity with Power BI data modelling and DAX concepts (requirements‑level, not development)
- Experience working with global reporting programmes or transformations
Key Competencies
- Highly structured and detail‑oriented
- Strong analytical and problem‑solving skills
- Able to challenge assumptions and drive data clarity
- Comfortable operating as the single point of ownership for definitions and logic
- Able to balance global standards with local reporting needs
