Senior Workforce Analytics Engineer

Old Republic Commercial Risk; West Chester (Chester County); On-site; USD 90,000 - 125,000; Full time

Job summary

Old Republic Commercial Risk is seeking a Sr Workforce Data Analyst to develop and maintain data models, tools, and processes for HR analytics, leveraging Microsoft Fabric, Power BI, and related technologies. You will work with HR, IT, and finance stakeholders to ensure data accuracy, governance, and scalable analytics solutions.

Responsibilities include transforming data from HCM and payroll systems into analytics-ready datasets, supporting dashboards, and enabling automated reporting across

Qualifications

• Bachelor's degree in Data Analytics, Information Systems, Business, Human Resources, Computer Science, or related field, or equivalent relevant experience.
• Experience with complex datasets and developing data structures, models, or processes to support reporting and analytics.
• Experience extracting, transforming, integrating, and validating data from multiple systems or data sources.
• Strong understanding of data modeling, data relationships, data quality, data governance, and data integrity principles.
• Experience with business intelligence and data visualization tools, preferably Power BI.
• Experience with or working knowledge of Microsoft Fabric, Power Automate, SharePoint, Power Query, or other Microsoft data and automation tools.
• Ability to develop scalable and repeatable data processes that reduce manual reporting and improve data accessibility and reliability.
• Experience supporting HR, payroll, workforce management, or other employee-related data is strongly preferred.
• Understanding of data security, privacy, and role-based access practices.

Responsibilities

• Develop, maintain, and enhance workforce data structures, models, and processes supporting HR reporting, dashboards, analytics, and broader organizational metrics.
• Manage and transform data from current and legacy HCM, payroll, workforce management, recruiting, compensation, and other organizational sources into reliable, analytics-ready datasets.
• Build and support scalable data and automation solutions using tools such as Microsoft Fabric, Power BI, Power Automate, SharePoint, and related technologies.
• Partner with the Senior Workforce Analyst to support reporting, dashboard development, data visualization, and expansion of workforce metrics.
• Translate business and reporting requirements into appropriate data models, governed datasets, repeatable processes, and automated solutions.
• Perform data validation, reconciliation, and root-cause analysis to ensure workforce data is accurate and consistent over time.
• Support workforce data governance, including data definitions, mappings, lineage, documentation, access controls, privacy, and security.
• Identify opportunities to simplify, automate, and improve existing reporting and data-management processes.
• Partner across HR, Payroll, IT, Finance, and other business areas to integrate new data sources and support evolving reporting needs.
• Support HCM implementations, integrations, conversions, historical data initiatives, and other projects requiring workforce data expertise.
• Demonstrate commitment to Code of Business Conduct and Ethics and apply compliance policies as required.

Skills

Data modeling

Data governance

Data quality

Power BI

Microsoft Fabric

Power Automate

SharePoint

SQL

ETL/ELT

Data visualization

Education

Bachelor's degree in Data Analytics or related field

Equivalent relevant experience

Tools

Microsoft Fabric

Power BI

Power Automate

SharePoint

Power Query

SQL

ETL/ELT

Data warehouses

Lakehouse environments

Job description

Old Republic Commercial Risk is seeking a Sr Workforce Data Analyst to develop and maintain data models, tools, and processes for HR analytics, leveraging Microsoft Fabric, Power BI, and related technologies. You will work with HR, IT, and finance stakeholders to ensure data accuracy, governance, and scalable analytics solutions.

Responsibilities include transforming data from HCM and payroll systems into analytics-ready datasets, supporting dashboards, and enabling automated reporting across