Source description
About the role
As a Senior Systems Analyst, Integration Analyst, or Reporting Analyst, your role will involve defining how data flows between systems and into the reporting layer. You will be responsible for validating and reconciling data across source systems and reporting outputs. Additionally, you will own assumptions, calculations, and logic behind all reported financial metrics. Your main focus will be to ensure that reports support finance use cases such as management reporting, project and margin reporting, and revenue, cost, and profitability analysis. Key Responsibilities: - 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 - Challenge local requirements to ensure consistency, scalability, and alignment with global standards - Own data definitions, KPI definitions, field mappings, and calculation logic - Design and maintain reporting data models (e.g. star schemas, relationships, measures) - Connect and reconcile data from multiple systems (e.g. ERP, HR, project management tools, finance systems) - Validate data quality, completeness, and accuracy before and after go-live - Define rules for data transformations and harmonization - Support investigation and resolution of data and reporting issues post go-live - Identify opportunities to simplify, standardize, and automate reporting data flows Qualifications Required: - Significant experience in a Senior Systems Analyst, Integration Analyst, or Reporting Analyst role - Proven experience working with multiple source systems (ERP, HR, project systems, financial systems) - Strong understanding of data modeling 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 - Experience in finance or operational reporting in a multi-country organization - Knowledge of data governance and KPI standardization frameworks - Familiarity with Power BI data modeling and DAX concepts (requirements-level, not development) - Experience working with global reporting programs or transformations - Able to challenge assumptions and drive data clarity - Able to balance global standards with local reporting needs As a Senior Systems Analyst, Integration Analyst, or Reporting Analyst, your role will involve defining how data flows between systems and into the reporting layer. You will be responsible for validating and reconciling data across source systems and reporting outputs. Additionally, you will own assumptions, calculations, and logic behind all reported financial metrics. Your main focus will be to ensure that reports support finance use cases such as management reporting, project and margin reporting, and revenue, cost, and profitability analysis. Key Responsibilities: - 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 - Challenge local requirements to ensure consistency, scalability, and alignment with global standards - Own data definitions, KPI definitions, field mappings, and calculation logic - Design and maintain reporting data models (e.g. star schemas, relationships, measures) - Connect and reconcile data from multiple systems (e.g. ERP, HR, project management tools, finance systems) - Validate data quality, completeness, and accuracy before and after go-live - Define rules for data transformations and harmonization - Support investigation and resolution of data and reporting issues post go-live - Identify opportunities to simplify, standardize, and automate reporting data flows Qualifications Required: - Significant experience in a Senior Systems Analyst, Integration Analyst, or Reporting Analyst role - Proven experience working with multiple source systems (ERP, HR, project systems, financial systems) - Strong understanding of data modeling 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 - Experience in finance or operational reporting in a multi-country organization - Knowledge of data governance and KPI standardization frameworks - Familiarity with Power BI data modeling and DAX concepts (requirements-level, not development) - Experience working with global reporting programs or transformations - Able to challenge assumptions and drive data clarity - Able to balance global standards with local reporting needs
More at Prose on Pixels