MI/BI Analyst – IT

Job Vacancy
Nov. 2022


Bell & Clements is a specialist insurance company offering expertise in underwriting, broking and capacity management provisions for Excess and Surplus (E&S) lines insurance solutions. The unique combination of broking and underwriting divisions provides the ability to quote and bind risks through inhouse binding authorities, while providing customers with access to Lloyd’s, US and international markets. Bell & Clements has been part of the Munich Re Group since 2007 and is a registered Lloyd’s broker. There are over 150 staff based across the London headquarters and two U.S offices in Virginia and New Jersey with close collaboration throughout.

Bell & Clements offers industry leading technology solutions that benefit both customers and inhouse processes. Being part of the Munich Re Group enables an inclusive culture that is progressive and ambitious with an established employee benefits program.

The Role -  MI/BI Analyst reporting to the Manager of Data Analytics

An exciting opportunity to join an innovative Lloyd's of London insurance broker based in the City of London.

You will join our Data Analytics team and leverage our unique data warehouse and real-time data capture capabilities to build modern solutions to deliver data analytics to both our internal Underwriting and Claims teams as well as our clients and the London and Company Insurance Markets.

As an MI/BI Analyst you must have a passion for data, accuracy and efficiency. This varied role is based within the Information Technology department and will involve the development, maintenance and ownership of Management Information solutions to facilitate the business in providing statistical data including, premiums, claims, loss ratios, rates, aggregate exposure and KPI’s.


  • Working on all phases of the data, MI/BI life cycles, including analysis, design, development, testing, deployment, documentation and maintenance of solutions.
  • Analyse, critique, review and continually improve existing MI/BI solutions following best practice.
  • Manage and resolve service requests and system incidents so that the users can continue to conduct business processes effectively.
  • Working with internal business units and external clients to support and develop Management Information dashboards and reports.
  • Collaborate with the Underwriting, Broking and Claims handling teams to ensure that analytical and reporting needs are met. You will be required to support the teams by providing useful insights and analysis on an ad-hoc basis.
  • Collaborate with the Data Analytics and Software Development teams to extend and maintain the data warehouse for future analytical requirements.
  • Evaluate emerging technologies by building analytical prototypes and solutions based on business requirements to enhance the analytical capabilities of the company.

Key Skills and Experience

  • Minimum 3 years’ experience in Management Information/Business Intelligence within Company or London Insurance Market (broking or syndicates).
  • Degree with mathematical/computing components or relevant experience for this role.
  • Strong SQL and data manipulation skills in Microsoft SQL Server required.
  • Experience of dashboard and reporting development required.
  • Understanding of data warehouse principles and coding practices required.
  • Strong SSRS and Tableau or relevant Business Intelligence presentation layer tool experience (e.g. QlikView, Domo or Microsoft Power BI) required.
  • Must have strong interpersonal, team building, written and verbal communication skills.
  • Excellent organisational skills and a track record of working in a team.
  • Detail oriented and analytical mind with problem solving capabilities.
  • Strong Microsoft Excel skills desirable.

Terms and Conditions

  • This position is offered on a Permanent basis.
  • Annual salary will be dependent on the skills and experience of the successful candidate.
  • Benefits as per Bell & Clements standard employee offering

Equal Opportunities

Bell and Clements is an equal opportunities employer and positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, transgender status, religion or belief, marital status, or pregnancy and maternity.

Category: Job Vacancy
Tags: London