Senior Data Analyst

HCV Underwriting Managers

Senior Data Analyst extracting and analyzing insurance data to provide insights for product and underwriting teams. Collaborating with stakeholders to ensure data accuracy and accessibility while mentoring junior analysts.

Posted 6/4/2026full-timeRemote • 🇺🇸 United StatesSeniorWebsite

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

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, identifying gaps, mapping issues, and reporting impacts.
Work with business stakeholders to identify and align data initiatives with business goals to determine data analysis and reporting needs.
Partner with stakeholders to build recurring reports and dashboards using BI tools and fit-for-purpose datasets; use SQL to source and validate logic.
Lead root cause analysis to explain data variances or emerging business trends; communicate findings with clarity and urgency.
Collaborate with data engineers to understand pipeline logic, recommend field-level enhancements, and support fixes across BDX ingestion, mapping, and transformation.
Define data models and structures that align with business requirements, ensuring data is organized and accessible for analysis.
Establish data quality rules, validation checks, and cleaning procedures for insurance datasets, including BDX submissions.
Monitor and escalate data quality issues with recommendations for resolution.
Own and document key business metrics, calculations, and definitions for downstream consumers.
Mentor and support junior analysts with analytical logic, quality checks, and data storytelling.
Maintain and update metadata that describes the data assets, ensuring proper understanding and usage of the data.
Create process flows and documentation for data collection, transformation, and analysis workflows.

Requirements

What you’ll need

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

Benefits

Comp & perks

Remote First Work Environment (US Based)
Medical, Dental, Vision
401K, 401K Match
Life and Disability Benefits
Unaccrued Paid Time Off
11 Paid Holidays
Employee Discounts
Employee Assistance Program
Educational Assistance Program
Employee Referral Program
Paid Parental Leave

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

SQLdata analysisbusiness intelligencedata validationdata reconciliationdata mappingdata modelingdata qualitydata cleaningdata storytelling

Soft Skills

critical thinkingcommunicationdocumentationmentoringcollaboration