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