Power BI Consultant

Description
Role Overview

We are seeking an experienced Power BI Consultant with strong Alteryx expertise to support and enhance the Finance analytics and reporting ecosystem. This role will act as a data and visualisation subject-matter expert, responsible for designing robust financial data models, automating reporting workflows, ensuring data quality, and enabling data-driven decision-making across Finance.

The ideal candidate brings deep hands-on experience in Power BI, SQL, Alteryx, and financial data, with the ability to work closely with Finance, Data, and Technology teams in a consultative capacity.

Key Responsibilities

• Design and develop financial data models that accurately represent business structures, hierarchies, and relationships.
• Ensure data models align with financial reporting, forecasting, and budgeting requirements.
• Collaborate with Data Modelling, Business Analysis, and Technology teams to integrate financial data architecture into existing systems.
• Build and maintain a scalable financial data estate to support future analytics and reporting needs.
• Integrate financial data from multiple sources including ERP systems, EDW, RDS, Datasphere, Redshift, external APIs, and spreadsheets.
• Design and implement data ingestion, extraction, and transformation pipelines, ensuring accuracy, consistency, and auditability.
• Implement data cleansing, validation, and reconciliation routines aligned with financial reporting standards.
• Evaluate and support the implementation of AI-enabled data integration and automation use cases where applicable.
• Define, implement, and monitor data quality standards, validation checks, and feedback mechanisms.
• Ensure ownership of data ingestion processes including QA, scheduling, lineage, veracity, and interoperability.
• Maintain comprehensive documentation of data models, pipelines, and reporting logic for stakeholder clarity and audit readiness.
• Design, deliver, and support a Power BI-based financial reporting and visualisation estate.
• Automate monthly financial exploration and reporting processes with accurate cross-channel distribution.
• Own regular refresh, optimisation, and enhancement of dashboards and reports.
• Develop and maintain DAX measures and calculations to support advanced financial analytics.
• Actively participate in Power BI peer reviews, ensuring reports meet defined gold standards.
• Champion best practices in data visualisation, usability, and performance.
• Leverage Alteryx to automate data preparation, transformation, and reporting workflows.
• Use Power Automate to streamline report delivery, approvals, and operational processes.
• Identify opportunities to improve reporting timeliness, efficiency, and reliability through automation.
• Act as a trusted data and visualisation consultant for Finance stakeholders.
• Support scoping and estimation for data sourcing and reporting initiatives.
• Partner with Finance, Product, and Tech teams to understand financial data lineage and usage.
• Identify and operationalise opportunities for data-driven decision-making across Finance.
• Lead reporting and visualisation workstreams within broader system and transformation projects.
• Manage and update JIRA tickets, ensuring transparency of progress and dependencies.
• Proactively identify opportunities to phase and accelerate delivery of reporting initiatives.
• Conduct post-delivery retrospectives to improve ways of working, documentation, and collaboration.
• Contribute to internal knowledge sharing sessions and SOP documentation.

Experience
Required Skills & Experience :

• 69 years of experience in BI, data analytics, or data visualisation roles.
• Strong experience supporting financial reporting, forecasting, and budgeting use cases.
• Proven experience designing, delivering, and supporting an enterprise Power BI reporting estate.

Technical Skills

• Advanced expertise in Power BI, including:
• DAX
• Data modelling
• Performance optimisation
• Strong hands-on experience with SQL and data querying across relational data sources.
• Solid experience using Alteryx for data preparation, automation, and workflow optimisation.
• Working knowledge of Power Automate for process and reporting automation.
• Understanding of cloud and data platforms such as AWS (basic), Redshift, EDW, Datasphere, RDS.
• Strong understanding of data integration, transformation, and data quality principles.

)