Data Analyst (Excel) - (Math/numerical grad)

Data Analyst (Excel) - (Math/numerical grad)

Full-Time 30000 - 40000 Β£ / year (est.) No working from home possible
Chaucer Group

At a Glance

  • Tasks: Support the Actuarial pricing team with data analysis and model development.
  • Company: Chaucer, a leading global insurer with a diverse and inclusive culture.
  • Benefits: Flexible hybrid work model, extensive benefits, and wellbeing support.
  • Other info: Collaborative environment with opportunities for growth and learning.
  • Why this job: Join a dynamic team and make an impact in the insurance industry.
  • Qualifications: Degree in Maths or related field; strong Excel and data skills required.

The predicted salary is between 30000 - 40000 Β£ per year.

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

  • 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.
  • Provide underwriters with ad-hoc technical support for Rulebook, triaging issues and allocating them to the correct teams for resolution.
  • Assist with production and testing of relevant pricing data extracts and pipelines.
  • 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.
  • 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

  • Build Pricing Insights dashboards in Excel and visualisation tools.
  • 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.
  • Develop and support on pricing and data management activities, working collaboratively with senior pricing actuaries in the team.

General

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

Technical skills

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

Preferred

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

Education & Experience

  • 2.1 or 1st degree in a Maths or numerical related subject (including 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.
  • Self-motivated, hard-working and committed.
  • Able to collaborate, work as a team managing downwards and upwards and communicate with staff at all levels.

Why Join Chaucer?

Chaucer is a leading global insurer operating in both Lloyd's and company markets, helping industries worldwide manage risk-from nuclear, shipping, manufacturing, and property. Headquartered in London, with offices in Copenhagen, Bermuda, Sydney, Ireland, Miami, Dubai, and Singapore, we're close to our clients wherever they are. We offer:

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

Contact Details:

Chaucer Group Recruitment Team

We think you need these skills to ace Data Analyst (Excel) - (Math/numerical grad)

Excel
SQL
Python
Data Manipulation
Data Validation
Dashboard Development
PowerPivot