Data Engineer

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), 2005and 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

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 s position reports to the Manager, Applications and Data Systems.

The successful incumbent will be responsible for the following duties and responsibilities:

• 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 Power
  
  BI and SSRS reports and provide development support to QME team

• 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

• 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…