At a Glance
- Tasks: Support the Actuarial pricing team with data transformation and model development.
- Company: Join a diverse and innovative company committed to inclusivity.
- Benefits: Flexible working arrangements, competitive salary, and opportunities for professional growth.
- Other info: Dynamic role with excellent career progression in a supportive environment.
- Why this job: Make an impact by transforming pricing models and collaborating with talented teams.
- 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 & 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 & 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. Provide underwriters with ad‑hoc technical support for RuleBook, triaging issues and allocating them to the correct teams for resolution.
- 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 (eg PowerBI) as appropriate that visualise real‑time pricing data. 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.
Our requirements
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.
Equal Opportunity Statement: Chaucer is committed to diversity, actively values difference and respects people regardless of protected characteristics as outlined in the Equality Act 2010 (UK legislation) and the Equal Treatment Directive 2006 (EU legislation). 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) employer: Chaucer
Chaucer is an exceptional employer that fosters a collaborative and inclusive work culture, particularly within the Actuarial pricing team in London. Employees benefit from strong support for professional growth, opportunities to engage in innovative projects, and a commitment to diversity and flexible working arrangements, making it a rewarding environment for those looking to make a meaningful impact in data transformation and analytics.
StudySmarter Expert Advice🤫
We think this is how you could land Data Transformation Analyst (Pricing)
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those working in pricing or data analytics. A friendly chat can lead to insider info about job openings and even referrals.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data transformation projects or any relevant dashboards you've built. This gives potential employers a taste of what you can do beyond just your CV.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge. Be ready to discuss how you've used SQL or Python in past projects, and think about how you can translate business needs into technical solutions.
✨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)
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the Data Transformation Analyst role. Highlight your technical data development skills and any relevant projects you've worked on, especially those involving Excel, SQL, or Python.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're the perfect fit for this role. Share specific examples of how you've translated business requirements into technical solutions and your experience with data pipelines or analytics.
Showcase Your Collaboration Skills:Since this role involves working closely with various teams, emphasise your ability to collaborate effectively. Mention any past experiences where you’ve successfully worked with stakeholders or managed projects across different workstreams.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows us you’re keen on joining our team!
How to prepare for a job interview at Chaucer
✨Know Your Data Tools
Make sure you brush up on your Excel skills and get familiar with SQL or Python. Since the role involves data manipulation and dashboarding, being able to discuss your experience with these tools will show that you're ready to hit the ground running.
✨Understand the Pricing Transformation
Familiarise yourself with the concept of pricing model transformation, especially from Excel to RuleBook. Even if you don’t have direct experience with RuleBook, understanding the process and its importance will help you articulate how you can contribute to the team.
✨Showcase Your Project Management Skills
Prepare examples of how you've managed projects or collaborated with teams in the past. Highlight your ability to translate business requirements into technical instructions, as this is crucial for the role. Be ready to discuss specific challenges you faced and how you overcame them.
✨Ask Insightful Questions
Come prepared with questions that demonstrate your interest in the role and the company. Inquire about the current projects the pricing team is working on or how they measure success in their analytics initiatives. This shows that you’re not just interested in the job, but also in contributing to the team's goals.
