Discover your dream Career
For Recruiters
Chaucer Group

Data Transformation Analyst (Pricing)

Chaucer Group London, United Kingdom
Posted 1 month ago Permanent Competitive

Data Transformation Analyst (Pricing)

Chaucer Group London, United Kingdom
N
Posted by
Nick Marginson
Internal Talent Partner

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.

Main duties

Pricing Technology

  1. Support pricing model transformation from Excel to RuleBook, a cloud-based pricing platform: overseeing developers and clarifying model functionality, carrying out end-to-end user testing, gathering feedback from underwriters & pricing actuaries and embedding usage as part of the platform roll-out.
  2. This role does not require RuleBook expertise, as key RuleBook development is done by a third party vendor. Expertise is aimed to be technology-agnostic; we are aiming to develop in other pricing technology in future as well
  3. Provide underwriters with ad-hoc technical support for Rulebook, triaging issues and allocating them to the correct teams for resolution.

Data Pipelines

  1. Assist with production and testing of relevant pricing data extracts and pipelines
  2. Perform data manipulation tasks including generating data dictionaries for pricing models, producing real time data extracts using PowerPivot and scraping historical data from pricing models to migrate into Rulebook for renewals and Insight dashboard exhibits
  3. Take ownership for scraping data from historical pricing models, validation of this data, preparation for and completion of UW sign off, and its transformation into the appropriate structure to be ingested into the relevant databases.

Analytics

  1. Build Pricing Insights dashboards in Excel and visualisation tools (eg PowerBI) as appropriate that visualise real time pricing data
  2. Take ownership of ensuring data used for Data Models & Insight dashboards reconciles with relevant sources to ensure its accuracy and reliability; including managing others' input and testing to provide this assurance
  3. Develop and support on pricing and data management activities, working collaboratively with senior pricing actuaries in the team

General

  1. Work collaboratively with underwriters, the pricing team and underwriting management
  2. Assistance for other pricing team activities as required

Our requirements

Relevant experience

Technical skills

Essential
  1. Strong IT skills, including knowledge of Excel
  2. Demonstrated knowledge of a data processing language such as SQL or Python

Preferred
  1. Experience of developing and considering database structures, data flows and use of data; ideally including in a London Market pricing setting
  2. Experience in accessing and reading VBA for Excel
  3. Experience with dashboarding platforms e.g. PowerBI/Tableau

Education & Experience

Essential

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

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

ABOUT US

Chaucer is a leading insurance group at Lloyd’s, the world’s specialist insurance market. We help protect industries around the world from the risks they face. Our customers include major airlines, energy companies, shipping groups, global manufacturers and property groups.

Our headquarters are in London, and we have international offices in Bermuda, Copenhagen, Dubai and Singapore to be closer to our clients across the world. To learn more about us please visit our website.

Job ID  JR101326
ABOUT COMPANY
London, United Kingdom
Insurance
Chaucer are a leading specialty (re)insurance group working with brokers, coverholders and clients to protect and support business activities around t...
More Jobs From Chaucer Group
Chaucer Group
Senior Pricing Analyst - Reinsurance
Chaucer Group
London, United Kingdom
1 day ago Full time Competitive
Chaucer Group
Pricing Actuary - Portfolio Solutions
Chaucer Group
London, United Kingdom
1 day ago Full time Competitive
Chaucer Group
Pricing Actuary
Chaucer Group
London, United Kingdom
1 month ago Full time Competitive
Chaucer Group
Data Architect
Chaucer Group
London, United Kingdom
19 days ago Full time Competitive
Chaucer Group
Senior Specialty Analyst - Exposure Management (Energy and Marine)
Chaucer Group
London, United Kingdom
1 month ago Full time Competitive
Chaucer Group
Capital Modelling Actuary
Chaucer Group
London, United Kingdom
1 month ago Full time Competitive
Chaucer Group
Senior Specialty Analyst - Exposure Management (Energy and Marine)
Chaucer Group
London, United Kingdom
2 months ago Full time Negotiable
Chaucer Group
Senior Quantitative Risk Actuary
Chaucer Group
London, United Kingdom
3 months ago Full time Competitive
Chaucer Group
Class Underwriter - Marine PI
Chaucer Group
London, United Kingdom
1 day ago Full time Competitive
Chaucer Group
Underwriting Assistant - Cyber
Chaucer Group
London, United Kingdom
1 day ago Full time Competitive

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.
Recommended Jobs
Vertus Partners
Data Engineer/Integration Analyst (Python)
Vertus Partners
London, United Kingdom
Mayford James
Data Analytics Specialist
Mayford James
London, United Kingdom
Dare
Graduate Analyst - Risk & Finance
Dare
London, United Kingdom
Mayford James
Analyst, Data Analytics
Mayford James
London, United Kingdom
Leverton Search
Data Analyst - Investment Management
Leverton Search
London, United Kingdom