Specialist Business Intelligence Architect

Reporting Line

MANAGER ENTERPRISE ANALYTICS AND BI

Location

Tanzania Head Office

Department

DATA MANAGEMENT OFFICE

Number of openings

1

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. 

Principle 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. 
• Microsoft Certified: Fabric Analytics Engineer (DP-600) or Power BI Data Analyst (PL-300); Certified Data Management Professional (CDMP); DCAM certification; TOGAF are added advantages.
• Minimum of 3 years of experience in Business Intelligence, Data Analytics, Data Warehousing, Reporting, or a related data management function.
• Sound knowledge of EDM Council DCAM capabilities, particularly Data & Technology Architecture and Analytics Management, with practical understanding of data governance, data quality, and enterprise data management frameworks.

• Strong expertise in Business Intelligence (BI) architecture and data warehousing, including dimensional modelling, semantic/tabular models, star schemas, aggregations, composite models, DirectQuery/import modes, and data warehouse/lakehouse consumption layers.
• Proven knowledge of BI security, governance, and DevOps practices, including Row-Level Security (RLS), Object-Level Security (OLS), sensitivity labeling, workspace and deployment pipelines, version control, release management, and reporting lifecycle governance.
• Good understanding of banking data, regulatory reporting, and compliance frameworks, including T24 data structures, banking KPIs, the Personal Data Protection Act, 2022, BCBS 239 principles, and ITIL best practices.
• Advanced expertise in Power BI (Service and Report Server), including data modelling, DAX, Power Query, deployment pipelines, gateways, capacity management, administration, and performance optimization.

• Strong knowledge of Microsoft BI technologies and data platforms, including SSAS (Tabular and Multidimensional), Tabular Editor, DAX Studio, Oracle, SQL Server, data warehousing, and lakehouse query engines.
• Proficiency in BI automation, monitoring, and DevOps practices using PowerShell, Python, REST APIs, version control, and performance analysis tools.
• Advanced knowledge of Business Intelligence (BI) architecture, governance, and operating models, including target architecture development, roadmap planning, platform design, semantic and consumption layers, self-service BI frameworks, and enterprise reporting standards.
• Strong understanding of BI development standards and performance optimization, including DAX, data modelling, visual design, accessibility, documentation, aggregations, refresh strategies, query optimization, and performance tuning across enterprise BI solutions.

• Experience in BI security, compliance, and lifecycle governance, including workspace management, Row-Level Security (RLS), Object-Level Security (OLS), sensitivity labels, service identities, development-to-production release management, version control, and report certification processes.
• Sound knowledge of BI platform architecture and operational requirements, including capacity planning, availability, recoverability, gateways, monitoring, auditing, and collaboration with platform engineers, database administrators, and ICT operations teams.

CRDB Commitment

CRDB Bank is dedicated to upholding Sustainability and ESG practices and encourage applicants who share this commitment. The Bank also promotes an inclusive workplace, hence applications from women and individual with disabilities are encouraged.

It is important to note that CRDB Bank does not charge any fees for the application or recruitment process, and any requests for payment should be disregarded as they do not represent the bank’s practices.

Only Shortlisted Candidates will be Contacted.

Deadline

2026-11-17

Employment Terms

PERMANENT