Senior Workforce Data Architect

Old Republic Commercial Risk; Center Square (PA); On-site; USD 110,000 - 140,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 that strengthen HR analytics and workforce reporting. You will collaborate with HR, IT, and Finance to ensure accurate, secure, and scalable data foundations.

The role emphasizes Microsoft Fabric, Power BI, Power Automate, SharePoint, and data governance to improve reporting efficiency and analytics capabilities across the organization.

Qualifications

• Bachelor's degree in Data Analytics, Information Systems, Business, Human Resources, Computer Science, or related field.
• Experience with complex datasets and data structures for reporting/analytics.

Responsibilities

• Develop, maintain, and enhance workforce data structures, models, and processes supporting HR reporting, dashboards, analytics, and broader organizational metrics.
• Transform data from current and legacy HCM, payroll, workforce management, recruiting, compensation, and other sources into analytics-ready datasets.
• Build and support scalable data and automation solutions using Microsoft Fabric, Power BI, Power Automate, SharePoint, and related technologies.
• Partner with the Senior Workforce Analyst to support reporting, dashboard development, data visualization, and the expansion of workforce metrics and analytical capabilities.
• 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, complete, consistent, and appropriately represented over time.
• Support workforce data governance, including data definitions, mappings, lineage, documentation, access controls, privacy, security, and appropriate use of sensitive employee and payroll information.
• Identify opportunities to simplify, automate, and improve existing reporting, data-management, and business processes.
• Partner across HR, Payroll, Workforce Analytics, IT, Finance, and other business areas to integrate new data sources and support evolving organizational reporting and analytics needs.
• Support HCM implementations, integrations, conversions, historical data initiatives, and other projects requiring workforce data expertise.
• Demonstrate commitment to Company's Code of Business Conduct and Ethics, and apply knowledge of compliance policies and procedures, standards and laws applicable to job responsibilities in the performance of work.

Skills

Data modeling

ETL/ELT

SQL

Power BI

Data governance

Data validation

Analytical skills

Data integration

Microsoft Fabric

Power Automate

SharePoint

Cross-functional collaboration

Education

Data Analytics degree

Information Systems

Business

Human Resources

Computer Science

Tools

Microsoft Fabric

Power BI

Power Automate

SharePoint

Power Query

SQL

Job description

Old Republic Commercial Risk is seeking a Sr Workforce Data Analyst to develop and maintain data models, tools, and processes that strengthen HR analytics and workforce reporting. You will collaborate with HR, IT, and Finance to ensure accurate, secure, and scalable data foundations.

The role emphasizes Microsoft Fabric, Power BI, Power Automate, SharePoint, and data governance to improve reporting efficiency and analytics capabilities across the organization.