PEO Business Analyst

Berkley • High Point, NC

1d • Onsite

About The Position

We are seeking a detail-oriented 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.

Requirements

• 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.
• Effective communicator with strong attention to detail and follow-through.

Nice To Haves

• Commercial insurance, PEO, or workers' compensation experience preferred.
• Experience with Power BI, SQL, and databricks preferred.
• 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.

Responsibilities

• 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.

Benefits

• Training is available for PEO and workers' compensation business.
• Pursuing continuing education in Data Analytics such as the PCPA or other AI and data certifications.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level