Technology Lead-Snowflake, SQL Server, PostgreSQL, Data Warehousing-UK

Infosys; Greater London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A global technology leader seeks an experienced Data Modeler to analyze customer data and design optimized models in Snowflake. The candidate will work closely with Business Analysts, ensuring compliance with industry standards. Responsibilities include leading data transformation projects, developing efficient data models, and collaborating across teams. The role requires strong expertise in SQL Server and Snowflake, as well as knowledge of Specialized Insurance concepts. This full-time position in the UK offers a competitive compensation package.

Qualifications

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

Responsibilities

• Analyse and document the current data model in SQL Server.
• Design and implement new data models for Snowflake.
• Ensure models adhere to normalization and performance best practices.

Skills

Data modeling

SQL Server

Snowflake

Data governance

Analytical skills

Insurance domain knowledge

Education

5+ years of experience in data modeling

Tools

ETL tools

Fivetran

SSIS

Job description

Role

Technology Lead

Technology

Snowflake SQL Server PostgreSQL Data Warehousing Data Lake Medallion Data Vault Data Fabric Semantic modelling

Location

UK

Business Unit

DNAINS

Compensation

Competitive (including bonus)

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.

A strong understanding of Insurance domain concepts including Specialized Insurance London Market and Regulatory Data is essential for success in this role.

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.

A strong understanding of the Insurance domain including Specialized Insurance London Market operations and Regulatory Data is essential. You will apply this domain expertise to ensure that data models accurately reflect business processes and regulatory obligations.

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.

Qualifications

• 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

Besides the professional qualifications of the candidates we place great importance in addition to various forms personality profile. These include:

• 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 expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills expertise and ideas from our innovation ecosystem.

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.

Key Skills

• Anti Money Laundering
• Consultancy
• Administration Support
• Fire Alarm
• Document Management
• AV

Employment Type

Full Time

Experience

years

Vacancy

1