Back to jobs

Principal Consultant_ Data Modelling_ UK

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Analyse and document the current customer and analytics data model in SQL Server

  • Design new Snowflake data models or modify existing ones

  • Translate business requirements into logical and physical data models

  • Provide impact analysis for model changes and propose efficient solutions

  • Work with data engineering teams to implement the models

From the employer’s posting
Analyse and document the current data model in SQL Server for customer data and analytics.
Design and implement new data models or modify existing ones for Snowflake.
Translate functional requirements into logical and physical data models.
Provide impact analysis for changes to existing models and propose efficient solutions.
Collaborate with data engineering teams to implement models effectively.

What you’ll bring

All qualifications

Core experience

  • 5+ years of experience in data modeling and database design
  • Strong expertise in SQL Server and Snowflake data modeling
  • Proficiency in SQL for data analysis and validation
  • Experience in data architecture principles and data governance
  • Solid understanding of Insurance domain concepts, including London Market
Qualification wording
5+ years of experience in data modeling and database design
Strong expertise in SQL Server and Snowflake data modeling
Proficiency in SQL for data analysis and validation
Experience in data architecture principles and data governance
Solid understanding of Insurance domain concepts (Specialized Insurance, London Market, Regulatory Data)
Apply at 25633:5439

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Oct 26, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 7 and day 52.

From 1,781 similar postings that came down. Coming down is not always a hire.

25633:5439 is hiring

31 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Fivetran
  • PostgreSQL
  • Snowflake
  • SQL Server
  • SSIS
Where the posting names them
Role – Data Modelling Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – London, UK Job Description We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. This individual will work closely with multiple Business Analysts to gather requirements and translate them into optimized data structures, ensuring scalability and compliance with industry standards.
Role – Data Modelling Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – London, UK Job Description We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. This individual will work closely with multiple Business Analysts to gather requirements and translate them into optimized data structures, ensuring scalability and compliance with industry standards. Your role In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. You will analyse existing data models built on SQL Server and guide the development of optimized structures on Snowflake, ensuring alignment with business requirements and enterprise standards. You will collaborate with Business Analysts and cross-functional teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management. As a lead, you will contribute to architecture reviews, mentor junior data modelers, and support data governance initiatives. You will also play a role in documentation, knowledge sharing, and capability building across the data modelling practice. Your work will enable the organization to build a robust foundation for analytics, improve data quality, and support strategic decision-making through well-structured, scalable, and domain-aligned data models.
Job Description We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. This individual will work closely with multiple Business Analysts to gather requirements and translate them into optimized data structures, ensuring scalability and compliance with industry standards. Your role In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. You will analyse existing data models built on SQL Server and guide the development of optimized structures on Snowflake, ensuring alignment with business requirements and enterprise standards. You will collaborate with Business Analysts and cross-functional teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management. As a lead, you will contribute to architecture reviews, mentor junior data modelers, and support data governance initiatives. You will also play a role in documentation, knowledge sharing, and capability building across the data modelling practice. Your work will enable the organization to build a robust foundation for analytics, improve data quality, and support strategic decision-making through well-structured, scalable, and domain-aligned data models. Responsibilities •Analyse and document the current data model in SQL Server for customer data and analytics. •Design and implement new data models or modify existing ones for Snowflake. •Ensure models adhere to best practices for normalization, performance, and scalability. •Collaborate with data engineering teams to implement models effectively. •Work closely with Business Analysts to understand business requirements. •Translate functional requirements into logical and physical data models. •Provide impact analysis for changes to existing models and propose efficient solutions. •Apply knowledge of Insurance domain, including: •Specialized Insurance products. •London Market practices. •Regulatory and compliance data requirements. •Ensure data models align with industry standards and regulatory guidelines.
Your role In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. You will analyse existing data models built on SQL Server and guide the development of optimized structures on Snowflake, ensuring alignment with business requirements and enterprise standards. You will collaborate with Business Analysts and cross-functional teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management. As a lead, you will contribute to architecture reviews, mentor junior data modelers, and support data governance initiatives. You will also play a role in documentation, knowledge sharing, and capability building across the data modelling practice. Your work will enable the organization to build a robust foundation for analytics, improve data quality, and support strategic decision-making through well-structured, scalable, and domain-aligned data models. Responsibilities •Analyse and document the current data model in SQL Server for customer data and analytics. •Design and implement new data models or modify existing ones for Snowflake. •Ensure models adhere to best practices for normalization, performance, and scalability. •Collaborate with data engineering teams to implement models effectively. •Work closely with Business Analysts to understand business requirements. •Translate functional requirements into logical and physical data models. •Provide impact analysis for changes to existing models and propose efficient solutions. •Apply knowledge of Insurance domain, including: •Specialized Insurance products. •London Market practices. •Regulatory and compliance data requirements. •Ensure data models align with industry standards and regulatory guidelines. Required •5+ years of experience in data modeling and database design. •Strong expertise in SQL Server and Snowflake data modeling. •Proficiency in SQL for data analysis and validation. •Experience in data architecture principles and data governance. •Solid understanding of Insurance domain concepts (Specialized Insurance, London Market, Regulatory Data). •Excellent communication and stakeholder management skills. Preferred •Experience with ETL tools and data integration processes. •Familiarity with data warehousing concepts and cloud data platforms. •Exposure to Fivetran, SSIS, or Snowflake advanced features.
Responsibilities •Analyse and document the current data model in SQL Server for customer data and analytics. •Design and implement new data models or modify existing ones for Snowflake. •Ensure models adhere to best practices for normalization, performance, and scalability. •Collaborate with data engineering teams to implement models effectively. •Work closely with Business Analysts to understand business requirements. •Translate functional requirements into logical and physical data models. •Provide impact analysis for changes to existing models and propose efficient solutions. •Apply knowledge of Insurance domain, including: •Specialized Insurance products. •London Market practices. •Regulatory and compliance data requirements. •Ensure data models align with industry standards and regulatory guidelines. Required •5+ years of experience in data modeling and database design. •Strong expertise in SQL Server and Snowflake data modeling. •Proficiency in SQL for data analysis and validation. •Experience in data architecture principles and data governance. •Solid understanding of Insurance domain concepts (Specialized Insurance, London Market, Regulatory Data). •Excellent communication and stakeholder management skills. Preferred •Experience with ETL tools and data integration processes. •Familiarity with data warehousing concepts and cloud data platforms. •Exposure to Fivetran, SSIS, or Snowflake advanced features. Overview *** Infosys is a global leader in next-generation digital services and consulting. We enable clients in 59 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer clients, in 59 countries, as they navigate their digital transformation powered by cloud and AI. We enable them with an AI-first core, empower the business with agile digital at scale and drive continuous improvement with always-on learning through the transfer of digital skills, expertise, and ideas from our innovation ecosystem. We are deeply committed to being a well-governed, environmentally sustainable organization where diverse talent thrives in an inclusive workplace. ***

