Data Modelling Specialist

About this role
Company Profile:

• A professional services firm building its data capability Our client is a legal services firm with a dedicated Data and Analytics function that supports operational and strategic decision-making across the business. The team works to clear architectural principles and governance standards, and is building a data architecture and analytics roadmap that this role will help shape. The firm places strong value on integrity, collaboration, respect, and transformation and diversity.

Summary: Purpose of the role

• The Data Modelling Specialist designs, maintains and optimises the firm's data models so that analytics, reporting and integration are reliable, scalable and fast. Models must follow the firm's architecture, governance standards and business needs.

Main Responsibilities: What you will be responsible for

• Data model design  Design logical and physical models using Kimball star schema and medallion architecture  Build and maintain enterprise canonical models and reusable data artefacts  Optimise models for performance and for use in BI tools such as Power BI  Standards, governance and data quality  Apply naming, metadata, security and governance standards across all models  Keep a central, version-controlled model repository  Work with data quality teams and run impact analysis on model changes Documentation and stakeholders  Maintain data dictionaries, ERDs and metadata  Translate business requirements into models and validate them in workshops  Train legal and business users on how the models work Technical collaboration and improvement  Partner with data engineers on the pipelines that populate the models  Guide analytics developers and report writers on using the models well  Recommend modelling tools, techniques and patterns, and contribute to the analytics roadmap

Qualification & Experience: What you will need 

• 4-year degree (NQF 7) in IT, Computer Science or Engineering  Up to 6 years' experience in data warehousing and data analysis  Strong dimensional modelling (Kimball), star schema and 3NF design  Experience with medallion architecture and warehouse or lakehouse design  ETL and ELT concepts and SQL optimisation Skills that will help  Cloud data platforms such as Snowflake, Azure Synapse, Databricks or BigQuery  Power BI-ready model design  Metadata management, data governance and data quality  GDPR and POPIA awareness  JIRA or similar project tools