Bordereau Management Data Analyst

SiriusPoint

Bordereau Management Data Analyst for SiriusPoint analyzing and managing critical bordereaux data. Collaborating with stakeholders to develop insights and drive data quality standards.

Posted 5/12/2026full-timeRemote • 🇺🇸 United StatesSeniorLead💰 $100,000 - $120,000 per yearWebsite

Tech Stack

Tools & technologies

PythonSparkSQLSSIS

About the role

Key responsibilities & impact

Become an internal SME for the US 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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data analysisdata managementdata modellingdata processingdata mappingdata integrationacceptance testingdata quality monitoringdata interpretationdata standards

Soft Skills

organizational skillswritten communicationverbal communicationpresentation skillscritical thinkinganalytical abilitiesleadership skillscollaborationproblem-solvingproject management