Workforce Analytics Architect - Data Modeling & BI

Old Republic Commercial Risk; Norristown (Montgomery County); On-site; USD 95,000 - 130,000; Full time

Job summary

Old Republic Commercial Risk seeks a Senior Workforce Data Analyst to develop robust data models, tools, and processes for HR analytics. You will work across HCM systems to build reliable datasets supporting reporting, dashboards, automation, and insightful workforce metrics.

You will partner with HR, IT, and Finance to ensure data accuracy, security, and accessibility, leveraging Microsoft Fabric, Power BI, SharePoint, and related technologies to deliver scalable analytics solutions.

Qualifications

• Bachelor's degree (or equivalent) in a related field and experience with HR/workforce datasets.
• Experience building data models, data structures, and analytics-ready datasets for reporting.
• Strong experience extracting, transforming, validating data from multiple systems.
• Knowledge of data governance, data quality, and data security principles.
• Proficiency with BI tools, preferably Power BI, and Microsoft data/automation tools.

Responsibilities

• Develop, maintain, and enhance workforce data structures, models, and processes for HR reporting and analytics.
• Transform data from HCM, payroll, workforce management, recruiting, and other sources into analytics-ready datasets.
• Build scalable data and automation solutions using Microsoft Fabric, Power BI, Power Automate, and SharePoint.
• Partner with stakeholders to support reporting, dashboard development, and expanded metrics.
• Translate requirements into data models, governed datasets, and automated processes.
• Perform data validation, reconciliation, and root-cause analysis for accuracy and consistency.
• Support data governance, including data definitions, mappings, lineage, access controls, and privacy considerations.
• Identify opportunities to automate reporting and improve data accessibility.
• Collaborate across HR, Payroll, IT, Finance to integrate new data sources.
• Support data initiatives, HCM implementations, and data migration projects.

Skills

Data analytics

Data modeling

Power BI

Microsoft Fabric

Power Automate

SharePoint

Power Query

SQL

ETL/ELT

Data governance

Education

Bachelor's degree in Data Analytics, Information Systems, Business, Human Resources, Computer Science, or a related field

Tools

Microsoft Fabric

Power BI

Power Automate

SharePoint

Power Query

SQL

ETL/ELT

Data warehouse

Job description

Old Republic Commercial Risk seeks a Senior Workforce Data Analyst to develop robust data models, tools, and processes for HR analytics. You will work across HCM systems to build reliable datasets supporting reporting, dashboards, automation, and insightful workforce metrics.

You will partner with HR, IT, and Finance to ensure data accuracy, security, and accessibility, leveraging Microsoft Fabric, Power BI, SharePoint, and related technologies to deliver scalable analytics solutions.