Senior Data Analyst

Role Overview

The Senior Data Analyst will transform raw insurance and bordereaux (BDX) data into actionable insights for product, underwriting, operations, and executive leadership.

Responsibilities

• Use SQL and other analytical techniques to investigate business questions and anomalies across policy, premium, coverage, claims, and BDX data.
• Analyze, reconcile, and validate BDX/bordereaux submissions and partner/carrier feeds; identify gaps, mapping issues, and downstream reporting impacts.
• Partner with stakeholders to align data initiatives with business goals and define reporting/analysis needs.
• Build recurring reports and dashboards using BI tools and fit-for-purpose datasets; use SQL to source and validate logic.
• Lead root cause analysis for data variances and emerging trends; communicate findings to both technical and non-technical audiences.
• Collaborate with data engineers on pipeline logic and recommend field-level enhancements to BDX ingestion/mapping/transformation.
• Define data models and structures aligned to business requirements.
• Establish and maintain data quality rules, validation checks, and cleaning procedures for insurance datasets.
• Monitor and escalate data quality issues with recommended resolution steps.
• Own and document key business metrics, calculations, and definitions for downstream consumers.
• Mentor junior analysts on analytical logic, quality checks, and data storytelling.
• Maintain and update metadata describing data assets and ensure proper usage.
• Create and document process flows for data collection, transformation, and analysis workflows.

Requirements

• 7+ years of experience in data analysis, business intelligence, or analytical roles.
• 4+ years working with commercial or specialty insurance data, including BDX/bordereaux, policy, premium, and claims datasets.
• Hands-on experience with BDX/bordereaux validation, reconciliation, or mapping.
• Strong SQL and Excel skills; experience with large datasets, normalized schemas, and data validation.
• Comfortable using BI tools to build end-user reporting solutions.
• Strong critical thinking, communication, and documentation skills.
• Experience working cross-functionally with engineering, product, and business teams.

Preferred Qualifications

• Not fully provided in the posting (text ends at “Familiarity with”).