Data Steward

Be among the first applicants.

Native Child and Family Services of Toronto

Golden Horseshoe

CAD 80,000 - 100,000

Be among the first applicants.

3 days ago

Job description

Hours: 35hrs per wk.

Location: 30 College St., Toronto Hybrid-model.

Rate: $60.00 per hour.

Reporting to the IT Manager, the Data Steward prepares and runs SQL scripts to find data quality issues in NCFST environment, takes those findings and recommends corrections to IT Manager and Data Owners, and on approval, makes those changes in the front-end systems.

The Data Steward has sound technical knowhow and skills in databases and can quantifiably increase the quality of the organization’s data by making corrections to the data.

Key Responsibilities:

Analyze the data and case management applications (Frontline, CaseWorks, Jordan Principles Case Management System) in NCFST environment.
Identify critical data elements and define data quality metrics and thresholds for those critical data elements.
By using robust SQL experience, conduct data quality analysis, determine and report improvement needs.
Discuss findings and potential improvement methods with Service Representatives and document recommendations.
Report on data quality status and improvement recommendations to IT Manager and Data Owners.
Upon approval, conduct data quality improvement activities in test environments fist and then in production systems in defined change request forms and get approval of Service Representatives.
Document technical content such as ways of identifying data quality improvement findings and technical methods to conduct data quality improvements. Formally document results as part of the audit record.
Capture metadata related to critical data elements. The nature of this metadata should include the meaning of the data element, and whether the data element constitutes Personally Identifiable Information (PII).
Conduct research into a wide range of computing issues as required, stay current with application and data trends to be of sustainable service to NCFST.
Conduct technical work for implementing technical changes, usually after hours according to technical change management approvals and go-live plans.
Act as a Service Owner in IT organization for case management applications.
Liaise with the agency’s case management application vendors with the goals of resolving issues, solutioning, or resolving general queries.
Design and set up user profiles and access levels in case management applications.
Involve in digital transformation projects of the organization as required.
Learn, practice and test new and emerging technologies, especially Microsoft Power Platform, Azure Data Factory and Fabrics, Azure Machine Learning and Azure Cognitive Services for the benefit of the organization.
Actively working in technical projects related to data management, solution development and implementation and artificial intelligence (AI) by using Microsoft technologies.
Monitoring system usage.
Ensuring IT support staff have sufficient knowledge to be able to perform application management, especially for case management applications.
Provide second-tier support to staff related to data and case management applications.
Be available for work from other locations of the organization within the GTA.
Perform routine maintenance such as daily ministry extracts, and in conjunction with the vendor, complete installation and test updates to the case management systems.
Liaise with the third parties as required, such as with OCANDS (Ontario Common Assessment Record).
Ensure compliance with the relevant security and privacy policies, validate vendor security best practices are applied and in-place.
Provide management reporting as required.
Effectively prioritize and execute tasks in a high-pressure environment.
Work effectively with all levels of staff, maintain effective communication and working relationships, demonstrating strong interpersonal skills, tact, sensitivity and build strong internal relationships.
Other related duties and responsibilities as required.

Minimum Qualifications and Skills:

Experience And Skilled Knowledge Requirements:

3-5 years robust experience in SQL, business applications and data platforms.
3-5 years of experience in data quality with a strong ability to analyze data.
3-5 years of experience in identifying critical data elements and co-defining data quality metrics and thresholds for those critical data elements, as well as identifying and correcting data quality issues by means of these findings.
Proficiency in Python and SQL and DevOps for Data & AI.
Knowledge in Microsoft Azure and Power Platform.
Experience in business analysis, solution design and architecture, system development and implementation by using Microsoft technologies.
A willingness to learn to use case management applications in NCFST which will be used for data analysis and to capture the corrected data into. Experience with Case Management applications such as Vital Hub CaseWorks, Frontline is an asset.
Technical writing - the ability to create structured reports, in clear English.
Knowledge of metadata identification, analysis and refinement.
Numeracy - strong grasp of algebra.
Interpersonal skills, predominantly with the operations part of the business.
Very Good written and oral communication skills, and strong documentation skills.
Very Good interpersonal skills, with a focus on rapport-building, listening and questioning skills.
Exceptional customer-centric orientation and ability to present ideas in user-friendly language.
Ability to conduct research into a wide range of computing issues as required. Proven analytical and problem-solving abilities.
Ability to absorb and retain information quickly.
Highly self-motivated and directed.
Keen attention to detail.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
College diploma or University degree.
Demonstrated understanding, and commitment to, integrating the NCFST’s Mission and values in to practice, service and relationships.
Demonstrated understanding of workplace Health and Safety practices and understanding of an employee’s responsibility under current legislation.

Preferred Skills/Capabilities:

Data quality process development experience.
Data quality policy development experience.
Experience in Frontline and/or Caseworks.
Certified Data Management Professional (CDMP).
Certified Business Analysis Professional (CBAP).
Certified Microsoft Azure Data Engineer.
Certified Microsoft Power Platform Fundamentals.
Certified Microsoft Fabric Data Engineer.
Certified Microsoft Fabric Analytics Engineer.