Workforce Analyst - Jobs in Edmonton, AB

Job Description

Workforce Analyst up to 14 monthsJob Number : 45048Do you enjoy providing analytics to shape and inform decision making across the organizationAre you a critical thinker with a passion for continuous learning and contributing to a high-functioning teamThe City of Edmonton is looking for a dynamic, people-focused Workforce Analyst to join our amazing team!The City of Edmonton is undertaking a major corporate shift in the way we operate and integrate the corporate processes and technology required to perform our core business functions in a standardized way. The Workforce Analyst role will have the opportunity to be a part of this exciting transformation and provide expertise in supporting the groundwork for higher-level analysis and move beyond workforce data collection, management, verification and reporting for evidence-based decision making. You will also have an amazing opportunity to support our Workforce Analytics journey as we embark on implementing a new Enterprise Resource Planning (ERP) solution.The Workforce Analyst will work collaboratively alongside business, other analysts and different stakeholders to identify key business problem requirements and expected analytical outcomes. With a focus on the City of Edmonton’s Cultural Commitments to Safe, Helpful, Accountable, Integrated and Excellent, you will:

• Aid in the building of the foundation for state-of-the-art scientific and technical reporting capabilities within the Workforce Analytics team to support several planned and ongoing workforce data analytics projects
• Offer your expertise in ETL design, development and support (ex. SSIS package development or custom ETL solutions)
• Extract data from Human Resources Information Systems (HRIS) (i.e. Oracle Peoplesoft, MS SQL) by writing complex SQL queries or through Workforce Business Intelligence reporting packages
• Offer advanced skills in SQL scripting
• Adhere to overall BI/DW architecture standards and principles
• Improve data quality with SQL Server integration services
• Manage workforce data and conduct audits to ensure data quality and data integrity
• Develop queries and methodologies related to workforce data management to populate data into a defined reporting template. This includes managing ongoing processes for completing these reports, including report execution and distribution, production of quality workforce insight reports, creation of dashboards, development and reporting on key performance measures and completion of benchmarking surveys
• Provide workforce data expertise, client consultation and recommendations to support all levels of corporate clients in addressing their workforce data and analytics needs
• Review and identify deficiencies in existing workforce reports to ensure the accuracy and completeness of reporting data

Qualifications :

• University Degree in Computer Science, Information Management, Business Administration or related field
• 4 years of diversified and progressive experience in the area of information analysis, including research and preparation of and understanding how analytics drives evidence based decision making
• Advanced skills in SQL and SSIS are required, including the use of functions, graphs and connecting to external data sources, and strong query writing abilities
• Experienced with statistical programmings such as R and data visualization tools such as Tableau, Looker Data Studio or Microsoft Power BI, and data cleansing tools and techniques
• Experienced with Peoplesoft, SuccessFactors and HR Reporting application (or similar HRIS system)
• Experienced in assembling and analyzing data from multiple operational systems (SuccessFactors, PeopleSoft, SAP, etc.) to establish data history, analyze trends, generate reports and forecasts, and support general ad hoc queries
• Ability to establish strong collaborative working relationships with clients and co-workers
• Knowledge of HR business processes is an asset
• Familiarity with HR metrics and terminology is an asset
• Demonstrate alignment with the Cultural Commitments of Safe, Helpful, Accountable, Integrated and Excellent, fostering an environment for others to do the same. For more information on the City’s Cultural Commitments, please visit edmonton.ca/our-culture
• Demonstrate the foundational competencies, key behaviours and attributes of the City’s six leadership competencies: Courage, Inclusivity, Values-Based Influencer, Collaborative Networker, Systems Thinker and Creative Innovator. For more information on the City’s leadership competencies, please visit edmonton.ca/our-culture
• Applicants may be tested

The City of Edmonton is committed to inclusive, respectful and equitable workplaces that represent the communities we serve. We continuously improve our systems, policies and practices to remove barriers and ensure our employees, in all their diversity, can succeed. We value applicants with a diverse range of skills, experiences and competencies, and encourage you to apply. To learn more, see the Art of Inclusion: Our Diversity and Inclusion Framework here: https://bit.ly/3hd2d95The City of Edmonton strives to provide reasonable access and accommodations throughout the application and selection process. If you would like to request an accommodation at any stage of the process, please contact Employment@edmonton.caUp to 1 temporary full-time position for up to 14 months in durationHours of Work: 40.00 hours per weekSalary: $43.325- $54.743 (Hourly); 90,462.60 - $114,303.380 (Annually)Talent Acquisition Consultant: IS/MZClassification Title : Methods Analyst IIPosting Date : Nov 9, 2022Closing Date : Nov 23, 2022 11:59:00 PM (MST)Number of Openings (up to) : 1 - Temporary Full-timeUnion : Out of ScopeDepartment : Talent Acquisition, Service and SolutionsWork Location(s) :Century Place, 10th Floor, 9803 - 102A Avenue Edmonton T5J 3A3Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job
• SimplyHired OnDemand

Stay Connected