Senior Associate I - HR Data Analytics, Dashboarding & Automation

At A.F. Ferguson & Co, we are committed to being the employer of choice for professional talent. As a trusted business advisor operating in a dynamic environment, we offer exciting opportunities for individuals from diverse backgrounds. We strive to attract top talent from a broad pool and foster a culture where employees can be authentic and valued for their unique strengths. Within PwC’s Human Capital Development function, the Senior Associate I – HR Analytics plays a crucial role in designing and managing analytics frameworks, performance reporting, and delivering insights that support strategic talent decisions. This position demands strong technical expertise, sound judgment, and the ability to independently lead HR analytics projects in close collaboration with HR leadership and business stakeholders.

Key Responsibilities

People Analytics & Workforce Insights:
Analyze workforce data throughout the employee lifecycle, including headcount, hiring, onboarding, performance, skills, workforce movement, and attrition. Develop descriptive and diagnostic analyses, and where applicable, support predictive workforce insights. Identify trends, exceptions, and root causes, translating findings into clear, actionable insights for HR and leadership. Create relevant metrics, trend analyses, and scenario-based reports.

Dashboarding & Business Intelligence:
Design, build, and maintain interactive Power BI dashboards and executive reports aligned with HR KPIs and strategic priorities. Translate business needs into clear KPIs, visualizations, drill-downs, and reporting views. Develop robust data models using Power Query and dimensional modeling techniques. Establish reusable reporting solutions to replace manual processes and enable timely data refreshes. Validate data accuracy and continuously enhance dashboard usability and relevance.

HR Data Management & Governance:
Consolidate, cleanse, transform, and reconcile HR data from approved systems and authorized sources. Implement data-quality checks, definitions, and validation controls to ensure consistency and reliability of HR reporting. Maintain comprehensive documentation for data sources, transformations, business rules, KPI definitions, and reporting logic. Manage employee data in compliance with confidentiality, privacy, access control, and governance standards. Support the development of a consistent HR data and KPI framework to establish a reliable source of truth.

HR Automation & Digital Solutions:
Identify repetitive, manual, and high-volume HR tasks suitable for automation or digitization. Design and implement workflow and reporting automations using tools such as Power Automate, Power Query, Microsoft 365, and other HR technology platforms. Facilitate integration of HR systems and reporting tools to minimize duplicate data entry and manual reconciliation. Develop controlled, auditable solutions with appropriate approvals, exception handling, monitoring, and documentation. Explore AI-enabled HR use cases with built-in human validation and governance.

Continuous Improvement & Stakeholder Partnership:
Collaborate with HR teams to understand business challenges, define reporting or automation requirements, and deliver scalable solutions. Map existing processes, identify bottlenecks, and recommend data-driven or technology-enabled improvements. Support user adoption through clear documentation, demonstrations, and knowledge transfer. Monitor the effectiveness of dashboards and automations by tracking data accuracy, reporting turnaround time, reduction in manual effort, and user adoption.

Required Qualifications

Bachelor’s degree in Human Resources, Business Analytics, Data Analytics, Information Systems, Computer Science, or a related field. Proven experience in data analysis, dashboard development, business intelligence, or process automation; prior exposure to HR or people analytics is preferred. Strong proficiency in Power BI, including Power Query, data modeling, DAX, and dashboard design. Advanced skills in Excel and familiarity with SQL or other data querying tools are desirable. Experience with workflow automation platforms such as Power Automate or equivalent is advantageous.

This role offers the opportunity to contribute to a forward-thinking HR analytics function, driving data-informed decisions and operational efficiencies that enhance workforce management and employee experience.