July 21, 2021
August 4, 2021
Ensures the accuracy and integrity of work management data, through the implementation and execution of data focused process improvements; develops and implements data quality improvements and data standards throughout the business process and related systems; analyzes requests and supports issue resolution for data-related business process and application defects found in the work management software solutions.
Data Accuracy and Integrity:
Creates data test and analysis plans that define the testing strategy for ensuring the integrity of expected data outcomes, types of statistical tests to be performed, resources required, project scope, and risks for the project, based on business and technical requirements for both the collection and dissemination and use of data.
Develops the overall test and analysis effort within projects and functionally across all work management solutions, by prioritizing and performing data-related testing activities in consultation with the assigned Systems Administrator and/or the Manager, Business Solutions – Work Management.
Analyzes the business and technical requirements and documentation created by the Systems Administrator for design completeness as it relates to the data architecture, usability and consistency from a data quality perspective. Recommends changes as may be appropriate.
In consultation with the Systems Administrator develops and/or confirms required test and analysis cases to ensure expected data reliability, which are a set of inputs, conditions, and expected results. Verifies and ensures results are consistent with specified data quality requirements and identifies areas for improvement as required.
Assists in the development of implementation and back out strategies for projects and issue resolution.
Educates team members and user groups on data quality fundamentals and methodologies to work toward ensuring the highest quality data accuracy and integrity possible in data related process improvements and issue resolutions.
Investigates issues to determine root cause of data defects (e.g., under what process the data becomes invalid), recommends improvements to mitigate risk to data accuracy and integrity.
Enters defects in tracking system for assignment and documentation purposes.
Creates and updates reference documentation to track procedures and results of test and analysis plans.
Performs data statistical tests on large datasets to determine data quality and integrity through collaboration with business system owners, database administrators and others as needed. Analyze resulting data and identifies discrepancies in data between the work management systems and other systems such as SAP, PeopleSoft and prepares communication to users for resolution and/or escalation to the Manager, Business Solutions – Work Management.
Provides technical expertise and support to users regarding data accuracy and integrity, data analysis and issues.
Work Management Application Support:
Participates in new product builds from external developers and provides an assessment to support data quality standards.
Analyzes business process and related functionality of work management applications to identify areas for improvement or risk from a data accuracy and integrity perspective.
Evaluates data accuracy and integrity issue scope and number of impacted stakeholders for communication and prioritization purposes.
Extracts data by developing queries based on user requests or system logs for data analysis. Identifies the need and supports the development of self-serve data accuracy and integrity reports.
Through initial triage, provides data-related application support for user issues and requests and escalates to the System Administrator for resolution where functional or development support is required.
Identifies, develops, and facilitates data-related user training focusing on the importance of quality data management
3-year degree or diploma in a related field.
2-4 years of related experience.
Knowledge of data accuracy, quality and integrity strategies and methodologies in order to lead the data reliability effort for work management solutions within a project.
Knowledge of business process improvement and related application functionality in order to establish testing approaches to ensure data reliability; determine required data integrity test methods; identify areas where issues might arise; and evaluate and prioritize defects based on severity, impact and probability.
Analytical skills are required to analyze business designs and technical specifications in order to identify gaps, risks and inconsistencies in business process and the data architecture of the work management solution.
Excellent communication and human relation skills are required to work with users; internal partners; and the Work Management team on technical and non-technical levels.
Research skills are required to investigate new data quality methodologies.
Skill in time management to keep the projects on schedule.
Skill in the use of a personal computer with the ability to use software programs such as Microsoft Office, issue tracking software, SAP, and data query and analysis tools.
Ability to communicate technical information in clear, concise and understandable language to both technical and non-technical staff.
Ability to create data quality testing plans and to document business process and technical information for business process improvements, defects and application enhancements.
Ability to understand the complexity and interconnectedness of various data elements across and within work management solutions.
Should a suitable candidate not be identified with the minimum education and experience requirements, consideration will be given to candidates with the following pre-determined equivalencies:
2-Year Diploma (or 2-Year Specialized Post-Secondary Program) with minimum 4 years’ related and relevant experience
4-Year Honours Degree with minimum 1 year related and relevant experience
We are committed to diversity and inclusion, and thank all applicants in advance.
Accommodations are available during all stages of the recruitment process in accordance with the Human Rights Code.
We thank all applicants for their interest, however only candidates selected for further consideration will be contacted
Please note that as per Human Resources Policy HUM-HIR-110, "Employment of Relatives of Staff Members and Elected Officials":
"The immediate relatives of staff of the Human Resources Division, all Directors, General Managers, or the Chief Administrative Officer and Elected Officials shall not be employed by the City in any capacity.
The immediate relatives of all other Management personnel shall not be employed where such employment would be:
1. within the same Department in the case of permanent full-time, temporary full-time and part-time classifications.
2. within the same Division in the case of students."
Asset Management and Business Solutions
Number of Positions
Hours of Work
Monday - Friday 8:00 - 4:00
Kitchener Operations Facility
$63,432 - $79,292
8 (under review)