27 days old

Data Analyst

Canopius US Insurance Inc
Chicago, IL 60606
Apply Now
Apply on the Company Site
  • Job Code

The Role

This role is primarily responsible for providing support for the processing of and reconciling of risk, claims and premium data received from appointed agents and claims third party administrators (TPAs). Involves collaboration with agents and TPAs as well as internal business units, including but not limited to underwriting, finance and claims.

Responsibilities will include:

Bordereaux processing

  • Prepare incoming risk and premium bordereaux for processing, including but not limited to translating to standard format
  • Provide quality assurance of MGA data by cleaning, filtering and running data control checks and validations using most appropriate and relevant methods.
  • Work with agents, TPAs, vendors, underwriters, claims and finance to resolve data errors and omissions within reasonable time frames in accordance with the monthly closing schedules.

Data Analysis

  • Run queries to identify any exceptions to underwriting guidelines.
  • Analyze underwriting exception query results and provide feedback to underwriters.
  • Run queries as needed to identify inconsistencies in bordereaux data.


  • Perform testing of enhancements and defect fixes for the bordereaux management system.

Claims Administration (if applicable)

  • Update system with new catastrophe codes as needed.
  • Perform TPA funding report reconciliation.
  • Assist with other projects and tasks related to claims administration and processing.

Essential Skills & Experience

  • Strong analytical skills
  • Extensive knowledge of bordereaux data across a large number of different business lines
  • Excellent written and verbal communication skills
  • Intermediate to Advanced Excel knowledge and skills in other Microsoft Office products in order to support MI and Reporting
  • The ability to plan work and meet deadlines
  • The ability to carry out data quality control, validation and linkage
  • The ability to produce and interpret clear graphical representations and data visualizations
  • Ability to handle a diverse range of priorities and tasks
  • Delivery focused and deadline driven
  • Excellent attention to detail
  • Flexible working style
  • Change centric with a focus on continuous improvement
  • Problem-solver

About Canopius

Canopius is a global specialty lines (re)insurer. We are one of the leading insurers in the Lloyds of London insurance market with offices in the UK, US, Singapore, Australia and Bermuda.

At Canopius we foster a distinctive, positive culture which enables us to bring our whole selves to work to flourish as people, and build a business which delivers profitable, sustainable results.

Based in incredible new offices in the heart of the City of London, Canopius operates a flexible, hybrid working model and is committed to providing an environment that challenges employees to be their best and where everyone's unique contributions are recognised, valued and respected.

We offer all employees a comprehensive benefits package that focuses on their whole wellbeing. Canopius market-leading proposition offers financial, physical, social and psychological health and wellbeing benefits to ensure we create a working experience which gives everyone the freedom to do their best work.

We are fully committed to equal employment opportunities for all applicants and providing employees with a work environment free of discrimination and harassment. All employment decisions are made regardless of age, sex, gender identity, ethnicity, disability, sexual orientation, socio-economic background, religion or beliefs, marital or caring status, or any other status protected by the laws or regulations in the locations where we operate. We encourage and welcome applicants from all diverse backgrounds.

We make reasonable adjustments throughout the recruitment process and during employment. Please let us know if you require any information in an alternate format or any other reasonable adjustments.


Posted: 2022-08-31 Expires: 2022-10-02

Job Opportunities

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Analyst

Canopius US Insurance Inc
Chicago, IL 60606

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast