Talent.com
Data Engineer
Data EngineerChildren's Treatment Network (CTN) • Richmond Hill, York Region, CA
Data Engineer

Data Engineer

Children's Treatment Network (CTN) • Richmond Hill, York Region, CA
2 days ago
Job type
  • Full-time
  • Permanent
Job description

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 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 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.ca
  • Quote Job ID #NV-002 in the subject line of email
  • Applications are accepted from January 13 – February 3, 2026.

    Thank you for your interest in this opportunity!

    #J-18808-Ljbffr

    Create a job alert for this search

    Data Engineer • Richmond Hill, York Region, CA

    Similar jobs
    Data Engineer

    Data Engineer

    TheAppLabb • Toronto, ON, Canada
    Full-time
    Interested in joining our team? Send us your resume, and we'll include you in our Talent Pool!.When new positions become available at TAL, we'll consult our Talent Pool.If your qualificatio...Show more
    Last updated: 30+ days ago • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Scene+ • Toronto, ON, Canada
    Full-time
    At Scene+, we foster an entrepreneurial spirit that drives our mission : making tomorrow even more rewarding for our members. As a unique joint venture between Cineplex, Empire, and Scotiabank, and a...Show more
    Last updated: 30+ days ago • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Phoenix • Toronto, ON, Canada
    Full-time
    As the first Senior Data Engineer at Phoenix Digital, you’ll be able to shape what our data ecosystem looks like.You’ll work closely with our cofounders and cross-functional teams to de...Show more
    Last updated: 30+ days ago • Promoted
    Sr. Data Engineer

    Sr. Data Engineer

    Xplore Inc. • Markham, ON, Canada
    Full-time
    Canada’s fibre, 5G and satellite broadband company for rural living.Xplore is committed to the relentless pursuit of an improved broadband experience for all Canadians. Xplore is building a world-cl...Show more
    Last updated: 22 days ago • Promoted
    Azure Data Engineer

    Azure Data Engineer

    Cloudious LLC • Toronto, ON, Canada
    Full-time
    Quick Apply
    Table" style="border : undefined"> Rate : CAD 55 / hr on T4 ...Show more
    Last updated: 4 days ago
    Senior Data Engineer

    Senior Data Engineer

    Alpaca • Toronto, ON, Canada
    Full-time
    Alpaca is a US-headquartered self-clearing broker-dealer and brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, 24 / 5 trading, and more. Our recent Series C funding round broug...Show more
    Last updated: 8 days ago • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Clickatell • Toronto, ON, CA
    Full-time
    Quick Apply
    We Are Innovators & Category Creators.Visa, ABSA, MTN, Toyota, and Pick n Pay.Clickatell has led multiple .WhatsApp payments, KYC chat banking, and Chat-2-Pay. As a Data Engineer, you will ...Show more
    Last updated: 2 days ago
    Lead Data Platform Engineer for AI & Analytics

    Lead Data Platform Engineer for AI & Analytics

    Tangerine • Toronto C6A, ON, Canada
    Full-time
    A leading direct bank in Canada is seeking a skilled Data Engineer to build a new data platform for business analytics and AI. This role involves leading the data engineering strategy and collaborat...Show more
    Last updated: 23 days ago • Promoted
    Senior Full Stack Engineer, Data Ecosystem

    Senior Full Stack Engineer, Data Ecosystem

    Carta • Toronto C6A, ON, Canada
    Full-time
    Carta connects founders, investors, and limited partners through world-class software, purpose-built for everyone in venture capital, private equity and private credit. Trusted by 65,000+ companies ...Show more
    Last updated: 14 days ago • Promoted
    Data Engineer - Snowflake

    Data Engineer - Snowflake

    Tiger Analytics Inc. • Toronto, ON, Canada
    Full-time
    Tiger Analytics is a fast-growing advanced analytics consulting firm.Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several F...Show more
    Last updated: 30+ days ago • Promoted
    Senior Data Platform Engineer - Build Real-Time Data Infra

    Senior Data Platform Engineer - Build Real-Time Data Infra

    Gusto • Toronto C6A, ON, Canada
    Remote
    Full-time
    A leading small business solutions provider in Toronto is looking for a Senior Software Engineer to architect and maintain data infrastructure. This role involves collaboration with cross-functional...Show more
    Last updated: 30+ days ago • Promoted
    Distinguished Engineer, Data & ML / AI, Office of the CTO

    Distinguished Engineer, Data & ML / AI, Office of the CTO

    Equinix • Toronto C6A, ON, Canada
    Full-time
    Distinguished Engineer, Data, ML and AI, Office of the CTO.Equinix is the world’s digital infrastructure company, shortening the path to connectivity to enable the innovations that enrich our work,...Show more
    Last updated: 30+ days ago • Promoted
    Principal Consultant, Data Engineer (Level 4)

    Principal Consultant, Data Engineer (Level 4)

    Lovelytics • Toronto, ON, CA
    Full-time
    Quick Apply
    Lovelytics is a Databricks-focused data and AI consulting firm specializing in artificial intelligence, data, and analytics solutions. Since partnering with Databricks in 2019, Lovelytics has experi...Show more
    Last updated: 30+ days ago
    Senior Data Engineer

    Senior Data Engineer

    Gore Mutual Insurance • Toronto, ON, Canada
    Full-time
    Fueled by investments in talent and technology, our bold strategy to transform is nearly complete.At Gore Mutual, we've always set ourselves apart as a modern mutual that does good.Now, we'...Show more
    Last updated: 30+ days ago • Promoted
    Senior Data Platform Engineer — TB-Scale Pipelines

    Senior Data Platform Engineer — TB-Scale Pipelines

    ZoomInfo • Toronto C6A, ON, Canada
    Full-time
    A leading data intelligence firm in Toronto is looking for a Senior SW Engineer to enhance their data platforms.The ideal candidate will have extensive experience in Java and Python, and a passion ...Show more
    Last updated: 30+ days ago • Promoted
    Sr. Data Engineer

    Sr. Data Engineer

    Hire DigITalent • Toronto, ON, Canada
    Full-time
    Hybrid – 2-3 days in the Toronto office.Only candidates whose experience closely matches the requirements will be contacted. Our client is a fast-moving, innovation-driven team at the forefron...Show more
    Last updated: 30+ days ago • Promoted
    Software Engineer I / II - Data Engineering

    Software Engineer I / II - Data Engineering

    Rocket Lab Corporation • Toronto, ON, Canada
    Permanent
    Rocket Lab is an end-to-end space company delivering responsive launch services, complete spacecraft design and manufacturing, payloads, satellite components, and more – all with the goal of ...Show more
    Last updated: 2 days ago • Promoted
    Oliver Wyman - Principal Data Engineer

    Oliver Wyman - Principal Data Engineer

    Marsh • Toronto C6A, ON, Canada
    Remote
    Full-time
    Oliver Wyman - Principal Data Engineer at Marsh.Oliver Wyman Performance Transformation.Be among the first 25 applicants. Locations : Boston, New York, Chicago, Washington DC, Toronto, Montreal.No tw...Show more
    Last updated: 12 days ago • Promoted