At a Glance
- Tasks: Support the Actuarial pricing team with data analysis and model development.
- Company: Join Chaucer, a leading global insurer with a diverse and inclusive culture.
- Benefits: Enjoy flexible hybrid work, extensive benefits, and wellbeing support.
- Other info: Collaborate with teams across the globe and grow your career in a dynamic environment.
- Why this job: Make an impact in pricing transformation while developing your technical skills.
- Qualifications: Degree in Maths or related field; strong Excel and data processing 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.
- 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.
- 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.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst (Excel) - (Math/numerical grad) in London
✨Embrace Online Competitions
Get involved in online data science competitions like Kaggle or DrivenData. These platforms not only let you showcase your skills but also help you build a portfolio that stands out to hiring companies like Chaucer Group when you're aiming for that entry-level role.
✨Join Data Science Meetups
Look for local data science meetups or workshops happening in your area. These are perfect for connecting with industry professionals and fellow newbies, giving us the chance to learn the ropes and get our foot in the door at companies like Chaucer Group.
✨Networking Through University Career Services
Don't forget to leverage your university's career services! They often have exclusive internships and networking events specifically for entry-level data science positions. This is a golden opportunity to meet recruiters from companies like Chaucer Group.
✨Spotlight Your Skills Online
Create a strong online presence by sharing your projects and insights on platforms like GitHub or LinkedIn. Make sure to apply directly through Chaucer Group’s career page, where your unique skills can shine in their entry-level data science openings!
We think you need these skills to ace Data Analyst (Excel) - (Math/numerical grad) in London
Some tips for your application 🫡
Show Off Your Data Skills:As you're aiming for an entry-level data science role at Chaucer Group, don't forget to highlight your proficiency in programming languages like Python or R. Dive into your CV and mention any relevant projects or coursework that demonstrate your data analysis skills or machine learning knowledge.
Include Relevant Projects:If you've done any data-related projects, whether in your studies or during a personal quest, showcase them in a portfolio. This gives us a tangible sense of your capabilities and shows your hands-on experience with data manipulation, visualisation, or model building.
Tailor Your Cover Letter:When crafting your cover letter, make sure to express your enthusiasm for data science and how this role at Chaucer Group aligns with your career goals. Consider sharing why you’re drawn to data-driven decision-making and how you see yourself growing in this field.
Show Your Curiosity:In the data science world, curiosity is key! Mention any online courses or certifications you've pursued that complement your studies. This could be anything from a statistics certification to a data visualisation workshop. It shows us you're serious about learning and growing in this field.
How to prepare for a job interview at Chaucer Group
✨Brush Up on Your Statistics
For a data science role, the interview may involve some statistical questions or problems. Make sure you're comfortable with concepts like probability, distributions, and hypothesis testing. This will not only help you answer questions but also show your analytical thinking.
✨Get Hands-On with Tools
Familiarise yourself with popular data science tools like Python, R, and SQL. If you're asked about specific projects, be ready to discuss the tools you used and how they contributed to your analysis. Showing that you not only know the theory but can apply it is essential!
✨Showcase Relevant Projects
As an entry-level candidate, your portfolio is crucial. Bring along examples of data projects you've worked on, whether during your studies or personal projects. Discuss the challenges you faced and how you overcame them, highlighting your problem-solving skills.
✨Prepare for Case Studies
Entry-level interviews in data science often include case studies where you'll have to analyse a dataset or solve a problem on the spot. Try out some practice case studies beforehand, so you're not caught off guard. It's all about displaying your thought process and how you tackle data-driven challenges!
