Insurance Data Architect: SQL & Medallion Design

Primus Connect; Greater London; Hybrid; GBP 111,000 - 129,000; Full time

Job summary

Primus Connect seeks a hands-on Solutions Architect to transform business requirements into production-ready SQL, shaping the silver layer within a medallion architecture. You will translate data into practical target models and hand validated SQL to Data Engineers for implementation.

The role focuses on analysis and design, with strong emphasis on Snowflake, dbt and GitHub, and requires experience across complex legacy source systems in a London-based insurance context.

Qualifications

• Translate requirements into data designs and target models.
• Proven ability to design transformations from raw to conformed data.
• Experience with medallion architecture and data modelling.

Responsibilities

• Analyse source data structure, relationships and business meaning.
• Design transformations into the silver layer with SQL.
• Prototype designs against real data and validate assumptions.
• Collaborate with Data Engineers to productionise SQL workloads.
• Support engineers during implementation and resolve design issues.

Skills

SQL

Medallion Architecture

Data Modelling

Snowflake

dbt

GitHub

Legacy systems

Tools

Snowflake

dbt

GitHub

Job description

Primus Connect seeks a hands-on Solutions Architect to transform business requirements into production-ready SQL, shaping the silver layer within a medallion architecture. You will translate data into practical target models and hand validated SQL to Data Engineers for implementation.

The role focuses on analysis and design, with strong emphasis on Snowflake, dbt and GitHub, and requires experience across complex legacy source systems in a London-based insurance context.