SPECIALIST BUSINESS INTELLIGENCE ARCHITECT

Job purpose

The is responsible to define and assure a governed, secure and scalable business intelligence architecture that enables consistent management, regulatory and analytical reporting across the Bank. The role is accountable for the BI reference architecture, semantic architecture, certified dataset standards, BI design patterns and architectural assurance across Power BI, SSAS and the governed warehouse/Lakehouse consumption layer.  The role enables reusable reporting assets, consistent KPI implementation, controlled self-service analytics and improved report performance. It provides architectural direction and design assurance while day-to-day platform infrastructure, identity administration, licensing operations and service support remain with the responsible ICT and platform operations teams.
Principal responsibilities
Develop and maintain the enterprise BI architecture roadmap aligned with business and technology strategies. Define standards, frameworks, and best practices for BI solutions. Design scalable and secure reporting and analytics architectures. Ensure alignment between data architecture, data platforms, AI & analytics platforms, and business objectives.
Lead the design, implementation and maintenance of BI tools and platforms. Establish semantic layers, data models, and reporting frameworks. Ensure consistent KPI definitions and metric governance across the organization. Drive self-service analytics capabilities for business users.
Set and enforce standards for data modelling in BI, DAX, naming, visual design, performance, accessibility and documentation; review and approve new reports and datasets before production.
•

Design the BI security model (workspaces, roles, row- and object-level security, sensitivity labels, service accounts) with Information Security and the DPO, applying least privilege and Personal Data Protection Act 2022 requirements.
•

Own BI tenant/server configuration, capacity, gateways, licensing usage and audit logs with DICT; monitor usage, refresh failures and performance, and drive corrective action.
•

Collaborate with Data Governance teams to ensure trusted and governed data is used in reports and dashboards. Define metadata, lineage, and master data requirements for BI solutions.  Ensure regulatory and compliance reporting requirements are met.
•

Run the dataset and report lifecycle (request, build, certify, promote, retire) through dev/test/prod and version control; lead rationalisation of duplicate, unused and conflicting reports.
•

Engage business leaders to understand reporting, dashboard, and analytics requirements. Translate business needs into technical BI solutions. Advise management on emerging BI technologies and opportunities. Act as a trusted advisor for enterprise reporting and analytics initiatives.
•

Monitor and optimize BI infrastructure and report performance. Identify bottlenecks in ETL/ELT processes and reporting environments. Implement best practices for query optimization and data refresh strategies. Ensure high availability and reliability of BI services.
•

Align KPI and measure definitions with the business glossary and CDEs, publish semantic models and report lineage to the catalogue through the Master Data & Metadata Unit, and surface data quality indicators in reports.
•

Assess BI and analytics tools and features (including AI-assisted BI), contribute to DMP and BI platform decisions and budgets, and provide architectural oversight of vendor and project deliveries.

Qualifications required

•

Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Science or a related field.
•