Senior QA Engineer

Job Title: Consultant – Insurance Rating Validation (Actuarial & QA)

Overview

We are seeking a Consulting Professional specializing in Insurance Rating Validation to support actuarial and business teams in ensuring accuracy, transparency, and efficiency of premium calculations. This role goes beyond traditional QA by combining domain consulting, actuarial interpretation, and validation of rating logic across policy administration systems.

The ideal candidate will act as a bridge between actuarial, business, and technology teams, bringing expertise in rating methodologies, product configuration, and data-driven validation approaches, with strong proficiency in Excel-based analytical tooling and automation (VBA/macros).

Preferred Qualifications

Master’s degree in Insurance, Actuarial Science, Mathematics, or related field

Actuarial exam progress or certification (preferred)

Experience working closely with actuarial or product teams on rate filings or pricing models

Must-Have Responsibilities

Strong understanding of insurance pricing fundamentals (rate making, loss ratios, underwriting factors, rating variables)

Expertise in insurance rating validation and end-to-end premium calculation across rating engines/PAS

Ability to interpret actuarial models, rate filings, and translate them into testable logic

Advanced proficiency in Excel (VBA/macros, complex formulas, large dataset validation)

Strong analytical and data reconciliation skills (expected vs actual premium comparison, variance analysis)

Experience in designing test scenarios for complex rating structures (multi-factor, tier-based, edge cases)

Ability to collaborate with actuarial, underwriting, and product teams to validate business intent

Strong understanding of QA lifecycle, defect management, and business impact-based prioritization

Experience working with Policy Administration Systems / Rating Engines (e.g., EIS, Guidewire, Duck Creek)

Strong problem-solving skills to identify root causes of pricing discrepancies

Execute manual test cases to validate the functionality and accuracy of insurance rating engines and user interfaces.