Senior Data Analyst - Data Migration & Business Change

About the Role

This is a hybrid role within the Underwriting function's Technical Transformation team, combining data engineering expertise with business change management capability. The successful candidate will support a wider application transformation programme by defining Underwriting/Pricing data mart requirements and ensuring data continues to flow successfully into the data marts throughout and after the transition. The role will also support the Underwriting function's longer-term migration to a new target data platform.

The application transformation programme has been running for several months and has recently had a scope change regarding chain of implementation/execution roll-out.

Key Responsibilities

• Define and document requirements for the current pricing data mart as part of the application transformation.
• Ensure data is successfully fed back into the pricing data marts during and after migration.
• Ingest data files into the Pricing Datamart, including claims, policy and product, third-party administrator, and ad-hoc upload data.
• Validate incoming data for completeness, accuracy and conformance to expected formats before loading into the Datamart.
• Identify, investigate and resolve data quality issues; escalate delivery problems where necessary.
• Clean and transform raw source data to meet Pricing Datamart standards and ensure consistency across data sets.
• Write, maintain and optimise SQL and Python scripts for ingestion, transformation and validation workflows.
• Support the pricing team by ensuring timely, accurate and reliable data availability in the Datamart.
• Support the design and implementation of data pipelines and integrations between the new platform and existing data infrastructure.
• Contribute to the longer-term strategy for migrating the Underwriting function to a new target data platform.

Key Requirements

• Proven business transformation or change management experience in a data-driven environment.
• Strong understanding of data engineering concepts, including data pipelines, data marts, ETL/ELT processes and data warehousing.
• Experience using SQL and Python for data ingestion, transformation and validation.
• Ability to manage and deliver complex change programmes involving multiple stakeholders.
• Excellent communication skills, including translating between technical and business audiences.
• Strong analytical and problem-solving skills.
• Experience with requirements gathering, documentation and UAT coordination.
• Ability to manage competing priorities and work effectively under pressure.
• Experience with cloud-based data services and platforms.

Nice to Have

• Experience in the insurance or health insurance sector.
• Experience in Pricing and Underwriting departments.
• Familiarity with modern data platforms such as Databricks, Snowflake, AWS, Azure or similar.
• Project management or change management qualification, such as Prosci or APMG Change Management.
• Experience with programme/project management methodologies, including Agile, Waterfall or hybrid approaches.
• Knowledge of data governance frameworks and data quality management.
• Experience with application migration or platform consolidation programmes.

Key Competencies

• Strategic Thinking: Ability to see the bigger picture and align tactical delivery with long-term transformation goals.
• Stakeholder Influence: Skilled at building relationships and driving consensus across diverse teams.
• Delivery Focus: Track record of driving plans to completion and holding teams accountable.
• Technical Acumen: Comfortable operating in technical environments and engaging with data engineering teams.
• Adaptability: Thrives in ambiguous, fast-moving transformation environments.