Support Analyst, Human Resources

**Our Story**:
Committed to fostering opportunities for current and future generations, the Region of Waterloo is an inclusive, thriving and sustainable region of connected rural and urban communities with global reach. Our mission is to serve, engage and inspire, by delivering quality services to a diverse population of 630,000+, while creating a healthy, collaborative environment of learning, respect and innovation.

This is a place where employees are valued and recognized for their talents and contributions to our success. Our employees take pride in making a difference in people's lives through the work that we do. We are looking for people like you to help make it happen.

**Our Team**:
Our HRC-Systems team supports the Region’s Human Resources & Citizen Service systems infrastructure, providing exceptional technical assistance to empower our users in leveraging technology effectively and efficiently.

We are embarking on a Digital Transformation process and assisting in the implementation of a shared SAP HXM (cloud-based) platform and upgrading our CRM/KM-Customer Relationship and Knowledge Management (Verint EMP/KMPro) to the cloud among other exciting projects. Come join our dynamic team where you matter, and your idea and contributions make a difference.

**The Opportunity**:
You will administer day-to-day systems, maintain user accounts, and assist with information privacy and confidentiality matters. You will assist with HR-related ITS service requests.

You will support system upgrades, identify operational impacts, exchange information with vendors and corporate ITS staff, and prepare summaries and consults with Analysts for determining implementation.

Working in consultation with the team, you will compile information on complex issues with systems and technologies to support problem solving and issue resolution.

You will work closely with Analysts to receive direction for non-standard work assignments, for consultation and support regarding complex issues, and for approval of updates to user resources/guides.

You will develop database queries and ad hoc personnel data reports for client departments.

In collaboration with your team, you will develop, maintain, and validate database views and objects to increase report and query performance, following basic best practices. You will use software tools to analyze SQL statement structure.

Using your knowledge and experience you will create reporting standards and templates and organize reports to avoid duplication to ensure data consistency. You will maintain security settings, report access and report indexes.

You will modify existing standard reports per request specifications, implement reporting solutions using Crystal Reports, Business Objects (Crystal Reports Enterprise Server), Power BI, and Microsoft Reporting Services Visual Studio.

You will use documentation tools to track issues and resolutions. You will assist and advise users on report configurations and assist with data analysis.

You will design and analyses quality assurance reports to develop data quality standards.

Under supervisor’s guidance, you will conduct and participate in joint projects with ITS, as required.

Performs related duties as required.

Working knowledge of supporting human resources systems and customer relationship management systems.

Knowledge of and ability to comply with policies, procedures, and collective agreements.

Proficiency using reporting and business intelligence technologies (e.g., Power BI, Crystal Reports, Microsoft Visual Studio Reporting Services).

Skill in developing queries on relational databases, specifically ORACLE, My SQL or MS-SQL using developer tools (e.g., SQL *Plus and PL/SQL) to create reports.

Analytical, time management, organizational, continuous improvement, and problem-solving skills to identify trends and develop recommendations; coordinate projects; adapt to changing priorities and balance requests; and work with others to develop realistic, innovative solutions.

Communication, interpersonal, and presentation skills to obtain technical assistance and information from vendors and corporate ITS; respond to client/user requests and communicate technical issues in non-technical terms to obtain and explain information; provide user training, as needed; and participate as an effective team member.

Ability to read publications and trade journals, software documentation and hardware manuals, system design and development language documentation, correspondence, technical specifications, programming language, and reports.

Ability to write and create training and instructional resources, user manuals and e-tutorials, procedures, reports/summaries, flowcharts, graphs, and correspondence.

Ability to travel within Waterloo Region.

Ability to support and demonstrate the Region’s values.

**Additional Information**:
We thank all applicants in advance; however, we will be corresponding only with those selected for an