At a Glance
- Tasks: Support the Actuarial pricing team with data transformation and model testing.
- Company: Join a diverse and inclusive company that values your unique contributions.
- Benefits: Enjoy flexible hybrid work, extensive benefits, and wellbeing support.
- Other info: Great opportunity for career growth in a dynamic environment.
- Why this job: Make an impact by transforming pricing models and collaborating with talented teams.
- Qualifications: Strong IT skills, knowledge of Excel, SQL or Python, and a Maths or Computer Science degree.
The predicted salary is between 40000 - 50000 £ per year.
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 (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. 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 RuleBook, 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 RuleBook, triage issues and allocate them to the correct teams for resolution.
- Assist with rule‑book development work – although RuleBook 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 PowerPivot, and scrape historical data from pricing models for migration into RuleBook 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., PowerBI) 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 PowerBI or Tableau.
- Essential
- 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.
- Essential
- 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
As an Excel Data Transformation Analyst within our Actuarial pricing team in London, you will thrive in a dynamic and inclusive work environment that champions collaboration and innovation. We offer a flexible hybrid work model, extensive non-contributory benefits, and ample opportunities for professional growth, ensuring that every employee feels valued and empowered to contribute meaningfully to strategic projects and data transformation initiatives.
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
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.
