Rating Business Systems Analyst

JOB SUMMARY

The Rating Business Systems Analyst (BSA) serves as a subject-matter-focused liaison between business stakeholders and the development team, with a primary emphasis on insurance policy rating and underwriting rules. This role is responsible for analyzing rating requirements, underwriting manuals, and business rules to produce precise, testable system specifications that ensure accurate premium calculation and policy issuance. The Rating BSA works closely with underwriting, product, and engineering teams to translate complex rating logic into clear functional requirements. This position requires strong analytical skills, deep attention to detail, and advanced Excel capabilities, as well as prior experience working with insurance rating structures and underwriting guidelines.

ESSENTIAL DUTIES & RESPONSIBILITIES

Analyze insurance underwriting manuals, rating worksheets, and regulatory requirements to translate business rules into detailed system requirements Document rating logic, calculations, decision tables, and edge cases with a high degree of precision Create detailed requirement specifications, use cases, and acceptance criteria for rating and policy issuance functionality Partner with software developers to clarify rating logic and ensure correct interpretation of underwriting rules Support and facilitate User Acceptance Testing (UAT), with a strong focus on validating rating accuracy and calculation outcomes Use Excel extensively to analyze rating scenarios, validate calculations, reconcile discrepancies, and support troubleshooting Collaborate with QA and development teams to investigate, troubleshoot, and resolve rating-related defects and production issues Maintain comprehensive documentation for rating rules, system behavior, and changes over time

REQUIRED SKILLS & EXPERIENCE

Prior experience working with Property & Casualty insurance policy rating required Strong familiarity with insurance underwriting manuals and rating guidelines Advanced proficiency in Microsoft Excel, including complex formulas, lookup functions, large-dataset analysis, macros, and validation techniques Exceptional analytical and problem-solving skills with the ability to break down complex rating logic Extremely high attention to detail and accuracy Clear, concise oral and written communication skills, with the ability to explain complex logic to both technical and non-technical audiences Ability to work independently with minimal supervision and deliver high-quality work with incomplete or evolving requirements Experience working in a fast-paced, ambiguous, and rapidly changing environment Advanced Excel skills, including complex formulas, lookup functions, macros, pivot tables, and large‑dataset analysis.

PREFERRED SKILLS & EXPERIENCE

Experience supporting or implementing rating engines or policy administration systems Familiarity with regulatory-driven rating changes and compliance considerations Experience documenting decision tables, rating matrices, or complex business rules Experience writing SQL Server and/or Mongo queries Jira and Confluence (or equivalent software) experience Experience working in Agile or Kanban software development environments

EDUCATION & TRAINING

Associate degree or equivalent education required; Bachelor degree preferred 2+ years of experience in an IT, product, systems analysis, or technology-related role or equivalent experience working in a business domain with strong technical collaboration To foster Exzeo's commitment to creating a collaborative work environment, remote workers will be required to report to a central office location for one week every quarter for collaboration, team building, and educational exercises. Exzeo offers 100% employer-paid health, dental, vision, life, and disability insurance for employees, a flexible paid time off plan, a 401(k) match, and bonus potential.