Children’s Treatment Network (CTN) supports over 39,000 kids and youth with disabilities and other developmental needs. We provide intake, service navigation and coordinated service planning, assessment and diagnostic services, specialized clinics and rehabilitation services, including physiotherapy, occupational therapy and speech language therapy.
Funded by the Ministry of Children, Community and Social Services, CTN is an Ontario provincial government funded not-for profit organization, that offers services through contracted partners in the education, health and community sectors. Through its innovative network model, CTN’s commitment to providing family-centered care is anchored by an electronic client record that is shared across its partner organizations and provides the foundation for integrated plans of care and services.
Dedicated to creating a vibrant community where all kids, youth and families belong, we have a strong commitment to equity, diversity, inclusion, Indigeneity and accessibility. With this in mind, our goal is a workforce that reflects the communities we serve. We welcome all qualified applicants to apply including individuals with disabilities, those who identify as Black, Indigenous or persons of colour, members of the LGBTQ2S+ communities and others. We are proud to be in compliance with theAccessibility for Ontarians with Disabilities Act (AODA), 2005and theIntegrated Accessibility Standards Regulation. We are happy to honour accommodations at any part of the recruitment process and invite you to let us know how we can help.
What We Offer :
- Competitive compensation and employee benefits package including participation in the Healthcare of Ontario Pension Plan (HOOPP) and vacation / leave entitlement
- An opportunity to contribute to the work of a not-for-profit organization that provides services to kids and youth with disabilities and developmental needs and their families
- The chance to be a part of a culture with an organization that values inclusion, collaboration, responsibility, and innovation
- The opportunity to work with us to achieve CTN’s strategic goals of putting people at the centre of what we do, striving for excellence, fostering a culture of accountability and stewardship to support community needs, and transformation through equitable data-driven service innovation
What You Will Do :
CTN is looking for a permanent, full-time Data Engineer who will be responsible for the development and execution of business intelligence data and reporting products that support data driven decision making and ongoing operations at CTN. This position reports to the Manager, Applications and Data Systems.
Responsibilities :
The successful incumbent will be responsible for the following duties and responsibilities :
Business Intelligence Development
Develop and maintain an expert understanding of CTN’s data sources and the business meaning of dataIn collaboration with the Quality, Measurement, and Evaluation team (QME), gather requirements from various internal stakeholdersArchitect, design, and develop database views, tables, stored procedures, and other backend componentsDevelop SSIS packages to automate the extract, translate, and load (ETL) processDesign and deliver data models that support routine reporting, dashboards, scorecards, with drill-down and / or drill through optionsDevelop automated routine reporting mechanismsRespond to ad hoc data and report requestsUtilize strong change management principles to safely implement enhancements and deploy productsDevelop PowerBI and SSRS reports and provide development support to QME teamBusiness Intelligence Maintenance
Monitor and improve BI system performanceDevelop and maintain automated process logging and error checkingInvestigate and correct, or recommend remediation for, data quality concerns and other data issuesUpdate data structures to reflect CTN’s evolving businessConduct routine maintenance tasksDatabase Management Systems (DBMS)
Advise the information technology team regarding maintenance, and support of internally hosted DBMSCreate DBMS maintenance plans to support smooth database operationsIn collaboration with the information technology team, manage database security and access, and ensure that DB backup and recovery plans are in place and testedInvestigate and resolve DBMS issues and performance problemsSet, maintain, and adhere to database standardsLeadership and Planning
Develop BI work plans in alignment with the operational goals and strategic direction for the organizationUnderstand business needs and challenges to inform and envision BI solutionsEnsure that departmental work plans align with business requirements and are met within agreed timelinesEnsure that client information privacy and security is first and foremost in the design of, and improvements to BI productsRemain up to date with relevant BI technologies and best practicesShare SQL and data expertise with other CTN staffWhat We Need :
A minimum of university degree in computer science or information management is required or equivalent experienceA minimum of five (5) years of related business intelligence experience, preferably in a healthcare or social services environment is requiredExpert skills using the Microsoft SQL Server Business Intelligence development suite (T-SQL, SSIS, SSRS, SSMS, Visual Studio, PowerBI)Experience with Webfocus report product is an assetExperience delivering data and reports that support business processes and data-driven decision makingAdvanced skills in the use of Excel and Microsoft OfficeDemonstrated understanding of Ontario’s Personal Health Information Protection Act (PHIPA) and the impact on CTNStrong organizational skills in the use of time, and the ability to prioritize work including the prioritization of the BI work planDemonstrated ability to work independently and accurately in the presence of frequent interruptions and requests for assistanceAbility to work flexible hours in support of requirements that may fall outside of the typical work hour frameworkDemonstrated commitment to a safe environment for staff, clients and families by working in compliance with the Occupational Health & Safety Act and related policiesSelected Successful Candidate Will Be Required To :
Produce a clear police record check with a vulnerable sector check prior to start of employmentBe able to travel to assigned office, between CTN sites and / or other locations as requiredMaintain the ability to work effectively in a temporary hybrid environment and have access to appropriate internet capacityAny candidate being considered for employment at Children’s Treatment Network (“CTN”) must be able to provide supporting documentation to confirm their eligibility to legally work within Canada. Proof of eligibility includes but not limited to a social insurance number (SIN), Canadian birth certificate, passport, citizenship certificate, permanent residence card, open work permit, or valid receipt from Immigration Canada of an application for a post-graduate work permit.Office Location :
Richmond Hill or Barrie
Salary Range : $88,035- $97,817
CTN’s total rewards package includes competitive compensation and employee benefits package including participation in the Healthcare of Ontario Pension Plan (HOOPP), generous vacation entitlements, and the opportunity for hybrid work (position specific).
To Apply :
Submit your resume to careers@ctnsy.caQuote Job ID #NV-002 in the subject line of emailApplications are accepted from January 13 – February 3, 2026.
Thank you for your interest in this opportunity!
#J-18808-Ljbffr