At a Glance
- Tasks: Design and develop BI solutions for meaningful insights in London Market insurance.
- Company: Join a leading firm in the London Market insurance sector.
- Benefits: Hybrid work model, competitive pay, and opportunities for professional growth.
- Why this job: Make an impact by transforming data into actionable insights for key stakeholders.
- Qualifications: Expertise in Power BI, SQL, and experience in London Market insurance required.
- Other info: Dynamic role with a focus on data quality and compliance.
The predicted salary is between 36000 - 60000 £ per year.
Job Description
🚀 Power BI & SQL Developer – London Market Insurance
Hybrid – 3 days per week – Contract
About the Role
We're on the lookout for a skilled Power BI & SQL Developer with a strong background in London Market insurance. In this role, you’ll design and develop BI solutions that deliver meaningful insights to teams across underwriting, claims, actuarial, and finance. Your deep understanding of insurance data—particularly bordereaux, policy, and claims data in the Lloyd’s and London Market—is essential.
What You’ll Do
- Build and maintain advanced Power BI dashboards and visual reports
- Write and optimise complex SQL queries, stored procedures, and ETL workflows
- Translate business needs into technical BI solutions by working closely with stakeholders
- Model and structure data for analytics aligned with London Market standards
- Integrate and reconcile data from multiple sources including bordereaux and third-party feeds
- Ensure data quality and compliance through validation and governance processes
- Deliver insights to support performance monitoring, profitability, and risk analysis
- Maintain and enhance existing BI solutions to improve scalability and efficiency
- Support broader data initiatives including governance and documentation
What We’re Looking For
Technical Skills
- Expertise in Power BI (DAX, Power Query) and building impactful dashboards
- Advanced SQL (T-SQL preferred) for managing and querying relational databases
- Experience with ETL tools (SSIS, Azure Data Factory, or similar)
- Strong data modelling skills (star/snowflake schema)
- Familiarity with Azure SQL, Synapse Analytics, or other cloud platforms is a plus
Domain Knowledge
- Solid experience in the Lloyd’s / London Market insurance environment
- Strong grasp of insurance data – policies, premiums, claims, and finance
- Experience with bordereaux processing and delegated authority data
- Awareness of market regulations (e.g., Core Data Record, Solvency II)
Power BI and SQL Developer employer: i3
Contact Detail:
i3 Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Power BI and SQL Developer
✨Tip Number 1
Network like a pro! Reach out to your connections in the London Market insurance sector. Attend industry events or webinars, and don’t be shy about introducing yourself. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and SQL queries. This is your chance to demonstrate your expertise and make a lasting impression. Share it during interviews or even on LinkedIn!
✨Tip Number 3
Prepare for those interviews! Research common questions related to Power BI and SQL, especially in the context of London Market insurance. Practise your answers and think of examples that highlight your experience with data modelling and ETL processes.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities waiting for you. Plus, applying directly can sometimes give you an edge over other candidates. So, get your application in and let’s get you that job!
We think you need these skills to ace Power BI and SQL Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Power BI and SQL Developer role. Highlight your experience with London Market insurance and any relevant projects you've worked on. We want to see how your skills match what we're looking for!
Showcase Your Skills: When writing your application, don’t just list your technical skills—show us how you’ve used them in real-world scenarios. Talk about the dashboards you've built or the SQL queries you've optimised. This helps us understand your practical experience.
Be Clear and Concise: Keep your application clear and to the point. Use bullet points where possible to make it easy for us to read. We appreciate a well-structured application that gets straight to the good stuff without unnecessary fluff!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to track your application status. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at i3
✨Know Your Power BI Inside Out
Make sure you’re well-versed in Power BI, especially DAX and Power Query. Prepare to discuss specific dashboards you've built and the impact they had on decision-making. Bring examples of your work to showcase your skills.
✨SQL Skills Are Key
Brush up on your SQL knowledge, particularly T-SQL. Be ready to explain complex queries you've written and how they improved data retrieval or reporting processes. Practising some common SQL problems can really help you shine.
✨Understand the London Market
Familiarise yourself with the nuances of the Lloyd’s and London Market insurance environment. Be prepared to discuss how your experience with bordereaux and claims data can add value to the role. Showing that you understand the industry will set you apart.
✨Engage with Stakeholders
Demonstrate your ability to translate business needs into technical solutions. Think of examples where you’ve collaborated with stakeholders to deliver BI solutions. This shows you’re not just a techie but also someone who understands the bigger picture.