Data Modeller: Enterprise Models & Star Schemas

Unifeye - The Databricks Experts

Greater London

Hybrid

GBP 80,000 - 110,000

Full time

46 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive salary
Bonus
Generous benefits
Flexible hybrid working

Job summary

Unifeye is seeking an experienced Data Modeller with strong business analysis to design enterprise data models for multiple products within client Lakehouse architectures on Databricks. You will shape data structures, ensure consistency and reusability across the wider enterprise.

Your work will involve collaborating with business stakeholders, data architects and data engineers, translating requirements into well-structured models, and driving governance and modelling standards across client

Qualifications

  • Strong, hands-on experience in dimensional data modelling, including designing star schemas, fact tables and dimensions.
  • Proven experience designing logical and physical data models and owning model design end to end.
  • Experience identifying conformed dimensions and shared entities across multiple domains or data products.
  • Strong business analysis experience, including running requirements sessions and translating business processes into data models.
  • Understanding of enterprise data architecture principles, data integration and governance.
  • Strong SQL skills and a solid grounding in data warehousing principles.
  • Excellent communication and stakeholder management skills, with the confidence to challenge requirements.
  • Consulting or client facing delivery experience.
  • Experience with data product or data mesh approaches.
  • Experience with data modelling tools and documenting business glossaries or data definitions.

Responsibilities

  • Design logical and physical data models for multiple data products, balancing product specific requirements with enterprise wide consistency.
  • Build dimensional models, including star schemas, fact tables and dimensions.
  • Identify shared business entities, common datasets and conformed dimensions that can be reused across data products.
  • Engage directly with business stakeholders to gather requirements, understand business processes and translate them into well structured data models.
  • Challenge requirements, spot overlaps between data products and establish consistent business definitions and relationships.
  • Apply enterprise data architecture principles, including integration, interoperability, governance and reduced duplication.
  • Work with data architects and data engineers to make sure models are implemented correctly.
  • Help shape modelling standards and best practice across client engagements and within Unifeye.

Skills

Dimensional modelling
Star schemas
SQL
Data warehousing
Stakeholder management
Data governance
Data mesh
Consulting

Tools

Modelling tools

Job description

Unifeye is seeking an experienced Data Modeller with strong business analysis to design enterprise data models for multiple products within client Lakehouse architectures on Databricks. You will shape data structures, ensure consistency and reusability across the wider enterprise.

Your work will involve collaborating with business stakeholders, data architects and data engineers, translating requirements into well-structured models, and driving governance and modelling standards across client

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Databricks Data Modeler | Enterprise Dimensional Modeling
Databricks Data Modeler | Enterprise Dimensional Modeling

Unifeye Ltd. • City Of London

Hybrid
GBP 70,000 - 110,000
Competitive salary
Bonus
Generous benefits
+1
Data Modeler
Data Modeler

Unifeye - The Databricks Experts • Greater London

Hybrid
GBP 80,000 - 110,000
Competitive salary
Bonus
Generous benefits
+1
Data Modeler
Data Modeler

Unifeye Ltd. • City Of London

Hybrid
GBP 70,000 - 110,000
Competitive salary
Bonus
Generous benefits
+1
Senior Data Modeller / Architect - Financial Services
Senior Data Modeller / Architect - Financial Services

Data Science Talent • Swindon

On-site
GBP 70,000 - 90,000
Senior Data Modeller: Star/Snowflake Schemas & Governance
Senior Data Modeller: Star/Snowflake Schemas & Governance

eTeam • Greater London

Hybrid
GBP 77,000 - 85,000
Data Modelling Lead: Snowflake & SQL Expert
Data Modelling Lead: Snowflake & SQL Expert

Infosys Limited • Greater London

On-site
GBP 90,000 - 130,000
Data Modeller – Dimensional Modelling / 3NF / ERwin
Data Modeller – Dimensional Modelling / 3NF / ERwin

GIOS Technology • Greater London

Hybrid
GBP 60,000 - 90,000
Remote Data Modeller – 3NF & Dimensional Expert
Remote Data Modeller – 3NF & Dimensional Expert

B2e Consulting • United Kingdom

Remote
GBP 111,000 - 166,000
Data Modelling Lead: Snowflake & SQL – Insurance Focus
Data Modelling Lead: Snowflake & SQL – Insurance Focus

Infosys • Greater London

On-site
GBP 90,000 - 120,000
Databricks Lakehouse Architect — Lead, Deliver, Own Impact
Databricks Lakehouse Architect — Lead, Deliver, Own Impact

Unifeye • Greater London

Hybrid
GBP 90,000 - 140,000
Bonuses
Generous benefits
Flexible hybrid working
+1