Power BI and SQL Developer
Power BI and SQL Developer

Power BI and SQL Developer

City of London Full-Time 36000 - 60000 £ / year (est.) No home office possible
Go Premium
i3

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

Join a dynamic team in the heart of London, where we prioritise innovation and collaboration in the insurance sector. As a Power BI and SQL Developer, you'll benefit from a hybrid work model that promotes work-life balance, alongside opportunities for professional growth and development in a supportive environment. Our commitment to data excellence and compliance ensures that you will be at the forefront of delivering impactful insights that drive business success.
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

Power BI
DAX
Power Query
SQL
T-SQL
ETL Tools
SSIS
Azure Data Factory
Data Modelling
Star Schema
Snowflake Schema
Azure SQL
Synapse Analytics
London Market Insurance Knowledge
Bordereaux Processing

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.

Power BI and SQL Developer
i3
Location: City of London
Go Premium

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>