PEO Data Analytics & Reporting Analyst

Berkley; High Point (NC); Sur place; USD 70 000 - 90 000; Plein temps

Résumé du poste

Key Risk, a member company of W. R. Berkley Corporation, seeks a detail-oriented Business Analyst in North Carolina to support underwriting and operations through data analysis, reconciliation, and reporting using large Excel datasets from vendors, insureds, and internal systems.

You will develop dashboards with Power BI and Excel, partner with underwriting, actuarial, finance and operations teams, and travel 5–10% to vendors and the home office while pursuing data analytics certifications.

Qualifications

• 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.
• Experience with Power BI, SQL, and databricks preferred.

Responsabilités

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

Connaissances

Advanced Excel

Pivot Tables

Power Query

XLOOKUP

Data modeling

Power BI

SQL

Databricks

Data reconciliation

Analytical skills

Formation

Bachelor's degree in data science

Business/Finance degree acceptable

Outils

Power BI

SQL

Databricks

Description du poste

Key Risk, a member company of W. R. Berkley Corporation, seeks a detail-oriented Business Analyst in North Carolina to support underwriting and operations through data analysis, reconciliation, and reporting using large Excel datasets from vendors, insureds, and internal systems.

You will develop dashboards with Power BI and Excel, partner with underwriting, actuarial, finance and operations teams, and travel 5–10% to vendors and the home office while pursuing data analytics certifications.