Project Manager – Data Migration & Business Change (Underwriting/Pricing)

About the Role

This is a hybrid role sitting within the Underwriting function in the Technical Transformation team, combining data engineering expertise with business change management capability. The successful candidate will play a critical role in a wider application transformation programme, ensuring the Underwriting/Pricing data mart requirements are clearly defined and that data continues to flow successfully into the data marts throughout and after the transition. In addition, they will support the UW function’s longer-term migration to a new target data platform.

The application transformation programme is already up and running for several months, with a recent scope change regarding chain of implementation/execution roll-out.

Key Responsibilities

• Define and document the 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 the migration.

• Ingest data files into the Pricing Datamart, covering claims data, policy and product data, third-party administrator data, and ad-hoc file uploads.

• Validate incoming data upon delivery, checking for completeness, accuracy, and conformance to expected formats before loading into the Datamart.

• Identify, investigate, and resolve data quality issues, escalating 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 to support ingestion, transformation, and validation workflows.

• Support the existing pricing team by ensuring timely, accurate, and reliable data availability within 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 UW function to a new target data platform.

Key Requirements

• Proven experience in business transformation or change management within a data-driven environment.

• Strong understanding of data engineering concepts including data pipelines, data marts, ETL/ELT processes, and data warehousing.

• Experience working with SQL and Python for data ingestion, transformation, and validation.

• Demonstrated ability to manage and deliver complex change programmes with multiple stakeholders.

• Excellent communication skills with the ability to translate between technical and business audiences.

• Strong analytical and problem-solving skills.

• Experience in 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 (e.g., Databricks, Snowflake, AWS, Azure or similar).

• Project Management or Change management qualification (e.g., Prosci, APMG Change Management).

• Experience with programme/project management methodologies (Agile, Waterfall or hybrid).

• 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.