Data Modeler

Unifeye - The Databricks Experts

Greater London

Hybrid

GBP 80,000 - 110,000

Full time

46 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

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 a delivery led, Databricks first consultancy helping organisations unlock the full value of their data and AI.

We're a lean, high growth team based in London, working at the intersection of data, technology and business strategy. We partner with enterprise organisations across industries to solve complex data challenges through modern Lakehouse architectures on Databricks.

Joining Unifeye means more than delivering projects. From day one, you'll be trusted to take ownership, challenge conventional thinking and make a genuine impact. With a high degree of autonomy, you'll help shape client outcomes, influence our technical direction and play a key role in the growth of the business.

The Role

We're looking for an experienced Data Modeller with strong business analysis skills to design the data models that sit at the heart of our clients' enterprise data architectures.

Our clients are increasingly building multiple data products, each serving different business needs and each needing its own schema, but all sharing common business entities, definitions and datasets. You'll design the models for individual products while making sure they stay consistent, interoperable and reusable across the wider enterprise. The aim is to avoid unnecessary duplication, establish common data structures and let each product run independently on shared, consistent definitions.

This is a role for someone who looks beyond a single data product. You'll understand how products fit together across the enterprise data landscape, so that common data is modelled once and consistently rather than rebuilt for every product. You'll work closely with business stakeholders, data architects and data engineers, combining the technical depth of a data modeller with the requirements gathering skills of a business analyst.

What You'll Do
  • 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.
What We're Looking For
  • 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.

Please note: this is not a traditional Data Analyst role. Applicants from a data analyst background will only be considered if they have substantial hands on experience in dimensional modelling, star schema design and ownership of data model design.

Why Join Unifeye?

We're building a consultancy where talented people can do their best work.

At Unifeye, you'll solve meaningful problems, work with leading enterprise organisations and collaborate with some of the UK's most experienced Databricks specialists. As a high growth business, we'll give you the autonomy to make decisions and influence how we work, and you'll see the direct impact of your contributions.

We offer:

  • The opportunity to work exclusively with Databricks technologies.
  • High levels of ownership and autonomy from day one.
  • The chance to make a real impact on clients and the growth of the business.
  • Close collaboration with Databricks teams.
  • Continuous learning, certification and career development.
  • Competitive salary, bonus, generous benefits and flexible hybrid working.

If you love turning complex business problems into clean, reusable data models and want to help shape a fast growing consultancy, we'd love to hear from you.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Modeler
Data Modeler

Unifeye Ltd. • City Of London

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

Unifeye • Greater London

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

Unifeye Ltd. • City Of London

Hybrid
GBP 80,000 - 110,000
Databricks-focused role
Autonomy from day one
Career development
+2
Data Engineer
Data Engineer

Unifeye • Greater London

Hybrid
GBP 70,000 - 100,000
Databricks focus
Hybrid working
Competitive salary
+2
Data Architect
Data Architect

Unifeye - The Databricks Experts • City Of London

Hybrid
GBP 90,000 - 130,000
Competitive salary
Bonus
Generous benefits
+1
Principal Engineer
Principal Engineer

Unifeye Ltd. • Greater London

Hybrid
GBP 110,000 - 165,000
Exclusive Databricks work
Ownership & autonomy
Principal-level career path
+4
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 Modeller: Enterprise Models & Star Schemas
Data Modeller: Enterprise Models & Star Schemas

Unifeye - The Databricks Experts • Greater London

Hybrid
GBP 80,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
Principal Consultant_ Data Modelling
Principal Consultant_ Data Modelling

Infosys Limited • Greater London

On-site
GBP 90,000 - 130,000