SQL Developer (Contract)

Описание вакансии

Policy Expert – SQL Developer (Contract)  

🚀Are you ready to transform the insurance industry? 

Policy Expert is a forward-thinking business that loves to get things done. Leveraging proprietary technology and smart data, we offer reliable products and a wow customer experience. 

Having achieved rapid growth since being founded in 2011, we’ve won over 1.5 million customers in Home, Motor and Pet insurance and have been ranked the UK’s No.1-rated home insurer by Review Centre since 2013. 🏆 

Hear from our team about what it's like working at Policy Expert ✨ 

About the PricingTeam: 

As one of the fastest growing Insurers in the UK, you will enjoy a fast-paced environment and thrive in a forward-thinking culture. You will be part of a team utilizing advance analytics and machine learning techniques applied in pricing structures. You will be working in collaboration with the data engineering team and the quote engine team to support the bespoke pricing algorithms. 

Your day to day: 

• Production of high-quality Management Information (MI) and analytical datasets
• Development of structured datasets for risk models, including accident month and exposure views
• Building clean analytical datasets from complex operational insurance systems
• Handling versioned records, mid-term adjustments (MTAs), endorsements, cancellations and renewals
• Producing coherent time-based views (e.g. written vs earned, point-in-time vs as-at reporting)
• Integrating and reconciling data across multiple source systems into warehouse/reporting layers
• Supporting pricing, underwriting and commercial stakeholders with data outputs
• Translating business questions into structured SQL logic without heavy specification
• Documenting data logic clearly to ensure reusability and continuity post-contract
• Supporting automation and scheduling of regular data production

Who are you: 

• Proven experience working directly with UK General Insurance data (Motor and/or Home)
• Strong understanding of: 

+ Policies, risks and covers

+ Quotes, renewals, endorsements and cancellations

+ Claims lifecycle and its relationship to policy exposure

• Experience handling transaction-based insurance data structures
• Ability to interpret policy lifecycle events into analytical views

Technical Capability 

• Advanced SQL skills (clean, structured, reusable code)
• Experience building datasets from operational systems with: 

+ Versioned records

+ Partial histories

+ Duplicates

+ Mid-term adjustments

• Experience working across multiple data sources feeding warehouses/reporting environments
• Familiarity with automation and scheduling tools for recurring data production

What We Stand for and Next Steps 

“We pride ourselves on being an equal opportunity employer. We treat all applications equally and recruit based solely on an individual’s skills, knowledge, and experience. The quality and growing diversity of our team is a testament to this commitment”  

At Policy Expert, we are committed to fostering an inclusive and supportive environment for all candidates. If you require any reasonable adjustments during the interview process to accommodate your needs, please do not hesitate to let us know. We are dedicated to ensuring every candidate has an equal opportunity to succeed and will work with you to provide the necessary support. 

We aim to be in touch within 14 working days of your application – you will be notified if successful or unsuccessful. Please be encouraged to apply even if you do not meet all the requirements. 

Useful links: 

Glassdoor | Trust Pilot