Role Purpose
To provide meaningful business intelligence, reporting and data-driven insights across the bank’s functions, enabling informed decision-making at operational, management and executive levels.
The BI Analyst will play a key role in improving the quality, consistency, usability and delivery cadence of Power BI reporting. This role requires a hands-on Power BI and data engineering professional with experience leading or contributing to Power BI transformation initiatives, including reporting modernisation, governance, standardisation and continuous improvement.
Key Responsibilities
- Design, develop, enhance and maintain Power BI dashboards, reports and semantic models that provide actionable business insights.
- Translate business requirements into clear reporting solutions, meaningful KPIs, data models and intuitive visualisations.
- Improve the overall look, feel, usability and consistency of Power BI reports in line with reporting and dashboard design standards.
- Drive continuous improvement of the reporting estate by identifying opportunities to improve report performance, data quality, refresh reliability, user adoption and stakeholder experience.
- Lead or contribute to Power BI transformation initiatives, such as report modernisation, migration from legacy BI tools, dashboard rationalisation, standardisation or governance implementation.
- Improve the team’s reporting delivery cadence through reusable datasets, templates, design standards, prioritisation, streamlined development processes and effective stakeholder engagement.
- Develop and optimise data models, DAX measures, Power Query transformations and report refresh processes.
- Work closely with data engineering, technology, analytics and business teams to ensure reliable and trusted data is available for reporting.
- Support data ingestion, transformation, integration and ETL/ELT processes where required.
- Apply data governance, security and access-control principles, including row-level security, workspace management and dataset controls.
- Investigate and resolve reporting, data quality, performance and refresh issues.
- Facilitate discussions with stakeholders to understand reporting needs, gather feedback and drive adoption of improved BI solutions.
- Provide guidance and knowledge sharing to team members on Power BI best practice, dashboard design and data modelling.
Minimum Requirements
- Relevant tertiary qualification in Information Systems, Computer Science, Data Analytics, Data Engineering, Business Intelligence or a related field.
- Certification in Power BI.
- Certification in Data Engineering.
- Proven experience in a BI Analyst, Power BI Developer, Analytics Engineer, Data Analyst or similar role within a complex enterprise environment.
- Demonstrable experience leading or significantly contributing to a Power BI transformation, reporting modernisation or BI improvement initiative.
- Strong experience developing Power BI reports, dashboards, datasets and semantic models.
- Advanced experience with DAX, Power Query and data modelling.
- Strong SQL skills and experience working with relational databases and large data sets.
- Practical data engineering experience, including data transformation, ETL/ELT, pipelines, integration, data quality and refresh orchestration.
- Experience improving reporting delivery processes, standards, governance or team ways of working.
- Experience working with stakeholders across business, data and technology teams.
Technical Skills
- Power BI Desktop and Power BI Service.
- DAX, Power Query and M.
- Data modelling, including star schema and dimensional modelling principles.
- SQL and relational databases.
- ETL/ELT and data transformation processes.
- Data pipelines, refresh scheduling and reporting automation.
- Report performance tuning and optimisation.
- Data quality, reconciliation and validation controls.
- Power BI security, Row-Level Security, workspaces, deployment processes and governance.
- Experience with Azure, Microsoft Fabric, Databricks, Synapse, ADF or comparable modern data platforms would be advantageous.
- Ab Initio exposure would be advantageous but is not essential.
Personal Attributes
- Strong analytical and problem-solving capability.
- Excellent attention to detail and commitment to data accuracy.
- Strong visual design and data storytelling skills.
- Able to communicate complex data concepts clearly to both technical and non-technical stakeholders.
- Proactive, delivery-focused and comfortable working in a fast-paced environment.
- Able to influence stakeholders and drive adoption of improved reporting practices.
- Collaborative team player who works effectively in close partnership with business and technology teams.
Desired Skills:
- Power BI
- Power BI Developer
- BI Analyst