Insurance Testing

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:
Masters 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.