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 is essential.
- Other info: Be part of a diverse team that values individuality and collaboration.
The predicted salary is between 28800 - 48000 £ per year.
We're 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 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
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who works in business intelligence. Building relationships can open doors that a CV just can't.
✨Show Off Your Skills
When you get the chance to chat with potential employers, don’t hold back on showcasing your SQL and Power BI skills. Bring examples of dashboards or reports you've created to demonstrate your expertise and make a lasting impression.
✨Tailor Your Approach
Every company is different, so tailor your conversations to align with their values and needs. Research Hamilton’s culture and think about how your experience fits into their vision. This shows you're genuinely interested and not just sending out generic applications.
✨Follow Up
After any interview or networking event, send a quick thank-you email. It’s a simple way to keep the conversation going and remind them of your enthusiasm for the role. Plus, it shows you’re proactive and professional!
We think you need these skills to ace Business Intelligence Analyst
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, be sure to include examples of how you've tackled complex data challenges in the past. We love seeing candidates who can think critically and come up with innovative solutions, so let us know how you've done this!
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 vibrant team at Hamilton!
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 heavily 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.
✨Showcase Your Dashboard Skills
Since you'll be designing dashboards, bring examples of your previous work with Power BI or similar tools. Talk about the challenges you faced and how you overcame them, as well as how you ensured the dashboards met user needs.
✨Understand the Business Context
Familiarise yourself with the insurance industry and how business intelligence plays a role in it. This will help you connect your technical skills to real-world applications during the interview, showing that you understand the bigger picture.
✨Communicate Clearly with Stakeholders
You'll need to collaborate with various stakeholders, so practice explaining complex technical concepts in simple terms. During the interview, demonstrate your communication skills by clearly articulating your thought process and how you gather requirements.
