Bordereau Management Data Analyst - A&H Programs

r

Bordereau Management Data Analyst – A&H Programs

New York/Connecticut - Hybrid

Who We Are

SiriusPoint is a global insurance and reinsurance company created from the merger of Third Point Re and Sirius International Insurance Group. We are a top global (re)insurer writing a worldwide portfolio of businesses including Accident & Health, Liability, Property and Specialty.

Bermuda-headquartered and listed on the New York Stock Exchange (NYSE: SPNT), we are looking at ways to grow intelligently, underwrite profitably, and drive technology innovation in the insurance industry.

We challenge convention, disrupt the traditional way of doing things, and devise new and better solutions. We strive to be excellent in everything we do, and we always strive to continuously build knowledge and learn beyond our current skillsets. 

Join Our Team  

As we continue to grow and evolve our MGA & Program business, we are seeking a talented Bordereaux Management Data Analyst. This individual will join our Bordereaux Management Product team to help ingest and process bordereaux data. This data contains critical information about policies, premiums, claims, and risk exposures provided by our distribution partners. The role involves incorporating this data into our Bordereaux Management System (BMS) and collaborating with business stakeholders. This collaboration aims to develop business insights, analytics, and reports to meet the needs of various functions across SiriusPoint.

You will collaborate closely with cross-functional teams to define data standards, negotiate data requirements with our 3rd party partners, and implement best practices for data management (mapping, validation and transformations), integration, and analysis. This role offers an exciting opportunity to work on cutting-edge technologies, solve complex data challenges, and drive impactful insights that fuel our company's success.

Key Responsibilities

• Become an internal SME for the Accident & Health MGA & Program business, taking charge of gaining a deeper understanding of the products and associated data, and making determinations on data interpretation for downstream onboarding, including validating data accuracy and quality.
• Expand and refine existing data standards for MGA & Program business by collaborating with business and technology teams to maintain data dictionaries and data templates.
• Work closely with Program Managers to negotiate and gather the required policy, premium, claims, and risk exposure data from Brokers, MGAs, Coverholders, or TPAs and escalate issues to internal teams where necessary.
• Manage the end-to-end data onboarding process for the Bordereaux Management System (BMS) including but not limited to:
  • Analysing and mapping data to verify the accuracy and completeness of data that has been collected. This may involve checking for duplicate entries, missing information, or incorrect figures. 
  • Work with data engineering teams to integrate data into our Bordereaux Management System (BMS).
  • Perform acceptance testing on data that has been loaded to ensure it reconciles to source files and aligns to the mapping and validation rules that have been defined.
  • Monitor and address data quality issues to ensure compliance with agreed standards and timelines, either by resolving them internally or contacting partners for corrections.
• Collaborate with our internal Business Intelligence (BI) team and key business stakeholders to develop insights, analytics and reports to:
  • Identify trends, potential risks, and areas for improvement with regards to the overall performance of a portfolio.
  • Monitor whether Brokers, MGAs, Coverholders, or TPAs are meeting the terms and conditions of the Program Management Agreements (PMA) and Binding Authority Agreements.
  • Meet the needs of regulators, reinsurers, market bodies and internal compliance teams, including ISO/ISS, Lloyds, premium tax etc
• Implement continuous improvement processes to increase efficiency, reduce errors and improve oversight & decision making.
• Develop and enforce best practices in areas of master and reference data management, data mapping, data modelling and data integration with regards to the Bordereaux Management System (BMS)
• Ensure process and training documentation in relation to Bordereaux Management Procedures are kept up to date.
• Stay aware of market standards (including ACORD and Lloyds), changes to bordereaux data and processing requirements.

United Behind Common Goals

At SiriusPoint we work as one team across our global business, and we unite that team behind common goals, understanding the positive impact we can all make. We aim to retain and attract great people, knowing they can achieve a rewarding and enriching career at SiriusPoint.

