Specialist Data Modeler

CRDB Bank is looking for a Specialist Data Modeler to join the Data Management Office at its Tanzania Head Office in Dar es Salaam, reporting to the Manager, Data Architecture and Integration. The role develops and maintains conceptual, logical and physical data models for the bank's governed data platforms, including the data warehouse, lakehouse, data marts and master data capabilities, and provides modelling expertise and technical review.

Responsibilities

• Build and maintain subject-area models (e.g. Customer, Account, Loan) and physical models across staging, warehouse, mart and lakehouse layers.
• Design reusable dimensional and semantic models for Power BI and SSAS.
• Define and enforce data modelling standards and naming conventions.
• Review and approve model changes before build and assess their downstream impact.
• Design source-to-target mappings and document data lineage.
• Embed data quality controls in models and support regulatory and audit compliance.
• Optimise model performance with DBAs and engineers through partitioning, indexing and aggregation.
• Align models with the business glossary, critical data elements, MDM structures and personal data classification under the Personal Data Protection Act 2022.
• Report on model coverage and standards compliance, and coach delivery teams.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Science or a related field.
• At least 3 years of experience in data modelling, data architecture, data warehousing, data integration or related roles in a complex enterprise environment.
• Knowledge of DAMA-DMBOK2, especially Data Modelling and Data Architecture.
• Advanced SQL and DDL skills on Oracle and SQL Server.
• Experience with modelling tools (e.g. erwin, ER/Studio, PowerDesigner, SqlDBM) and techniques such as 3NF, Kimball dimensional modelling, Data Vault 2.0 and medallion architecture.
• Knowledge of T24 core banking data structures, banking reference models (e.g. BIAN, FIBO) and regulatory reporting.
• Certifications such as CDMP, DCAM, Data Vault 2.0, TOGAF or Oracle/Microsoft/cloud data certifications are an added advantage.
• Data Modelling
• SQL
• Data Warehousing
• Dimensional Modelling
• Data Vault 2.0
• Power BI
• SSAS
• Oracle
• SQL Server

Application Instructions

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