Senior Data Quality Analyst

LimeIQ; Plano (TX); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Collaborative team environment

Opportunities for career advancement

Culture of respect and transparency

Job summary

A leading FinTech/InsurTech platform in Plano, TX, seeks a Senior Data Quality Analyst to ensure the accuracy and integrity of insurance data. Ideal candidates will have experience with Lloyd’s of London data and a solid background in data validation and quality assurance. This hands-on role requires strong analytical skills and advanced SQL proficiency, and involves collaborating with cross-functional teams to improve data governance. Join a dynamic environment focused on excellence and accountability.

Qualifications

• 3+ years of experience in QA, data quality, or validation roles.
• Demonstrated experience with insurance, reinsurance, or Lloyd’s data environments preferred.
• Experience working in Agile/Scrum environments.

Responsibilities

• Design, document, and execute test plans for insurance data platforms.
• Validate claims and premium bordereaux ingestion, transformation, and reconciliation processes.
• Identify, document, and track software defects and validation failures.

Skills

Experience with Lloyd’s of London data

Advanced SQL skills

Strong analytical skills

Meticulous documentation

Education

Bachelor’s degree in Computer Science, Information Systems, Finance, or related field

Tools

Postman

SQL Server

JIRA

Confluence

Python

PowerShell

Job description

LimeIQ is a specialized FinTech/InsurTech platform serving the global specialty insurance and reinsurance market, with deep alignment to the Lloyd’s of London ecosystem. We transform how managing agents, brokers, underwriters, and delegated authorities ingest, validate, reconcile, and analyze bordereaux and claims data.

At the core of our platform is LincolnSmart™, our proprietary ingestion and transformation engine that processes large-scale claims and premium bordereaux (BDX) files with precision and consistency. LimeIQ eliminates manual reconciliation, enforces validation rules aligned to market standards, and standardizes fragmented data into structured, auditable datasets.

Through our four pillars—Ingestion, Validation, Aggregation, and Intelligence—we enable:

• Real-time visibility into Lloyd’s portfolio and claims data
• Automated validation, FCP reconciliation, and exception management
• Accurate reserve, incurred, and catastrophe reporting
• Reliable KPI and performance analytics for underwriting and finance teams

Our mission is to build the leading insurance data intelligence platform for the specialty market by enforcing data integrity, operational discipline, and technical excellence.

Position Summary

We are seeking a Senior Data Quality Analyst with strong experience in insurance data, Lloyd’s bordereaux, and financial validation to join LimeIQ’s Product & Engineering team.

This role is responsible for ensuring the accuracy, completeness, and regulatory integrity of claims and premium data flowing through our platform. You will validate complex transformation logic, reconcile bordereaux outputs, and verify that system behavior aligns with Lloyd’s market requirements and client reporting standards.

This is a hands‑on, detail‑oriented role suited for professionals who understand that data quality in insurance is not optional—it is foundational to underwriting, reserving, and compliance.

You will work closely with product managers, software engineers, and data engineers to prevent defects, surface inconsistencies early, and continuously improve data governance and validation frameworks.

This position is based in LimeIQ’s Plano, TX Headquarters.

Key Responsibilities

• Design, document, and execute test plans for insurance data platforms and web applications
• Validate claims and premium bordereaux (BDX) ingestion, transformation, and reconciliation processes
• Perform detailed data validation against Lloyd’s reporting standards and client specifications
• Verify financial calculations including reserves, paid, incurred, outstanding, and adjustments
• Reconcile source bordereaux files against transformed and aggregated outputs
• Identify, document, and track software defects, data anomalies, and validation failures
• Develop automated validation checks and anomaly detection using SQL, Python, or similar tools
• Partner with engineering teams to validate business rules and release outcomes
• Support regression, integration, and UAT testing for production deployments
• Establish repeatable QA templates and control frameworks for bordereaux processing
• Participate in Agile ceremonies and quality gate reviews
• Help define and enforce enterprise-wide data quality standards

Key Skills & Expertise

Insurance & Lloyd’s Domain

• Experience working with Lloyd’s of London data, managing agents, or delegated authority reporting
• Strong understanding of claims and premium bordereaux structures
• Familiarity with FCP, market reporting, and compliance‑driven data workflows

Data Validation & Analysis

• Advanced ability to reconcile large datasets and identify inconsistencies
• Strong analytical skills for detecting trends, outliers, and systemic errors
• Proven experience validating financial and actuarial‑related data

Technical & Testing Skills

• Web application and API testing experience
• Strong SQL skills for data interrogation and reconciliation
• Experience with Postman, SQL Server, JIRA, and Confluence
• Working knowledge of Python, PowerShell, or similar scripting tools
• Familiarity with test automation frameworks and validation pipelines

Professional Skills

• Meticulous documentation and audit‑ready testing practices
• Ability to challenge assumptions and question questionable data
• Strong communication with technical and business stakeholders
• Comfortable working under regulatory and delivery pressure

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Finance, or related field
• 3+ years of experience in QA, data quality, or validation roles
• Demonstrated experience with insurance, reinsurance, or Lloyd’s data environments preferred
• Advanced SQL proficiency
• Experience working in Agile/Scrum environments
• Exposure to regulated financial or insurance systems strongly preferred

What We Offer

• A fast‑paced environment with high visibility and impact
• A collaborative team with a shared focus on excellence and accountability
• Opportunities to lead IT operations at a growing technology firm
• A culture rooted in respect, transparency, and ownership