Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop business intelligence solutions like dashboards and reports.
- Company: Join Hamilton, a vibrant and collaborative insurance company in London.
- Benefits: Enjoy a supportive culture, competitive salary, and opportunities for growth.
- Why this job: Make an impact with data while working in a dynamic environment.
- Qualifications: Experience in SQL, Power BI, and data analysis required.
- Other info: Be part of a diverse team that values individuality and collaboration.
The predicted salary is between 36000 - 60000 £ per year.
We are looking for a Business Intelligence Analyst based in London. The Business Intelligence Analyst will be involved in designing, developing and maintaining business intelligence solutions (dashboards, reports). Gather business requirements from users and work closely with the Group technical data engineering team.
Responsibilities:
- Developing, testing, and documenting complex pipelines from a design specification into the enterprise data warehouse.
- Knowledge of Facts and Dimensions within the enterprise data warehouse.
- Design and implement database structures to meet application requirements.
- Develop, test, and deploy SQL queries and stored procedures where necessary.
- Optimize and tune SQL queries for performance.
- Use data models to represent business processes and information requirements.
- Collaborate with stakeholders to understand data needs and design appropriate reports/dashboards.
- Ensure the security model based on privacy requirements, confirm safeguards are followed.
- Participate in reviews of work to ensure developments are standardised, reliable, and maintainable.
- Run/participate in Business Intelligence monthly working group for data users.
- Communicate well with stakeholders at all levels.
- Efficiently manage workload priorities based on the needs of multiple business units.
What you require for the role:
- Experience in SQL, ADF and Azure Analysis Services.
- Experience in using all Microsoft applications.
- Familiarity with software management tools such as DevOps, Azure, and JIRA for project maintenance and user story documentation.
- Experience with three or more of the following: data processing automation, data quality, data warehousing, data governance, business intelligence, data visualization, data privacy.
- Experience of full cycle development, designing, coding, testing, and correcting complex SQL models and scripts.
- Knowledge of data analysis, data modelling and quality assurance techniques.
- Knowledge of version control systems (e.g., Git).
- Certifications in relevant database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate).
- Possess the ability to work autonomously and with others.
- Previous experience of working in an insurance environment.
- Strong Power BI experience to create custom dashboards and visualisations.
- Strong experience with DAX to develop complex measures.
- Strong experience working with Semantic models.
- Excellent problem-solving and communication skills.
What you can expect from us:
At Hamilton, we offer a vibrant, entrepreneurial and collaborative workplace shaped by our values: Be Smart, Be Sensible, Be Open and Be More. Our employees consistently say they would recommend Hamilton as a great place to work — a testament to the inclusive, supportive, and empowering culture we’ve built together. We embrace individuality, value diverse perspectives, and recognise the unique contribution each person makes to our continued success.
In good company:
Hamilton (NYSE: HG) underwrites specialty insurance and reinsurance risks on a global basis through its wholly owned subsidiaries. Its three underwriting platforms: Hamilton Global Specialty, Hamilton Select and Hamilton Re, each with dedicated and experienced leadership, provide access to diversified and profitable business around the world. Headquartered in Bermuda, Hamilton has over 600 employees with key underwriting operations in London, Bermuda, the US and Dublin. We work collaboratively, we share a passion for the service and results we deliver, and we know that what we do each day is meaningful – to our customers and our business. We believe we are ‘In good company’ with everyone we interact with.
Business Intelligence Analyst in London employer: Hamilton Insurance Group, Ltd.
Contact Detail:
Hamilton Insurance Group, Ltd. Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Analyst in London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best dashboards and reports. This is your chance to demonstrate your SQL prowess and data visualisation skills, making you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by practising common questions related to business intelligence and SQL. Think about how you can relate your past experiences to the role and be ready to discuss specific projects you've worked on.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team at Hamilton.
We think you need these skills to ace Business Intelligence Analyst in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Business Intelligence Analyst role. Highlight your experience with SQL, ADF, and Azure Analysis Services, as well as any relevant projects you've worked on. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about business intelligence and how your background makes you a great fit for our team. Don't forget to mention your experience with Power BI and DAX!
Showcase Your Problem-Solving Skills: In your application, give examples of how you've tackled complex data challenges in the past. We love candidates who can think critically and come up with innovative solutions, so let us know how you've done this before!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows us you’re keen to join our team at StudySmarter!
How to prepare for a job interview at Hamilton Insurance Group, Ltd.
✨Know Your SQL Inside Out
As a Business Intelligence Analyst, you'll be working extensively with SQL. Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries you've written and how you've optimised them for performance.
✨Familiarise Yourself with BI Tools
Get comfortable with Power BI and DAX, as these are crucial for creating dashboards and visualisations. Bring examples of your previous work or projects where you've used these tools to demonstrate your expertise.
✨Understand the Business Context
Research the company and its industry, especially the insurance sector. Understand their data needs and think about how you can contribute to their business intelligence solutions. This will show that you're not just technically skilled but also understand the bigger picture.
✨Prepare for Stakeholder Communication
Since the role involves collaborating with various stakeholders, practice articulating your thoughts clearly. Think of scenarios where you've successfully communicated complex data insights to non-technical audiences, as this will highlight your communication skills.
