Principal Consultant_ Data Modelling

Infosys; Greater London; On-site; GBP 90,000 - 120,000; Full time

Job summary

Infosys in London, UK is seeking a Data Modelling Lead to drive the design and transformation of enterprise data models for scalable analytics and reporting. You will assess existing SQL Server models and guide Snowflake implementations, aligning with business requirements and governance standards.

You will mentor junior modelers, contribute to architecture reviews, and collaborate with Business Analysts to translate complex requirements into efficient data structures that support strategic

Qualifications

• 5+ years of experience in data modelling and database design.
• Strong expertise in SQL Server and Snowflake data modelling.
• 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.

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 and London Market practices.
• Ensure data models align with regulatory guidelines and governance standards.

Skills

Data modelling

SQL

Data governance

Stakeholder management

Analytical thinking

Tools

Snowflake

SQL Server

SSIS

Fivetran

Job description

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.