At a Glance
- Tasks: Support the Actuarial pricing team with data transformation and model development.
- Company: Join Chaucer, a leading insurance group at Lloyd’s, with a diverse and inclusive culture.
- Benefits: Flexible working arrangements, competitive salary, and opportunities for professional growth.
- Other info: Dynamic environment with excellent career growth opportunities and a commitment to diversity.
- Why this job: Make an impact by transforming pricing models and collaborating with industry experts.
- Qualifications: Strong IT skills, knowledge of SQL or Python, and a degree in Maths or Computer Science.
The predicted salary is between 40000 - 50000 € 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 and 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 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 and 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.
- 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, 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 (e.g. PowerBI) as appropriate that visualise real time pricing data. Take ownership of ensuring data used for Data Models and 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.
Relevant experience
- Technical skills
- Essential: Strong IT skills, including knowledge of Excel. Demonstrated 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
- Essential: 2.1 or 1st degree in a Maths or Computer Science 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.
- 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.
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.
Chaucer is committed to diversity, actively values difference and respects people regardless of the protected characteristics which are outlined in the Equality Act 2010 (UK legislation) as a result of the Equal Treatment Directive 2006 (EU legislation). A diverse workforce and an inclusive workplace are core to our success as a business and integral to our winning strategy and culture. We recruit from the widest available pool of talent, and our hiring, assessment and selection process is fair, free from bias and one which ensures we select the right person for the job, based on merit. We are committed to promoting a culture that actively values difference, and recognises that everyone has the right to be treated with dignity and respect throughout their employment. We are open to considering flexible working arrangements for all roles and encourage you to outline your needs during the interview process.
Data Transformation Analyst (Pricing) in London employer: Chaucer Underwriting Services
Chaucer is an exceptional employer, offering a dynamic work environment in the heart of London where innovation meets collaboration. As a Data Transformation Analyst, you will benefit from a culture that values diversity and inclusion, alongside opportunities for professional growth through hands-on experience with cutting-edge pricing technologies. With a commitment to flexible working arrangements and a focus on employee development, Chaucer provides a rewarding career path for those looking to make a meaningful impact in the insurance industry.
Contact Detail:
Chaucer Underwriting Services Recruiting Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Transformation Analyst (Pricing) in London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those working at Chaucer. A friendly chat can open doors and give you insights that might just land you an interview.
✨Tip Number 2
Prepare for the interview by brushing up on your technical skills. Make sure you can talk confidently about data processing languages like SQL or Python, and how you've used them in past projects.
✨Tip Number 3
Show off your project management skills! Be ready to discuss how you've successfully managed multiple workstreams in the past, and how you can bring that experience to the Pricing Transformation team.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team.
We think you need these skills to ace Data Transformation Analyst (Pricing) in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Transformation Analyst role. Highlight your technical skills, especially in data processing languages like SQL or Python, and any relevant experience you have with pricing models or analytics.
Craft a Compelling Cover Letter:Your cover letter should tell us why you're the perfect fit for this role. Mention your project management skills and how you can translate business requirements into technical instructions. Show us your enthusiasm for the position!
Showcase Your Technical Skills:Since this role requires strong IT skills, don’t forget to showcase your proficiency in Excel and any experience with dashboarding platforms like PowerBI or Tableau. We want to see how you can contribute to our Pricing Transformation workstream.
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and ensures you’re considered for the role. Don’t miss out on this opportunity!
How to prepare for a job interview at Chaucer Underwriting Services
✨Know Your Data Tools
Familiarise yourself with the key tools mentioned in the job description, like Excel, SQL, and PowerBI. Be ready to discuss how you've used these tools in past projects, especially in data manipulation and dashboard creation.
✨Understand Pricing Models
Even if you don't have direct experience with RuleBook, it’s crucial to understand the basics of pricing models and how they function. Research common challenges in pricing transformation and be prepared to share your thoughts on how to overcome them.
✨Showcase Your Communication Skills
Since this role involves collaboration with various teams, practice articulating complex technical concepts in simple terms. Think of examples where you've successfully communicated with non-technical stakeholders or managed project updates.
✨Prepare for Scenario Questions
Expect questions that assess your problem-solving skills and ability to handle real-world scenarios. Prepare examples from your experience where you had to triage issues or manage multiple workstreams effectively, highlighting your attention to detail and organisational skills.
