Data Analyst

Job Vacancy
Aug. 2022

Introduction

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 -  Data 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 a Data 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 of new Management Information and Advanced Analytics solutions to facilitate the business in providing statistical data including, premiums, claims, loss ratios, rates, aggregate exposure and KPI’s.

Responsibilities

  • Working on all phases of the data, Management Information and Advanced Analytics life cycles, including analysis, design, development, testing, deployment, and maintenance of solutions.
  • Collaborate with the Software Development team to extend and maintain the data warehouse for future analytical requirements.
  • Working with internal business units to support and develop Management Information dashboards and reports.
  • Support Advanced Analytical solutions (e.g. rate modelling, claims triage, loss cost analysis).
  • Evaluate emerging technologies by building analytical prototypes and solutions based on business requirements to enhance the analytical capabilities of the company.
  • 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.

Key Skills and Experience

  • Minimum 3 years’ experience in Data Analytics or 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.
  • Knowledge of data warehouse principles and coding practices required.
  • Experience of data warehouse and reporting development 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.
  • Knowledge of Advanced Analytical life cycles, tools (e.g. Dataiku, Alteryx), languages (e.g. Python, R), techniques (e.g. machine learning, probability theory, regression, clustering, neural networks) desirable.
  • Experience in building Machine Learning or Artificial Intelligence models to aid the predictive analytics and forecasting of results desirable.
  • 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