CT-4427; Senior Data Modeller

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