Job ID #31497: Workforce Analytics Analyst

Workforce Analytics Analyst – City of Hamilton Contribute to the City of Hamilton, one of Canada’s largest cities – home to a diverse and strong economy, an active and inclusive community, a robust cultural and dining scene, hundreds of kilometres of hiking trails and natural beauty just minutes from the downtown core, and so much more. Join our diverse team of talented and ambitious staff who embody our values of sensational service, courageous change, steadfast integrity, collective ownership and being engaged empowered employees. Help us achieve our vision of being the best place to raise a child and age successfully. #BeTheReason Union: Non‑Union Job Description ID #: 7854 Close date: Interested applicants please submit your application online at www.hamilton.ca/city-council/jobs-city by 4:00 p.m. on November 5, 2025. Duration: 24 months Internal applicants should apply with your work e‑mail address. External applicants are considered only after the internal posting process has been completed. Only applicants chosen for an interview will be contacted. Summary of Duties Reporting to the Manager, HR Technology and Analytics, the Workforce Analytics Analyst will provide innovative solutions to meet HR as well as the City’s operational and strategic needs. The Analyst is expected to work in the areas of workforce analytics, HR systems integration, HR workflow & process automation, and other communication & collaboration solutions. The candidate will work collaboratively with other members of the HR Technology and Analytics team, the broader HR team, IT, and other business units to discover and identify business requirements and expected outcomes that support the core and common HR objectives that are aligned with the City’s mission, values, and strategies. General Duties Design, develop, and maintain data, application, and integration solutions including modifications/enhancements to meet business needs. Identify opportunities where technologies, systems, and processes can improve business operations and help achieve organizational goals through business process re‑engineering and application and data integration. Review and analyze existing applications and solutions, and identify opportunities to modernize and consolidate where possible. Design and propose realistic solutions grounded in current resource availability, strategic priorities and existing culture. Design, develop, test, publish and maintain custom HR data queries, reports and dashboards using BI tools (e.g., MS Fabric, Power BI), MS Excel and PeopleSoft. Design, develop, and support solutions and interfaces using various Power Platform products (Power Apps, Power Automate), M365 components (SharePoint, Teams) and MS SQL tools. Leverage integration tools and technologies to develop and manage application interfaces and data mappings, ensuring data integrity and accuracy. Ensure compliance with municipal government data regulations and security requirements. Acquire and maintain knowledge of developments in the field, researching and developing business cases for new tools and best practices. Support HR’s client service goals by continuously improving HR Systems, metrics and reporting processes. Work collaboratively with stakeholders across HR, IT and other areas for HR technology and reporting initiatives. Participate in key HR projects, advising HR peers on data utilisation and business requirements. Assist with incident response, troubleshooting, root cause analysis and problem resolution. Accountable for high‑level data integrity, auditing and enforcing data validation processes. Conduct QA reviews and sign‑off on project design deliverables. Document and validate business requirements and develop standard operating procedures, knowledge articles, technical standards and governance policies. Promote best practices in security, privacy and data management. Develop and maintain a data governance framework, data dictionaries and master data. Enable cross‑learning within the HR Technology and Analytics team, train users and stakeholders. Partner with stakeholders to resolve issues related to engagement, adoption and continuous improvement. Manage stakeholder expectations and implement change management strategies for new HR analytics solutions. Qualifications University degree in a quantitative discipline (statistics), computer/data science, IT, business administration, HR or related field, or equivalent education and relevant experience. 5+ years in a related analytical and solution development role, demonstrating integration solutions using various cloud or on‑premises infrastructures. 5+ years in architecture, data management, applications system design and integration. Sound knowledge of metrics, data management, business intelligence strategies and data governance. Proven experience building and leading advanced analytics practices and understanding of analytics product lifecycle. Proficiency with Microsoft BI stack (MS Fabric, Power BI) and statistical methods with R/Python a plus. Advanced SQL knowledge, experience with SQL Server, SSIS and Microsoft Dataverse. Experience with integration technologies (SOAP, REST, JSON, XML). Experience with Microsoft 365, Power Platform (Power Apps, Power Automate). Ability to lead root cause analysis, incident resolution and performance tuning. Expertise in solution design, vendor management and enterprise application support. Strong process orientation, analytical and problem‑solving skills, and communication skills. Knowledge of HR functions, HRIS (PeopleSoft/Oracle Cloud), report development and data manipulation. Knowledge of municipal legislation (MFIPPA, OHSA, AODA). Continuous learning mindset, ability to manage multiple priorities. Excellent written and verbal communication, ability to present complex ideas clearly. Work Conditions Hybrid (remote/home & workplace) telecommuting model. Requires ability to sit/stand for prolonged periods using video technologies. Disclaimer Be advised that Human Resources frequently audits resumes of internal/external applicants to ensure/validate information provided is consistent and trustworthy. Falsification of information may result in disqualification and discipline. Terms The City is an equal opportunity employer committed to inclusive, barrier‑free recruitment. We provide accommodation for all applicants without discrimination. If you have an accommodation need, please contact Human Resources to arrange it. Seniority Level Mid‑Senior level Employment Type Full‑time Job Function Business Development and Sales Industries Government Administration #J-18808-Ljbffr