Excel Data Transformation Analyst (Pricing)

Chaucer Group; Greater London; Hybrid; GBP 35,000 - 55,000; Full time

Benefits offered by this job

Flexible hybrid work model

Diverse, inclusive culture

Extensive, non-contributory benefits

Job summary

Chaucer Group is seeking a candidate to provide support to the Actuarial pricing team in London. The role focuses on pricing model transformation, requiring strong technical data skills and the ability to collaborate effectively across teams.

The ideal applicant will have strong IT skills, including knowledge of Excel and SQL, and a degree in Maths or Computer Science. Benefits include a flexible hybrid work model and extensive, non-contributory perks.

Qualifications

• Ability to translate business requirements into technical instructions.
• Strong stakeholder and project management skills.
• Attention to detail.

Responsibilities

• Support pricing model transformation from Excel to RuleBook.
• Assist with rule-book development work.
• Build Pricing Insights dashboards in Excel and PowerBI.

Skills

High level IT skills (Excel)

SQL

Python

Dashboarding platforms (PowerBI, Tableau)

Education

2.1 or 1st degree in a Maths or Computer Science related subject

3 or more 'A' levels, including Maths

Job description

Job Summary

To provide support to the Actuarial pricing team, including strategic projects, model and MI/analytics development and other key pricing plan deliveries, Pricing Transformation workstream, testing new pricing models, data development and ongoing support to existing models. The role involves close collaboration with BI developers, pricing software (RuleBook) configurators, underwriting teams across the business, and divisional actuaries.

The successful applicant will have strong technical data development skills and the ability to translate business requirements into developer requests. The role also requires project management and communication skills, providing effective support across multiple workstreams. No prior actuarial experience is required.

The role is located within the Actuarial pricing team in London.

Main duties

Pricing Technology

• Support pricing model transformation from Excel to RuleBook, a cloud‑based pricing platform: oversee developers, clarify model functionality, carry out end‑to‑end user testing, gather feedback from underwriters & pricing actuaries, and embed usage as part of the platform roll‑out.
• Provide underwriters with ad‑hoc technical support for RuleBook, triage issues and allocate them to the correct teams for resolution.
• Assist with rule‑book development work – although RuleBook expertise is not required, the focus is technology agnostic and may expand to other pricing technologies.

Data Pipelines

• Assist with production and testing of relevant pricing data extracts and pipelines.
• Perform data manipulation tasks: generate data dictionaries, produce real‑time data extracts using PowerPivot, and scrape historical data from pricing models for migration into RuleBook and for Insight dashboard exhibits.
• Take ownership of scraping data from historical pricing models, validate the data, prepare for underwriter sign‑off, and transform it into the appropriate structure for ingestion into the relevant databases.

Analytics

• Build Pricing Insights dashboards in Excel and visualisation tools (e.g., PowerBI) to visualise real‑time pricing data.
• Ensure data used for data models & Insight dashboards reconciles with relevant sources for accuracy and reliability, managing others' input and testing.
• Develop and support pricing and data‑management activities, working collaboratively with senior pricing actuaries.

General

• Collaboratively work with underwriters, the pricing team, and underwriting management.
• Assist other pricing team activities as required.

Qualifications

Technical Skills

Essential

• High level IT skills, including knowledge of Excel.
• Demonstrated knowledge of a data processing language such as SQL or Python.

Preferred

• Experience developing and considering database structures, data flows, and use of data; ideally including a London Market pricing setting.
• Experience accessing and reading VBA for Excel.
• Experience with dashboarding platforms such as PowerBI or Tableau.

Education & Experience

Essential

• 2.1 or 1st degree in a Maths or Computer Science related subject (e.g., Physics, Engineering, Statistics) or equivalent demonstrated experience.
• 3 or more 'A' levels, including Maths.

Personal Skills

• Ability to translate business requirements into technical instructions.
• Strong stakeholder and project management skills.
• Ability to plan and organise work to meet targets and deadlines.
• Strong interpersonal, verbal and written skills.
• Intellectually curious and results‑oriented with a strong sense of responsibility.
• Attention to detail.
• Self‑motivated, hard‑working and committed.
• Able to collaborate, work as a team managing downwards and upwards and communicate with staff at all levels.

Benefits

A flexible hybrid work model that supports individual and team needs.

A diverse, inclusive culture that values people for who they are.

Extensive, non‑contributory benefits, including medical, life, and pension cover, flexible holidays, and wellbeing support.