Data Analyst -P&C Insurance in City of London

We are seeking an experienced Technical Data Analyst to support the Global Specialty Insurance (GSI) Delegated Authority Data Workstream. This role is responsible for driving business engagement, defining landing data requirements, and shaping data standards that enable a unified future operating model for Delegated Authority data intake requirements and workflow across GSI for existing DA partners and devising requirements for new partner onboarding.

Working closely with the Senior Data Architect, the role will facilitate cross-BU collaboration to define Contract, Premium/Risk, and Claims data requirements, establish data quality rules, and support the design of scalable partner onboarding and operating models. This is a cross-functional role operating across four core pillars:

• Data Model Definition
• Data Quality Rules
• Partner Data Engagement
• Operating Model Design

The role is programme-focused and will play a key part in preparing Business Units for future implementation of the GSI Data Intake Target Operating Model.

Key Responsibilities

1. Data Model Requirements & Definition
   • Facilitate business and SME workshops to gather and refine data requirements across Contract, Premium/Risk, and Claims domains.
   • Support the Senior Data Architect by translating business requirements into clear data definitions, field-level specifications, and business context.
   • Perform detailed source-to-target analysis, including transformation logic and data interpretation across MGA, TPA, and internal systems and data governance needs.
   • Develop and maintain business data dictionaries aligned to canonical GSI landing models.
   • Conduct gap analysis between existing BU data structures and GSI standard models.
2. Data Quality Rules & Standards
   • Define business validation rules, data quality standards, and rule hierarchies for GSI Delegated Authority data from MGA / TPAs.
   • Develop validation playbooks to support consistent data intake across Business Units and external partners.
   • Collaborate with SMEs and governance forums to agree critical data controls, mandatory fields, and completeness expectations.
   • Ensure business rules support regulatory, financial, and operational reporting needs.
3. Partner Data Engagement
   • Support discovery and analysis of MGA and TPA data capabilities, formats, and system constraints.
   • Develop and maintain partner system capability matrix.
   • Contribute to the design of partner data onboarding playbooks and interface approaches (real-time API and bordereaux).
   • Participate in external partner discussions to clarify data requirements and integration expectations.
   • Provide analysis support for future partner onboarding execution where required.
4. Operating Model & Governance
   • Support the design and documentation of the GSI Delegated Authority Data Intake Operating Model.
   • Facilitate SME Councils, BU discovery sessions, and Data Governance forums.
   • Drive alignment across Business Units to the GSI landing data standards and intake approach.
   • Document onboarding workflows, roles, and responsibilities across people, process, data, and technology.
   • Produce discovery outputs to support BU implementation planning.
5. Programme Analysis & Deliverables
   • The role will produce key programme artefacts, including:
   • Business data dictionaries
   • Validation rule catalogues
   • Partner capability assessments
   • Onboarding playbooks and process documentation
   • BU discovery and implementation inputs

Key Skills & Experience

• 8–10+ years’ experience as a Senior Data Analyst in data-centric or enterprise transformation programmes.
• Strong experience working with complex, high-volume transactional data (policy, premium, exposure, claims, financial movements).
• Proven experience performing detailed data analysis, source-to-target mapping, and business data definition.
• Provides inputs to data and modelling teams, including support for mapping documents and data flow artefacts.
• Acts as a bridge between business and technology teams, with some exposure to data concepts, though deeper technical understanding is developing.
• Experience defining data quality rules, validation frameworks, or data governance standards.
• Experience engaging directly with external partners, vendors, or third-party data providers.
• Strong understanding of delegated authority insurance datasets, bordereaux processes, or equivalent delegated business models (preferred).
• Experience supporting enterprise data model or data standardisation initiatives.
• Excellent stakeholder management skills, with the ability to challenge, shape requirements, and drive agreement across senior stakeholders.
• Ability to translate complex technical and data concepts into clear business language.

Behavioural Competencies

• Influence & Alignment – Drives consensus across multiple Business Units and stakeholders with differing priorities.
• Strategic Thinking – Understands how detailed data requirements support long-term operating model and regulatory objectives.
• Facilitation Leadership – Leads structured workshops and councils to achieve decisions and clarity.
• Problem Solving – Diagnoses data gaps, inconsistencies, and operational constraints to propose practical solutions.
• Ownership & Accountability – Takes responsibility for delivery of high-quality analysis artefacts and programme outcomes.
• Communication – Communicates complex data concepts clearly to both business and technical audiences.

Preferred Knowledge

• Delegated Authority / Bordereaux environments and formats
• MGA / TPA data integration
• Regulatory environments such as Lloyd’s, Solvency II, or equivalent
• Experience working alongside Data Architects, Data Governance, or Data Engineering teams