At a Glance
- Tasks: Design and develop BI solutions for insurance insights using Power BI and SQL.
- Company: Join a leading firm in London Market insurance with a hybrid work model.
- Benefits: Flexible working, competitive pay, and opportunities for professional growth.
- Other info: Dynamic role with a focus on data quality and compliance.
- Why this job: Make an impact by delivering insights that drive performance and profitability.
- Qualifications: Expertise in Power BI, SQL, and experience in London Market insurance.
The predicted salary is between 50000 - 65000 £ per year.
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 in Cardiff employer: i3
Join a dynamic team in the heart of London, where your expertise as a Power BI and SQL Developer will be valued and nurtured. We offer a hybrid work environment that promotes flexibility and work-life balance, alongside opportunities for professional growth within the thriving London Market insurance sector. With a strong focus on collaboration and innovation, you'll have the chance to make a significant impact while working with cutting-edge technologies and data solutions.
StudySmarter Expert Advice🤫
We think this is how you could land Power BI and SQL Developer in Cardiff
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like i3 before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like i3.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like i3.
We think you need these skills to ace Power BI and SQL Developer in Cardiff
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at i3, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to i3, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab i3’s attention and show the tangible impact of your work.
How to prepare for a job interview at i3
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at i3.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at i3.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at i3.
