Role Title: Data Architect

Location: London, UK (Hybrid)

Employment Type: Outside IR35 Contract

Role Overview

We are looking for an experienced SQL/PostgreSQL Data Architect with a strong insurance domain background to design, modernise, and govern enterprise data platforms. The candidate must bring hands-on expertise in relational database architecture, data modelling, performance optimisation, data migration, and data governance, with proven experience supporting insurance business functions such as policy administration, claims, underwriting, billing, customer, broker, risk, or reinsurance data.

Must Have

• Strong hands-on experience as a Data Architect, Database Architect, or Senior Data Modeller working on enterprise-scale data platforms.
• Mandatory insurance domain experience, with practical understanding of insurance processes such as policy lifecycle, claims, underwriting, billing, customer/account data, broker/intermediary data, risk, exposure, or reinsurance.
• Advanced SQL expertise, including complex query design, stored procedures, functions, views, indexing, partitioning, transaction handling, and performance tuning.
• Strong PostgreSQL experience, including schema design, database optimisation, security, backup/recovery concepts, replication, and high-availability design considerations.
• Experience designing logical, conceptual, and physical data models for operational and analytical use cases.
• Strong understanding of data warehousing, data marts, ETL/ELT patterns, data integration, and data migration approaches.
• Experience with data quality, data governance, metadata management, lineage, access control, and data security practices.
• Ability to assess existing data landscapes and recommend modernisation, rationalisation, and migration roadmaps.
• Experience working with large, complex, and highly regulated data environments.
• Strong stakeholder management and communication skills, with the ability to explain data architecture decisions to both technical and business audiences.