You will be responsible for understanding unfamiliar insurance source systems and identifying where the data required by the target model actually sits, how it behaves, and how different entities relate to one another.

Some source systems may contain hundreds or even thousands of tables, with limited documentation and limited retained knowledge within the business.

Your role is to carry out the initial investigation and provide the downstream Data Designers with enough understanding to move into detailed mapping and solution design.

Key Responsibilities

• Investigate unfamiliar insurance source systems and databases.
• Use SQL to interrogate complex and potentially poorly documented data estates.
• Identify where key insurance entities and business concepts are represented within source systems.
• Understand how data entities relate to one another.
• Reduce large numbers of source tables down to the subset relevant to a particular requirement.
• Analyse how data behaves over time, including history, overwrites, effective dates, and record lifecycle.
• Work with business SMEs and system owners to understand the purpose and behaviour of source data.
• Continue investigations independently where documentation or SME knowledge is incomplete.
• Read and interpret target data models.
• Carry out source-to-target analysis.
• Produce SQL queries to support and evidence findings.
• Document assumptions, findings, and source-system behaviour.
• Provide Data Designers with sufficient analysis to begin detailed solution design.
• Work closely with Data Designers and Data Engineers throughout delivery.
• Support multiple delivery squads as the programme continues to scale.

Essential Experience

• Insurance Domain Experience: You should have a strong understanding of insurance data and common insurance concepts. Experience across multiple insurance organisations or source systems would be particularly valuable.
• Strong SQL: You must be comfortable working directly with data using SQL. You should be able to use SQL to profile data, understand table structures, identify relationships, validate assumptions, investigate data behaviour, etc.
• Technical Data Analysis: You should have strong experience analysing complex data environments and working through unfamiliar systems.
• Technical Business Analysis: You should be able to work effectively with business stakeholders and SMEs, understand requirements, and translate those conversations into technical data investigations.
• Data Modelling Awareness: The ideal person is naturally curious, technically capable, and comfortable solving problems where the answer isn't immediately available.

If documentation doesn't provide the answer and the SME doesn't know, you need to be the type of person who gets into the data and works it out.

We're looking for someone who can independently get the team 80–90% of the way towards understanding a source system, rather than someone who waits for every question to be answered before progressing.

If you enjoy getting into complex data, understanding how systems really work, and translating that knowledge into something a delivery team can act on, click apply now.