Business Intelligence Analyst
We're looking for an 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.
Key responsibilities include translating business needs into technical specs, support building data warehouses, optimizing queries, ensuring completeness of data and collaborating with analysts, data engineers, and stakeholders to support strategic planning and performance monitoring.
What you will do
- 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.