Senior Data Analyst

Role Overview

Mission Underwriting Services is hiring a Senior Data Analyst to turn raw insurance data into actionable insights for product, underwriting, operations, and executive leadership. The role focuses heavily on insurance data, especially bordereaux (BDX) submissions, along with strong SQL and BI/reporting skills.

What You’ll Do

• 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 reporting impacts.
• Partner with stakeholders to align data initiatives with business goals and define reporting/data 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 results to both technical and non-technical audiences.
• Collaborate with data engineers on pipeline logic; recommend field-level enhancements and support fixes across BDX ingestion, mapping, and transformation.
• Define data models/structures aligned to business needs to ensure data is organized and accessible.
• Establish data quality rules, validation checks, and cleaning procedures for insurance datasets (including BDX submissions).
• Monitor and escalate data quality issues with recommended resolutions.
• Own and document key business metrics, calculations, and definitions for downstream consumers.
• Mentor junior analysts (analytical logic, quality checks, and data storytelling).
• Maintain and update metadata describing data assets.
• Create process flows and documentation for data collection, transformation, and analysis workflows.

Qualifications

• 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 collaborating cross-functionally with engineering, product, and business teams.

Preferred Qualifications

• Not specified (text cut off after “Familiarity with”).