Analyst / Senior Analyst, Data Quality

Ledgebrook

. Investigate and resolve data issues by identifying, tracing, and resolving root causes of data discrepancies .

Posted 10/22/2026full-timeRemote • United States, CanadaSenior💰 $80,000 - $120,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in analyzing Property & Casualty insurance data and implementing data validations to enhance data quality. Proficient in SQL, Excel, and Power BI for data modeling and reporting, with a strong focus on collaboration across teams to support regulatory compliance.

Highest-signal resume keywords

Advanced SQLData Quality ImprovementProperty & Casualty Insurance Data AnalysisPower BI ReportingData Integration with Finance/ERP Systems

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

Data ValidationData ReconciliationData Workflow DesignData Discrepancy ResolutionData ModelingAutomated ChecksAI Tool IntegrationExcelPythonPower Query

Soft Skills

Excellent CommunicationAttention to DetailSelf-StarterAccountabilityAdaptability

Tools & Technologies

Power BIExcelSnowflakeWorkdayAI Tools

Industry Keywords

Property & Casualty InsuranceMGAClaims DataPremium DataRegulatory Compliance

Tech Stack

Tools & technologies

ERPPythonSQL

About the role

Key responsibilities & impact

Investigate and resolve data issues by identifying, tracing, and resolving root causes of data discrepancies
Implement data validations, reconciliations, and controls to improve data quality
Build and maintain automated checks monitoring policy, premium, and claims data integrity
Translate business requirements into specifications for Data Engineering
Define and document shared data definitions
Design data workflows and system integrations supporting the company’s growth from MGA to full-stack carrier
Collaborate with engineering, data excellence, pricing and analytics, finance, and compliance teams
Drive organizational trust in reporting and analytics and support adherence to regulatory requirements

Requirements

What you’ll need

Experience analyzing Property & Casualty (P&C) insurance data, including policy, premium, claims, or submission metrics, in support of actuarial, analytics, or finance functions
Advanced SQL, Excel, and Power BI for investigation, data modeling, and reporting
Excellent communication and presentation skills
Close attention to detail and ability to trace complex data inconsistencies to their source
Comfort integrating AI tools into day-to-day workflows
Self-starter who takes accountability, thrives in a fast-paced environment, and handles ambiguity well
Familiarity with integrating data with finance/ERP systems such as Workday
Experience at an MGA or a carrier that partners with MGAs
Exposure to Snowflake, Python, Power Query, and/or AI tools
Must be authorized to work in the U.S. or Canada without current or future employer-sponsored work authorization

Benefits

Comp & perks

Full remote flexibility and asynchronous work culture
Unlimited PTO and fully paid sick leave
Comprehensive health benefits, including medical, dental, and vision coverage, plus HSA and FSA options
401(k)
Company-paid life insurance
Disability coverage
Equity incentive program