A responsive partner underwriting risk with skill and discipline.
Bordereau Management Data Analyst
Location
United States
Posted
19 days ago
Salary
$100K - $120K / year
Seniority
Lead
Job Description
Bordereau Management Data Analyst
SiriusPoint
• 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.
Job Requirements
- 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
- 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
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
Data Analyst/Engineer
Illumination WorksDigital Transformation, Data Science, Data Engineering, Augmented Reality, IoT, Cloud, and More
• Partner directly with functional customers to capture business needs, translating requirements into technical solutions • Serve as the bridge between technical teams and non-technical business leaders, ensuring alignment and clear delivery schedules • Architect and maintain Power BI dashboards (and optional Tableau reports) • Design and deploy custom business applications using Power Apps to streamline data collection, user inputs, and operational workflows • Perform deep-dive exploratory data analysis using SQL and Python to identify trends and anomalies • Work within the Azure cloud environment to ensure secure, compliant, and optimized data hosting and processing • Maintain rigorous data quality standards and technical documentation
• Analysing large and complex datasets to identify trends, patterns, and opportunities for business improvement. • Creating dashboards, reports, and data visualisations using tools such as Tableau, Power BI, or Looker to communicate insights effectively to stakeholders. • Collaborating with product, engineering, operational, and clinical teams to define reporting requirements and ensure data accuracy and consistency. • Supporting the development and optimisation of data models and data warehouse structures to improve analytical performance and scalability. • Performing statistical analysis to support forecasting, experimentation, and data-driven decision-making. • Translating business questions into analytical frameworks and delivering actionable recommendations based on data findings. • Monitoring data quality and supporting governance processes to maintain reliable and accurate reporting. • Working with cloud-based data platforms and warehousing solutions such as Snowflake to support analytics and reporting workflows. • Supporting ETL and data transformation processes in collaboration with technical teams and data engineers. • Communicating complex analytical findings clearly to both technical and non-technical stakeholders. • Collaborating with stakeholders to prioritise analytical initiatives and align reporting with business objectives. • Assisting with documentation, reporting standards, and best practices for scalable analytics processes. • Working closely with client teams and cross-functional partners to support successful project delivery and measurable business outcomes.
• Data analysis with SQL, Python, and Power BI • Creation of interactive dashboards • Fundamentals of AI and agile project management • Live instruction: online training in a virtual classroom with experienced instructors, data analysts, and AI experts
• Build and maintain E2E inference time tracking (global and per-model). • Monitor how implementation changes impact total request latency. • Detect regressions introduced by suboptimal code paths. • Provide automated alerts & historical trends. • Build dashboards for internal use (engineering, product, leadership). • Provide client-facing usage dashboards (requests, errors, success rate, performance). • Support clients who need visibility to debug their integrations. • Track model-level usage, API endpoints usage, adoption metrics, etc. • Implement metrics, logs, and traces that help the entire platform scale smoothly. • Work closely with DevOps & backend teams to improve system observability. • Provide insights that guide infra decisions (GPU allocation, autoscaling, caching, batching, etc.). • Select and maintain tooling (e.g., Prometheus/Grafana, Datadog, OpenTelemetry, ELK, BigQuery, etc.). • Ensure data pipelines are reliable, accessible, and always up-to-date. • Build simple, easy-to-read dashboards for both technical and non-technical teams.




