Do you have experience of providing data modelling expertise, including defining data modelling frameworks and embedding modelling processes, on a complex data improvement project within a financial services environment?
This consulting opportunity is to support our client, a leading Wealth and Asset Management organisation, in developing and maintaining scalable data models that support enterprise data platforms, reporting, analytics and data products.
The project needs a consultant who has:
- strong conceptual, logical and physical data modelling expertise
- experience of 3NF and dimensional modelling
- expertise in data warehouse, data mart, master and reference data modelling
- strong SQL, data profiling and business requirements translation skills.
Key services:
The key services that you will be asked to provide are:
- develop and maintain scalable conceptual, logical and physical data models
- design Fact, Dimension and Bridge tables, including conformed dimensions and surrogate keys
- develop data warehouse and data mart models
- develop metadata management structures and data dictionaries
- translate business and technical requirements into structured data models and specifications
- collaborate with multiple squads to embed consistent modelling standards and practices, and this results in well-designed solutions.
Mandatory Requirements:
Successful consultants will be able to demonstrate:
- significant experience delivering data modelling across complex data platforms within financial services environment
- conceptual, logical and physical data modelling experience
- strong knowledge of 3NF and dimensional modelling
- experience of Fact, Dimension and Bridge table design
- experience of conformed dimensions and surrogate key design
- knowledge of data quality and governance principles
- strong SQL and data profiling skills
- experience working with Data Architects, Business Analysts and Data Engineers
- Azure data platform experience
- Databricks experience
- Financial Services Industry expeirence.
Working Pattern: Remote (UK based)
Contract Type: Inside IR35
Start: Nov 2026
Duration: 2 months