Senior Data Analyst

About Mission Underwriting Services

At Mission Underwriters, we provide the capital, issuing paper, and reinsurance access you need to launch your own Program Administrator (PA) business quickly and efficiently. We offer non-recourse capital for qualified underwriters, giving you a manageable risk profile with potential equity upside. By taking care of administrative complexities like compliance, risk management, accounting, and HR, we free you to focus on what you do best underwriting and distribution. Our turnkey platform gets you into the market in just a few months, minimizing disruption to your key relationships. With access to our network of highly rated issuing carriers and reinsurance partners, you can secure coverage with less stress and uncertainty. Built from the ground up, our purpose-driven technology simplifies workflows, enhances responsiveness, and eliminates the burden of outdated legacy systems.

What We Offer

• 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

About the role

The Senior Data Analyst will turn raw data into actionable insights for product, underwriting, operations, and executive leadership. The ideal candidate has deep insurance data experience, especially with bordereaux (BDX) submissions, plus strong data manipulation, SQL, and BI/reporting skills. The role requires curiosity to investigate anomalies across large datasets and the ability to communicate findings to technical and non-technical stakeholders.

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, 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.

Qualifications

• 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.

Preferred Qualifications

• Familiarity with the insurance policy lifecycle, premium development, claims data, and downstream BDX reporting/analytics.
• Exposure to actuarial concepts such as triangle analysis, loss development, or policy cohorting (without needing formal actuarial experience).
• Experience analyzing across multiple systems or data grains (e.g., BDX, carrier, MGA, broker, or claims feeds).
• ·Ability to travel up to 5% of the year.

Knowledge, Skills, Abilities

• Strong relational database and warehousing knowledge; able to use SQL effectively across normalized and denormalized schemas.
• Familiarity with insurance data domains including BDX/bordereaux, policy, premium, claims, endorsements, coverage, and partner feeds.
• Ability to analyze large and complex datasets to identify trends, anomalies, and root causes of data or business issues.
• Proficiency in Excel and BI tools (e.g., Power BI, Tableau, Looker) to design and present intuitive reports and dashboards.
• Skilled at translating ambiguous business questions into structured data analysis and clearly communicating results to varied stakeholders.
• Comfortable collaborating with data engineers, product managers, and business users to validate assumptions, clarify transformation logic, and drive outcomes.
• Detail-oriented with a strong sense of data accuracy, consistency, and version control when working with recurring reports or metrics.
• Able to document queries, field definitions, BDX mapping assumptions, and analytical logic for shared understanding.

Working Conditions

• Requires a quiet work environment with regular sitting at a computer for extended periods of time.
• Regular use of hands and fingers.
• Frequent talking or hearing.
• Vision requirements: Close, distance, color, peripheral, focus and depth perception.

Additional Information
This is a remote position. Planned, in-office activities may be required on occasion (typically 2-4x per year).

You must live in the United States and be authorized to work in the United States without requirement of employment sponsorship/visa.