Specialist Business Intelligence Architect

CRDB Bank is looking for a Specialist Business Intelligence Architect to join the Data Management Office at its Tanzania Head Office in Dar es Salaam, reporting to the Manager, Enterprise Analytics and BI. The role defines and assures a governed, secure and scalable BI architecture for management, regulatory and analytical reporting, covering the BI reference architecture, semantic models, certified dataset standards and design patterns across Power BI, SSAS and the governed warehouse or lakehouse layer.

Responsibilities

• Maintain the enterprise BI architecture roadmap and set standards and best practices for BI solutions.
• Lead the design, implementation and upkeep of BI tools and platforms, including semantic layers, data models and reporting frameworks.
• Ensure consistent KPI definitions and metric governance and drive self-service analytics for business users.
• Set and enforce standards for data modelling, DAX, naming, visual design, performance and documentation, and approve new reports and datasets before production.
• Design the BI security model (workspaces, roles, row- and object-level security, sensitivity labels) with Information Security and the Data Protection Officer.
• Manage BI tenant and server configuration, capacity, gateways, licensing usage and audit logs with ICT.
• Manage the dataset and report lifecycle across dev, test and prod, including version control and rationalisation of duplicate reports.
• Monitor and optimise BI infrastructure and report performance and address ETL/ELT and reporting bottlenecks.
• Evaluate BI and analytics tools, including AI-assisted BI, and oversee vendor and project delivery architecture.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Science or a related field.
• Minimum of 3 years of experience in business intelligence, data analytics, data warehousing, reporting or a related data management function.
• Strong BI architecture and data warehousing knowledge: dimensional modelling, star schemas, tabular and composite models, DirectQuery and import modes.
• Advanced Power BI (Service and Report Server) skills including DAX, Power Query, deployment pipelines, gateways, capacity management and administration.
• Experience with SSAS, Tabular Editor, DAX Studio, Oracle, SQL Server and lakehouse query engines, plus PowerShell, Python and REST APIs.
• Knowledge of T24 data structures, banking KPIs, the Personal Data Protection Act 2022, BCBS 239 and ITIL practices.
• DP-600, PL-300, CDMP, DCAM or TOGAF certification is an added advantage.
• BI Architecture
• Power BI
• DAX
• SSAS
• Data Warehousing
• Dimensional Modelling
• SQL
• PowerShell
• Python

Application Instructions

• CRDB Bank does not charge any fees for the application or recruitment process.
• Only shortlisted candidates will be contacted.