Senior Associate I - HR Data Analytics, Dashboarding & Automation

At A.F. Ferguson & Co, we strive to be the employer of choice for professional talent by fostering an inclusive culture that values diverse backgrounds and experiences. As a trusted business advisor, we operate in a dynamic environment full of opportunities for growth. We are seeking a Senior Associate I – HR Analytics to join our Human Capital Development team. This role is pivotal in designing and managing analytics frameworks, performance reporting, and delivering insights that support strategic talent decisions. The ideal candidate will demonstrate strong technical skills, sound judgment, and the ability to independently lead HR analytics projects in 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 requirements 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 calculations, data sources, and dashboard outputs before release, continuously enhancing 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, completeness, and reliability of HR reporting. Maintain comprehensive documentation covering data sources, transformations, business rules, KPI definitions, and reporting logic. Manage employee and workforce information 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 approved tools such as Power Automate, Power Query, Microsoft 365, and other HR technology platforms. Facilitate integration of HR systems and reporting platforms 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 human validation and governance.

Continuous Improvement & Stakeholder Partnership:
Collaborate with HR teams to understand business challenges, define reporting or automation needs, and translate them into scalable solutions. Map current 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.

Key Deliverables:
- HR executive and operational dashboards
- Standardized HR KPI and metric library
- Automated recurring reports and HR workflows
- Workforce and people analytics packs with actionable insights
- Data-quality, reconciliation, and exception reporting
- Process maps, data dictionaries, and solution documentation
- Automation pipeline and benefits tracking

Required Qualifications
Bachelor’s degree in Human Resources, Business Analytics, Data Analytics, Information Systems, Computer Science, or a related field. Practical experience in data analysis, dashboard development, business intelligence, or process automation is essential. Strong proficiency in Power BI, including Power Query, data modeling, DAX, and dashboard design, is required. Advanced Excel skills are necessary, and working knowledge of SQL or other data-querying tools is desirable. Experience with workflow automation tools such as Power Automate or equivalent platforms is also preferred.

This role offers a unique opportunity to leverage data and technology to drive impactful HR decisions and operational efficiencies within a leading professional services firm.