Remote Data Modeller – 3NF & Dimensional Expert

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

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