PEO Business Analyst

Key Risk (a Berkley Company); High Point (NC); Presencial; USD 60.000 - 75.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health benefits

401(k) and Profit Sharing

Descripción de la vacante

Key Risk (a Berkley Company) seeks a detail-oriented PEO Business Analyst to support underwriting and operations through data analysis, reconciliation, and reporting. The role handles large Excel datasets from vendors, insureds, and internal systems to ensure data accuracy and improve processes.

The ideal candidate has 3–5 years of experience, proficiency in Power BI, SQL, Databricks, and advanced Excel, and a background in commercial insurance, PEO, or workers' compensation is preferred.

Formación

• Min of 3-5 years of experience.
• Experience with Power BI, SQL, and databricks
• Advanced Excel skills, including Pivot Tables, Power Query, XLOOKUP, and data modeling.
• Experience reconciling large and complex datasets.
• Strong analytical, organizational, and problem-solving skills.
• Commercial insurance, PEO, or workers' compensation experience preferred.

Responsabilidades

• Reconcile large datasets between vendors, insureds, and internal systems, investigating and resolving variances.
• Analyze payroll, premium, claims, and operational data to ensure completeness and accuracy.
• Develop and maintain recurring and ad hoc reports using Excel, Power BI, and other reporting tools.
• Create dashboards and performance metrics for underwriting, operations, and executive leadership.
• Manage relationships with external vendors to ensure timely and accurate delivery of data.
• Partner with underwriting, actuarial, finance, and operations teams to improve data quality and reporting processes.
• Identify trends, anomalies, and work opportunities for process improvement through data analysis.
• Document reporting procedures and data validation controls.
• 5-10% travel to our vendors and home office throughout the year.
• Actively engage with mentors to learn the PEO and workers compensation business.
• Pursuing continuing education in Data Analytics such as the PCPA or other AI and data certifications.

Conocimientos

Analytical thinking

Data analysis

Vendor management

Attention to detail

Communication

Problem solving

Educación

Bachelor's degree in Data Science or related field

Herramientas

Power BI

SQL

Databricks

Descripción del empleo

Company Details

With over 35 years of proven expertise in the workers' compensation industry, Key Risk delivers innovative and responsive solutions that provide our clients the freedom to do what they do best. Offering guaranteed cost options to employers nationwide, Key Risk focuses on delivering products and services within specialized verticals to reduce workers' compensation exposures and deliver industry-leading results.

Company Details

With over 35 years of proven expertise in the workers' compensation industry, Key Risk delivers innovative and responsive solutions that provide our clients the freedom to do what they do best. Offering guaranteed cost options to employers nationwide, Key Risk focuses on delivering products and services within specialized verticals to reduce workers' compensation exposures and deliver industry-leading results.

All products and services are distributed through appointed insurance agents and brokers. Key Risk is a member company of W. R. Berkley Corporation, whose insurance company subsidiaries are rated A+ (Superior), Financial Size Category XV by A.M. Best Company and A+ (Strong), by S&P.

For further information about Key Risk please visit www.KeyRisk.com.

Responsibilities

We are seeking a detail-oriented PEO Business Analyst to support underwriting and operations through data analysis, reconciliation, and reporting. This role will work extensively with large Excel datasets from vendors, insureds, and internal systems to ensure data accuracy, identify discrepancies, and take a fresh perspective on revamping processes and reporting. Experience in commercial insurance, particularly PEO or workers' compensation is preferred but training is available.

Key Functions/Duties of Position: Describe the overall job responsibilities (including any decision-making authority) for this position.

• Reconcile large datasets between vendors, insureds, and internal systems, investigating and resolving variances.
• Analyze payroll, premium, claims, and operational data to ensure completeness and accuracy.
• Develop and maintain recurring and ad hoc reports using Excel, Power BI, and other reporting tools.
• Create dashboards and performance metrics for underwriting, operations, and executive leadership.
• Manage relationships with external vendors to ensure timely and accurate delivery of data.
• Partner with underwriting, actuarial, finance, and operations teams to improve data quality and reporting processes.
• Identify trends, anomalies, and work opportunities for process improvement through data analysis.
• Document reporting procedures and data validation controls.
• 5-10% travel to our vendors and home office throughout the year
• Actively engage with mentors to learn the PEO and workers compensation business
• Pursuing continuing education in Data Analytics such as the PCPA or other AI and data certifications.

Seeking candidates to work out of the High Point, NC; Lawrenceville, GA; Charlotte NC; Nashville, TN; Birmingham, AL or Meridian, MS office.

Qualifications

Education Requirement

• Bachelor's degree in Data Science, Data Analytics, or related field. A Business or Finance degree is acceptable with experience in the above data fields.

Qualifications: Include necessary skills/experience and core competencies required

• Min of 3-5 years of experience.
• Experience with Power BI, SQL, and databricks
• Advanced Excel skills, including Pivot Tables, Power Query, XLOOKUP, and data modeling.
• Experience reconciling large and complex datasets.
• Strong analytical, organizational, and problem- solving skills.
• Commercial insurance, PEO, or workers' compensation experience preferred.
• .

Success Factors

• Ability to manage large volumes of data with a high degree of accuracy.
• Strong vendor management and relationship-building skills.
• Ability to translate complex data into clear, actionable reporting.
• Effective communicator with strong attention to detail and follow-through.

Additional Company Details

We do not accept unsolicited resumes from third party recruiting agencies or firms.

The company offers a competitive compensation plan and robust benefits package for full-time regular employees which for this role include:

• Base Salary Range: $60,000-$75,000
• Eligible to participate in annual discretionary bonus.
• Benefits: Health, Dental, Vision, Life, Disability, Wellness, Paid Time Off, 401(k) and Profit-Sharing plans.

The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment.

Sponsorship Details

Sponsorship not Offered for this Role