Data Transformation Analyst (Pricing)

To provide support to the Actuarial pricing team, including in respect of strategic projects, model and MI/analytics development and other key pricing plan deliveries, Pricing Transformation workstream, including the testing of new pricing model & data development; and assisting in ongoing support to existing models. This role will involve 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. They will also be able to demonstrate project management and communication skills, providing effective support across multiple workstreams. The role will be located within the Actuarial pricing team in London and work collaboratively with underwriting teams under the guidance of senior pricing actuaries leading on Chaucer’s Pricing Transformation and the Pricing Data and Analytics initiatives. No prior actuarial experience is required.

Responsibilities

• Pricing Technology Support: support pricing model transformation from Excel to RuleBook, 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.
• Data Pipelines: assist with production and testing of relevant pricing data extracts and pipelines, perform data manipulation tasks including generating data dictionaries for pricing models, produce real-time data extracts using PowerPivot, and scrape historical data from pricing models to migrate into RuleBook for renewals and Insight dashboard exhibits. Take ownership of scraping data from historical pricing models, validating this data, preparing for and completing UW sign-off, and transforming it into the appropriate structure to be ingested into the relevant databases.
• Analytics: build Pricing Insights dashboards in Excel and visualisation tools (e.g., PowerBI) that visualise real-time pricing data. Ensure data used for Data Models & Insight dashboards reconciles with relevant sources to ensure accuracy and reliability; manage others' input and testing to provide this assurance. Develop and support pricing and data management activities in collaboration with senior pricing actuaries in the team.
• General: work collaboratively with underwriters, the pricing team and underwriting management; assist other pricing team activities as required.

Requirements

• Strong 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 in a London Market pricing setting.
• Experience accessing and reading VBA for Excel.
• Experience with dashboarding platforms such as PowerBI or Tableau.

Education & Experience

• 2.1 or 1st degree in Maths or Computer Science related subject (including 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.
• Ability to collaborate, work as a team managing downwards and upwards, and communicate with staff at all levels.

Equalities Statement

Chaucer is committed to diversity, actively values difference and respects people regardless of the protected characteristics outlined in the Equality Act 2010.