Senior Consultant - Data Modelling - London, UK

Technology Lead – Data Modeler – London, UK

Location: London, UK

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 role involves working closely with Business Analysts to gather requirements and translate them into optimized data structures, ensuring scalability and compliance with industry standards. A strong understanding of Insurance domain concepts—including Specialized Insurance, London Market, and Regulatory Data—is essential.

Your role

As a Data Modelling Lead, you will:

• Lead the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions.
• 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.
• Collaborate with Business Analysts and cross-functional teams to translate complex reporting and analytics needs into efficient, well-governed data models.
• Identify gaps, drive improvements, and implement best practices in dimensional modelling, normalization, and metadata management.
• Apply Insurance domain expertise to ensure data models reflect business processes and regulatory obligations.
• Contribute to architecture reviews, mentor junior data modelers, and support data governance initiatives.
• Participate in documentation, knowledge sharing, and capability building across the data modelling practice.
• 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.
• Ensure data models align with industry standards and regulatory guidelines.
• Apply knowledge of Insurance domain, including Specialized Insurance products and London Market practices.
• Ensure regulatory and compliance data requirements are incorporated into data models.

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).

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.

Personal

Beyond professional qualifications, we value various personality attributes, including:

• High analytical skills
• High customer orientation
• High quality awareness

Why Infosys

Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation.

With over four decades of experience in managing the systems and workings of global enterprises, we steer clients through their digital journey by enabling an AI-powered core and agile digital at scale. Our learning agenda drives continuous improvement through building and transferring digital skills, expertise, and ideas.

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.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• IT Services and IT Consulting and Software Development

Referrals increase your chances of interviewing at Infosys.