Our Purpose is to provide security and resilience in an uncertain world.

Our Vision is to be recognized as a best-in-class insurer and reinsurer, utilizing deep risk capabilities to protect our customers. Blending our talent, expertise and data to provide intelligent risk solutions.

Our culture is one of performance and accountability. Our people are our experts, and you will be empowered to apply your expertise in a supportive, collaborative and purposeful environment.

Our Values are at the heart of our business, and which guide everyday actions and decision making.

• Integrity: Integrity, respect and trust are our core principles
• Customer Focused: Our customers are the reason we exist
• Solution Driven: Creating solutions is our mindset
• Diversity: Diversity, inclusion and allyship make us stronger
• Collaboration: Collaboration drives outperformance

This role is ideal for a proactive and detail-oriented professional who is passionate about IT governance and controls. If you thrive in a dynamic environment and are committed to maintaining high standards of IT control, this position offers a rewarding opportunity to make a significant impact.

Your skills and abilities should include:

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
• 10+ years of experience in data analysis and data management.
• 5+ years of experience in the (Re)insurance industry, across US Property & Casualty, International Markets and Life, Accident & Health segments.
• Strong capabilities working with the latest business intelligence tools and query tools, specifically Power BI, SQL and Spark.
• Strong understanding of data modelling and data processing frameworks such as SSIS, Python and Databricks.
• Excellent data analysis and data management documentation skills. 
• Excellent organizational, written, verbal and presentation skills. 
• Excellent critical thinking and analytical abilities, particularly with regards to data management.
• Ability to work individually with limited oversight.
• Strong leadership skills fostering collaboration and driving solutions within a data team.
• Ability to prioritize, multi-task, and maintain flexibility in a fast-paced, changing environment.
• Demonstrated ability to influence and work effectively within a global organization with employees at all levels.
• Motivated, team-oriented, with strong problem-solving and project management skills.

SALARY:  The estimated salary range for this position is $100,000 to $120,000 per year. This is a good-faith assessment of the salary range for this position only.  In determining the actual salary within this range, SiriusPoint will consider a candidate’s relevant experience, location, and other job-related factors.

Why Should You Join SiriusPoint?

Our people are our experts, and from day one you will be empowered to apply your expertise in a supportive, collaborative, and purposeful environment. Our Values - Integrity, Customer Focused, Solution Driven, Diversity, and Collaboration - are at the heart of our business, and they guide our everyday actions and decision making. We also unite our global team behind common goals, ensuring you can make a meaningful impact.

We aim to retain and attract great people, knowing they can achieve a rewarding and enriching career. We offer a competitive and above market compensation package.  The following are some of the benefits and perks we offer our employees:

•Medical 

•Dental 

•Vision

•FSA Medical and Dependent care

•Health Savings Account (HSA)

•EAP

•Basic Life and AD&D (company paid)

•Basic Long-Term Disability (employer) paid-Taxable income

•Employee paid Long Term Disability(voluntary)

•Company Medical Leave, Parental leave- 8 weeks full pay after 6 months of service

•Voluntary benefits: short term disability, Critical illness, Hospital Indemnity, Accident

•Travel assistance programs Company paid

•401(k) 6 % safe harbor match, fully vested after two years, pre- and post-tax contributions allowed

•Gym reimbursement

•Legal plan 

•Pet Insurance 

•Tuition reimbursement

•Generous PTO

•Flexible work arrangement

•Fully stacked pantry on-site

•Team outings

•ERG Groups

We Achieve More Together

At SiriusPoint, we know that diversity, inclusion and allyship make us stronger. We value and are committed to supporting the unique voices, backgrounds, cultures, lifestyles, and contributions of the diverse global employee base that make up our business.

We know that a diverse and equitable culture, where all voices are included and heard, is critical to our success as an employer. We are committed to developing our DE&I strategy to ensure that SiriusPoint remains a supportive and empowering place of work.