Data Engineer

What We Do: 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 the Accessibility for Ontarians with Disabilities Act (AODA), 2005 and the Integrated 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.

Data Engineer

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 of Applications and Data Systems.

Responsibilities

Business Intelligence Development

• Develop and maintain an expert understanding of CTN’s data sources and the business meaning of data
• In collaboration with the Quality, Measurement, and Evaluation team (QME), gather requirements from various internal stakeholders
• Architect, design, and develop database views, tables, stored procedures, and other backend components
• Develop SSIS packages to automate the extract, translate, and load (ETL) process
• Design and deliver data models that support routine reporting, dashboards, scorecards, with drill-down and/or drill through options
• Develop automated routine reporting mechanisms
• Respond to ad hoc data and report requests
• Utilize strong change management principles to safely implement enhancements and deploy products
• Develop PowerBI and SSRS reports and provide development support to QME team

Business Intelligence Maintenance

• Monitor and improve BI system performance
• Develop and maintain automated process logging and error checking
• Investigate and correct, or recommend remediation for, data quality concerns and other data issues
• Update data structures to reflect CTN’s evolving business
• Conduct routine maintenance tasks

Database Management Systems (DBMS)

• Advise the information technology team regarding maintenance, and support of internally hosted DBMS
• Create DBMS maintenance plans to support smooth database operations
• In collaboration with the information technology team, manage database security and access, and ensure that DB backup and recovery plans are in place and tested
• Investigate and resolve DBMS issues and performance problems
• Set, maintain, and adhere to database standards

Leadership and Planning

• Develop BI work plans in alignment with the operational goals and strategic direction for the organization
• Understand business needs and challenges to inform and envision BI solutions
• Ensure that departmental work plans align with business requirements and are met within agreed timelines
• Ensure that client information privacy and security is first and foremost in the design of, and improvements to BI products
• Remain up to date with relevant BI technologies and best practices
• Share SQL and data expertise with other CTN staff

What We Need

• A minimum of university degree in computer science or information management is required or equivalent experience
• A minimum of five (5) years of related business intelligence experience, preferably in a healthcare or social services environment is required
• Expert 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 asset
• Experience delivering data and reports that support business processes and data-driven decision making
• Advanced skills in the use of Excel and Microsoft Office
• Demonstrated understanding of Ontario’s Personal Health Information Protection Act (PHIPA) and the impact on CTN
• Strong organizational skills in the use of time, and the ability to prioritize work including the prioritization of the BI work plan
• Demonstrated ability to work independently and accurately in the presence of frequent interruptions and requests for assistance
• Ability to work flexible hours in support of requirements that may fall outside of the typical work hour framework
• Demonstrated commitment to a safe environment for staff, clients and families by working in compliance with the Occupational Health & Safety Act and related policies

Selected Successful Candidate Will Be Required To

• Produce a clear police record check with a vulnerable sector check prior to start of employment
• Be able to travel to assigned office, between CTN sites and/or other locations as required
• Maintain the ability to work effectively in a temporary hybrid environment and have access to appropriate internet capacity
• Any 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 is 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‑graduation work permit.

Office Location

Richmond Hill or Barrie

Starting Salary

$88,035 – $97,817

To Apply

1. Submit your resume to careers@ctnsy.ca
2. Quote Job ID #NV-002 in the subject line of email

Applications are accepted from November 27 – December 11 2025.

Thank you for your interest in this opportunity!