Job Description
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.
