Excel Data Transformation Analyst (Pricing) in London

Excel Data Transformation Analyst (Pricing) in London

London Full-Time 37800 - 46200 £ / year (est.) Hybrid
Chaucer Group

At a Glance

  • Tasks: Support pricing model transformation and assist with data pipelines and analytics.
  • Company: Join a diverse and inclusive actuarial pricing team in London.
  • Benefits: Flexible hybrid work, extensive benefits, and wellbeing support.
  • Other info: Collaborative environment with opportunities for personal and professional growth.
  • Why this job: Make an impact by transforming pricing models and developing insights.
  • Qualifications: Strong IT skills, knowledge of Excel, SQL or Python, and a relevant degree.

The predicted salary is between 37800 - 46200 £ per year.

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 (Rule Book) 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 Rule Book, 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 Rule Book, triage issues and allocate them to the correct teams for resolution.
  • Assist with rule‑book development work – although Rule Book 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 Power Pivot, and scrape historical data from pricing models for migration into Rule Book 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., Power BI) 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 Power BI 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.

Excel Data Transformation Analyst (Pricing) in London employer: Chaucer Group

Chaucer Group is an exceptional employer that prioritises employee development and collaboration, particularly in the dynamic role of Senior Compliance Monitoring & Assurance Lead. With a hybrid work model based in London, we foster a supportive work culture that encourages strategic thinking and innovation, while providing ample opportunities for professional growth and engagement with senior management to drive meaningful improvements across our compliance framework.

Chaucer Group

Contact Details:

Chaucer Group Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Excel Data Transformation Analyst (Pricing) in London

✨Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Chaucer Group!

✨Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Excel Data Transformation Analyst (Pricing) at Chaucer Group.

✨Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Chaucer Group.

✨Apply Directly through Our Website

When you find a suitable opening like Excel Data Transformation Analyst (Pricing) at Chaucer Group, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace Excel Data Transformation Analyst (Pricing) in London

Excel
SQL
Python
PowerPivot
PowerBI
Data Manipulation
Data Validation

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at Chaucer Group, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Chaucer Group. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at Chaucer Group

✨Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

✨Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

✨Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Chaucer Group!

✨Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.