Your next step

Complete your application on sjobs.brassring.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

Role – Data Modelling Lead
Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling
Location – London, UK



Job Description
We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. This individual will work closely with multiple Business Analysts to gather requirements and translate them into optimized data structures, ensuring scalability and compliance with industry standards.

Your role
In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. You will analyse existing data models built on SQL Server and guide the development of optimized structures on Snowflake, ensuring alignment with business requirements and enterprise standards.
You will collaborate with Business Analysts and cross-functional teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management.
As a lead, you will contribute to architecture reviews, mentor junior data modelers, and support data governance initiatives. You will also play a role in documentation, knowledge sharing, and capability building across the data modelling practice.
Your work will enable the organization to build a robust foundation for analytics, improve data quality, and support strategic decision-making through well-structured, scalable, and domain-aligned data models.


Responsibilities
•Analyse and document the current data model in SQL Server for customer data and analytics.
•Design and implement new data models or modify existing ones for Snowflake.
•Ensure models adhere to best practices for normalization, performance, and scalability.
•Collaborate with data engineering teams to implement models effectively.
•Work closely with Business Analysts to understand business requirements.
•Translate functional requirements into logical and physical data models.
•Provide impact analysis for changes to existing models and propose efficient solutions.
•Apply knowledge of Insurance domain, including:
•Specialized Insurance products.
•London Market practices.
•Regulatory and compliance data requirements.
•Ensure data models align with industry standards and regulatory guidelines.

Required
•5+ years of experience in data modeling and database design.
•Strong expertise in SQL Server and Snowflake data modeling.
•Proficiency in SQL for data analysis and validation.
•Experience in data architecture principles and data governance.
•Solid understanding of Insurance domain concepts (Specialized Insurance, London Market, Regulatory Data).
•Excellent communication and stakeholder management skills.
Preferred
•Experience with ETL tools and data integration processes.
•Familiarity with data warehousing concepts and cloud data platforms.
•Exposure to Fivetran, SSIS, or Snowflake advanced features.



Overview
***
Infosys is a global leader in next-generation digital services and consulting. We enable clients in 59 countries to navigate their digital transformation.
With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer clients, in 59 countries, as they navigate their digital transformation powered by cloud and AI. We enable them with an AI-first core, empower the business with agile digital at scale and drive continuous improvement with always-on learning through the transfer of digital skills, expertise, and ideas from our innovation ecosystem. We are deeply committed to being a well-governed, environmentally sustainable organization where diverse talent thrives in an inclusive workplace.
***



All aspects of employment at Infosys are based on merit, competence and performance. We are committed to embracing diversity and creating an inclusive environment for all employees. Infosys is proud to be an equal opportunity employer.
 

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 81, the most 168, and the latest week had 91.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Location not supplied.

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.