Senior Workforce Data Analyst - MS Fabric

PMA Companies•Blue Bell, PA

About The Position

The Senior Workforce Data Analyst builds and strengthens the foundation of workforce analytics by developing and maintaining data models, tools, systems, and processes that improve how HR and workforce data is captured, structured, integrated, governed, and used. The role works with current and legacy HCM and other organizational data sources to create reliable, scalable datasets for reporting, dashboards, automation, and workforce analytics. The analyst partners with the Senior Workforce Analyst, HR & Payroll Systems team, IT, and other business partners to ensure workforce data is accurate, secure, well-structured, and available for analytical use. The role also identifies opportunities to streamline manual processes, improve data accessibility, and use Microsoft technologies—including Microsoft Fabric, Power BI, Power Automate, and SharePoint—to support efficient and sustainable reporting and analytics solutions.

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; Microsoft Power BI is preferred.
  • Experience with or working knowledge of Microsoft Fabric, Power Automate, SharePoint, Power Query, or other Microsoft data and automation tools.
  • Ability to develop scalable, repeatable data processes that reduce manual reporting and improve data accessibility and reliability.
  • 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 investigating data discrepancies, identifying root causes, and recommending solutions.
  • Ability to translate business and reporting requirements into effective data, reporting, automation, or process solutions.
  • Strong attention to detail and 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 and 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.

Nice To Haves

  • Experience supporting HR, payroll, workforce management, or other employee-related data is strongly preferred.
  • 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 development of governed datasets for enterprise analytics.

Responsibilities

  • Develop, maintain, and enhance workforce data structures, models, and processes supporting HR reporting, dashboards, analytics, and 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 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 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 reporting and analytics needs.
  • Support HCM implementations, integrations, conversions, historical data initiatives, and other projects requiring workforce data expertise.
  • Demonstrate commitment to the Company's Code of Business Conduct and Ethics and apply relevant compliance policies, procedures, standards, and laws in performing work.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service