Demo

Sr. Workforce Data Analyst

Old Republic Commercial Risk
Doylestown, PA Full Time
POSTED ON 9/9/2026
AVAILABLE BEFORE 10/13/2026
The Sr Workforce Data Analyst will play a critical role in building and strengthening the foundation of workforce analytics by developing and maintaining the data models, tools, systems, and processes necessary to improve how HR and workforce data is captured, structured, integrated, governed, and utilized.

This role will work across current and legacy HCM and other organizational data sources to create reliable and scalable datasets that support reporting, dashboards, automation, and workforce analytics. The analyst will partner closely with the Senior Workforce Analyst, HR & Payroll Systems team, IT, and other business partners to ensure workforce data is accurate, secure, well-structured, and readily available for analytical use.

As workforce analytics capabilities continue to expand, this position will help identify opportunities to streamline manual processes, improve data accessibility, and leverage Microsoft technologies including Microsoft Fabric, Power BI, Power Automate, SharePoint, and related tools to support more efficient and sustainable reporting and analytics solutions.

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

Requirements

  • Bachelor's degree in Data Analytics, Information Systems, Business, Human Resources, Computer Science, or a related field, or equivalent relevant experience.
  • Demonstrated experience working 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 Microsoft 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 the sensitivity of HR and payroll data, including appropriate data security, confidentiality, privacy, and role-based access practices.
  • Strong analytical and problem-solving skills, including the ability to investigate data discrepancies, identify root causes, and recommend solutions.
  • Ability to translate business and reporting requirements into effective data, reporting, automation, or process solutions.
  • Strong attention to detail with demonstrated ability to maintain accuracy when working with large or complex datasets.
  • Ability to document data definitions, mappings, transformations, business rules, and processes.
  • Strong communication and collaboration skills with the ability to work effectively across HR, Payroll, IT, Finance, and other business functions.
  • Ability to manage multiple priorities and adapt to evolving systems, technologies, reporting needs, and organizational requirements.

Preferred Qualifications

  • Experience with UKG Pro, ADP, or another enterprise HCM/payroll platform.
  • Experience with SQL, ETL/ELT processes, semantic models, dataflows, data warehouses, or lakehouse environments.
  • Experience supporting HCM implementations, data conversions, system integrations, or historical workforce data.
  • Experience combining HR data with Finance, Operations, or other enterprise data sources.
  • Familiarity with dimensional modeling and the development of governed datasets for enterprise analytics.

Salary.com Estimation for Sr. Workforce Data Analyst in Doylestown, PA
$96,439 to $119,491
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Sr. Workforce Data Analyst?

Sign up to receive alerts about other jobs on the Sr. Workforce Data Analyst career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$85,436 - $117,270
Income Estimation: 
$108,210 - $148,204
Income Estimation: 
$85,641 - $114,384
Income Estimation: 
$76,522 - $109,022
Employees: Get a Salary Increase
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Old Republic Commercial Risk

  • Old Republic Commercial Risk Greenville, SC
  • Job Description As a member of our claims team, utilize your knowledge of Workers Compensation to independently investigate, evaluate and resolve assigned ... more
  • 9 Days Ago

  • Old Republic Commercial Risk Jackson, MS
  • Job Description As a member of our claims team, utilize your knowledge of Workers Compensation to independently investigate, evaluate and resolve assigned ... more
  • 10 Days Ago

  • Old Republic Commercial Risk Trenton, NJ
  • As a member of our in-house counsel legal department, you will be primarily responsible for the litigation of insurance company and third party administrat... more
  • 10 Days Ago

  • Old Republic Commercial Risk Burlington, VT
  • As a member of our Claims management team supervise claims staff to ensure appropriate claim outcomes through consistent execution of best claims practice.... more
  • 11 Days Ago


Not the job you're looking for? Here are some other Sr. Workforce Data Analyst jobs in the Doylestown, PA area that may be a better fit.

  • Technology Talent Network LLC Princeton, NJ
  • Job Description 1. SQL / SSIS Depth Build and maintain ETL processes with SSIS (including Data Flow Tasks, Lookups, Merge Joins, Conditional Splits). Handl... more
  • 4 Days Ago

  • globalhr Warminster, PA
  • Date Posted: 2026-09-08 Country: United Kingdom Location: Warminster, Wiltshire Position Role Type: Hybrid Data Analyst Be at the forefront of transforming... more
  • 4 Days Ago

AI Assistant is available now!

Feel free to start your new journey!