CT-4427; Senior Data Modeller

B2e Consulting; United Kingdom; Remote; GBP 111,000 - 166,000; Part time

Job summary

B2e Consulting is seeking a data modelling consultant to define scalable conceptual, logical and physical data models for a complex financial services project. You will design conformed dimensions, surrogate keys, and orchestrate data warehouse and data mart models to support enterprise analytics.

The role requires strong SQL, data profiling and the ability to translate business requirements into precise data specifications, collaborating with Data Architects, BAs and Engineers across multiple

Qualifications

• Significant experience delivering data modelling across complex data platforms within financial services.
• Conceptual, logical and physical data modelling experience.
• Strong knowledge of 3NF and dimensional modelling.
• Experience with Fact, Dimension and Bridge table design.
• Experience with 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 experience.

Responsibilities

• 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.

Skills

Data modelling

3NF modelling

Dimensional modelling

Data warehouse

Data mart

Master data modelling

Reference data modelling

SQL

Data profiling

Business requirements translation

Financial services industry

Tools

Databricks

Azure data platform

Job description

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