Senior Data Quality Analyst

Socotra, Inc.; Ottawa; Hybrid; CAD 113,000 - 170,000; Full time

Benefits offered by this job

Remote work

Unlimited PTO

Health benefits

401(k)

Job summary

Ledgebrook is seeking an experienced Senior Data Quality Analyst to join our Product & Data team. You will lead analytical efforts to ensure data integrity across policy, premium, and claims data and drive trust in reporting and analytics.

You will collaborate with engineering, pricing, finance, and compliance to implement data validations, perform root-cause analyses, and design scalable data quality controls for our growing platform.

Qualifications

• Must have experience analyzing P&C insurance data (policy, premium, claims, or submission metrics).
• Advanced SQL, Excel, and Power BI for investigation, data modeling, and reporting.
• Excellent communication and presentation skills to collaborate with stakeholders.
• Attention to detail and curiosity to trace data inconsistencies to their source.
• Comfort integrating AI tools in day-to-day workflows to drive efficiencies.
• Self-starter who thrives in a fast-paced environment and handles ambiguity.

Responsibilities

• Investigate and resolve data issues; identify root causes for stakeholders across product, finance, actuarial, and analytics.
• Strengthen controls by implementing data validations, reconciliations, and processes to improve data quality.
• Monitor data health; build SQL checks and Power BI dashboards for policy, premium, and claims data.
• Bridge business requirements with Data Engineering; define and document shared data definitions.
• Scale data foundation by designing data workflows and system integrations to support growth.

Skills

SQL

Excel

Power BI

Data analysis

Communication

Attention to detail

AI integration

Self-starter

Stakeholder collaboration

Tools

Snowflake

Python

Power Query

AI tools

Job description

Description

At Ledgebrook, we are building a modern data stack and believe a career in data and analytics can be so much more. You bring passion and entrepreneurial spirit; we'll provide the platform and opportunity to unleash the very best of your talents and skills.

About the Role

Ledgebrook is seeking an experienced SeniorData Quality Analyst to join our Product & Data team. On this team, you'll lead analytical efforts to analyze complex data to ensure its integrity and accuracy. You will play a key role in driving organizational trust in reporting and analytics and ensuring adherence to regulatory requirements.

You'll collaborate with engineering, data excellence, pricing and analytics, finance, and compliance teams to improve data quality across the business.

What You'll Do:

• Investigate and resolve data issues: Run deep-dive investigations to identify, trace, and resolve the root cause of data discrepancies for stakeholders across product, finance, actuarial, and analytics.
• Strengthen controls: Find gaps and implement data validations, reconciliations, and controls that improve data quality over time.
• Monitor data health: Build and maintain SQL checks and Power BI dashboards that track the integrity of policy, premium, and claims data.
• Bridge business and engineering: Translate business requirements into clear specifications for Data Engineering, and help define and document shared data definitions.
• Scale our data foundation: Design data workflows and system integrations that support Ledgebrook's growth from MGA to full-stack carrier.

About you

We love working with people who are eager to learn constantly and genuinely excited about the chaotic, rewarding process of building a company from the ground up.

You're a great fit if you bring:

• A Strong Moral Compass: You believe in doing the right thing, period. We have a strict zero-tolerance policy for toxic behaviors.
• Customer-First Empathy: You are passionate about delivering an exceptional experience to everyone you work with, both inside and outside the company.
• Intellectual Curiosity: You naturally question the status quo and love finding innovative ways to solve problems.
• A Growth Mindset: You possess a hunger for continuous learning and want to constantly expand your skillset.
• Urgency & Prioritization: You can pivot quickly and balance the need to get things right with the speed of getting them done right now.
• A Solution-Oriented Outlook: When things go wrong, you don't look for blame - you immediately focus on how to fix it.
• Transparent Communication: You value honesty, clarity, and open feedback.
• Team-First Energy: You want to win together as a high-performing team and actively build connections across our remote locations.

Requirements

We are looking for candidates with a collaborative approach, strong analytical skills, and a passion for leveraging data to drive business outcomes.Some specific experiences and skills include:

Must Haves:

• Experience analyzing P&C insurance data (e.g., 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 to collaborate with stakeholders across the organization
• Close attention to detail and the curiosity to trace complex data inconsistencies back to their source
• Comfort integrating AI tools in day-to-day workflows to drive efficiencies
• A self-starter who takes accountability, thrives in a fast-paced environment, and handles ambiguity well

Nice To Haves:

• Familiarity with integrating data with finance/ERP systems (e.g. Workday)
• Experience at an MGA or a carrier that partners with MGAs
• Exposure to Snowflake, Python, Power Query, and/or AI tools that streamline day-to-day workflows

Benefits

US & Canada Benefits:

• 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.
• Additional financial protection and retirement benefits, including a 401(k), company-paid life insurance, and disability coverage.

Compensation

Compensation:

• The base salary range for this position is $80,000-120,000.This is a good-faith compensation range based on what Ledgebrook reasonably expects to pay for this position at the time of this posting.Actual compensation may vary based on a variety of relevant factors including but not limited to experience, qualifications and geographic location.
• Employees in this position are eligible to participate in Ledgebrook's equity incentive program.

For Candidates Applying From the U.S and Canada:

Please note: This position is open only to candidates who are authorized to work in the U.S or Canada without the need for current or future employer-sponsored work authorization.We are unable to offer sponsorship at this time.

Ledgebrook may use Artificial Intelligence("AI") as part of the job application process, including to assist us in evaluating your application.AI is used as a support tool, and hiring decisions are made by human recruiters. By submitting your information, you acknowledge that the company may use AI tools as part of our evaluation. If you need a reasonable accommodation or alternative review process because of a disability or other legally protected basis, contact [e-mail]. Requesting an accommodation will not negatively affect your application.