This role focuses on developing and validating regulatory data submission files for P&C insurance, including mapping, test case design, data balancing, and bureau testing. You’ll troubleshoot data issues, support project planning, and participate in or lead meetings. The position requires strong workers’ compensation reporting experience, SQL skills, and the ability to work in a fast-paced, deadline-driven environment while delivering accurate, compliant data solutions.
What We’ll Bring to the Table:
- Friendly, dynamic work environment – Includes certification as a Great Place to Work® (five years in a row!) along with Climate Neutral Status
- Competitive salary plus uncapped commission on new and renewal sales
- Flexible Work Program
- Clear opportunities for career progression
- Company-funded professional educational program
- Visible management commitment to our company core values of: Diversity & Inclusion, Environmental, Community and Employee Wellbeing, Excellent Work Product, Innovation, Integrity and Superior Customer Experience
- Generous benefits including medical, dental, and vision insurance, company-paid life insurance, 401K with matching Company contributions, PTO, community support program including VTO and donations with Company match, employee recognition program
What You’ll Be Doing:
- Developing mapping documentation for bureau specified compliance submission files to be utilized by programming.
- Developing test case scenarios to be input into client systems to prove out the mapping documentation.
- Developing balancing documentation/routines to further verify the validity of the data feeds being produced.
- Testing feeds with the applicable bureaus and tracking issues as they arise.
- Troubleshooting issues that arise during development or bureau testing and coming up with solutions to address the issues.
- Reviewing project plans and assisting in development of project scope, schedule, and resources.
- Attending, and possibly leading, client meetings as necessary and appropriate.
- Directing clients and coordinating introductions to other practice areas, as appropriate.
What You’ll Bring to the Table:
- Bachelor’s degree
- Minimum of 8 years’ experience in P&C insurance
- Minimum of 5 years’ experience in business analyst, product management or product development
- Ability to work in a deadline driven, agile environment
- Exceptional communication and reporting skills
- Be expert in working with Microsoft Office (Word, Excel, PowerPoint and Teams)
- WCPOLS and WCSTAT experience (required)
- Experience building SQL queries to mine data
- Knowledge of, and familiarity with, insurance products, insurance software applications (policy, billing and claims), insurance operations, and industry standards (e.g., standards promoted by NAIC, ISO, AAIS, NCCI, etc.); Guidewire experience is a plus.
Salary: $90,000 – $110,000 a year
About Us:
For over 30 years, we have provided exemplary insurance consulting and software solutions to the property & casualty and life, accident & health industries. Services include actuarial consulting, risk strategies & solutions, applied AI consulting, product development, insurance policy and forms consulting, regulatory compliance, compliance and operational assessments/training, state filings, licensing, technology consulting, statistical reporting, data services, predictive analytics, and bureau monitoring & maintenance. Software includes StateFilings.com, the leading cloud-based state filings management solution. With offices nationwide and more than 150 insurance professionals, including 30+ credentialed actuaries, we are among the largest independent actuarial and insurance consulting firms in the United States.
Our mission as an actuarial and insurance operations consulting firm is to provide extraordinary value to our clients by offering innovative and unique solutions to complex challenges they face while providing a positive and motivating work environment for our employees that respects diversity and recognizes ingenuity and hard work.
We are an equal opportunity employer and committed to inclusion and diversity. We does not discriminate in employment on account of race, color, religion, national origin, citizenship status, ancestry, age, sex/gender, sexual orientation, gender identity, marital status, physical or mental disability, Veteran status, or other legally protected characteristics. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.
We will also provide reasonable accommodation to qualified individuals with disabilities, in accordance with applicable laws. If you need to inquire about an accommodation, or need assistance with completing the application process, please email [email protected]
