Hours: 35 hrs/wk.
Rate: $60.00 per hour.
Classification: Contract Full-Time.
Location: 30 College St., Toronto.
Position Summary:
We are seeking a technically strong data professional with expertise in tools such as SQL, Microsoft Power BI, Azure Data Lake, and Microsoft Power Apps to support data quality and integrity across the organization. This role focuses on identifying data quality issues through analysis, translating findings into actionable insights, and working with the Data Council to recommend and implement approved corrections within front-end systems.
The ideal candidate brings a solid foundation in relational databases and data analysis, combined with the ability to drive measurable improvements in data accuracy, consistency, and reliability. This is a hands-on, execution-focused role that requires both analytical depth and the ability to operationalize data improvements within business systems.
This position follows a hybrid work model, with a combination of on-site presence and remote work, supporting collaboration with cross-functional teams and stakeholders.
Primary 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 data 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.
- 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 working 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.
Nice to have:
- Data quality process development experience.
- Data quality policy development experience.
- Experience in Frontline and/or Caseworks.
- Certified Business Analysis Professional (CBAP).
- Certified Data Management Professional (CDMP).
- Microsoft Fabric Data Engineer Associate (DP-600).
- Microsoft Power BI Data Analyst Associate (PL-300).
- Microsoft Power Platform App Maker Associate (PL-100).
- Microsoft Power Platform Developer Associate (PL-400).
- Microsoft Power Platform Solution Architect Expert (PL-600).
- Microsoft Power Platform Fundamentals (PL-900).
Minimum Qualifications, Knowledge, Skills:
- College diploma\University degree or 3 years equivalent work experience in data.
- 3-5 years of hands-on experience designing and managing solutions within Azure Data Lake and enterprise data platforms.
- 3-5 years of demonstrated expertise developing insights and dashboards using Microsoft Power BI in a business-driven environment.
- 3-5 years of practical experience building and optimizing applications using Microsoft Power Apps across organizational workflows.
- 3-5 years of strong proficiency in SQL, including data querying, transformation, and integration within business systems.
- 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.
- 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.
- Ability to work effectively with all levels of staff, to maintain effective communication and working relationships, demonstrating strong interpersonal skills, tact, sensitivity and build strong internal relationships.
Our Commitment:
- We are an Equal Opportunity Employer committed to diversity and inclusion and does not discriminate on the basis of any legally protected ground.
- In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, Native Child will provide accommodations throughout the recruitment and selection process to applicants with disabilities as required. If you require accommodation during the interview process, please contact Human Resources at hrncfst@nativechild.org.
- We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.
Come join our team - and help create a difference in the community
Use of AI:
NCFST may use artificial intelligence (AI) tools to assist with certain aspects of the hiring process, such as screening and assessments. These tools support our team but do not replace human judgment. We are committed to using AI responsibly, fairly, and in compliance with applicable employment and anti-discrimination laws. We regularly review these tools to help prevent bias or discrimination.
About Native Child and Family Services of Toronto: Native Child and Family Services of Toronto strives to provide a life of quality, well-being, caring and healing for our children and families in the Toronto Indigenous Community. We do this by creating a service model that is culture-based and respects the values of Native people, the extended family, and the right to self-determination and through the integration of holistic, culturally based prevention services that are child centred, family focused, and community driven.