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
4 days ago
Job type
  • Permanent
Job description

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. 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 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, 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 a 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
  • Additional Requirements

  • 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 provide supporting documentation to confirm 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‑graduate work permit.
  • Office Location :

    Richmond Hill or Barrie

    Starting Salary

    $88,035 – $97,817

    CTN’s total rewards package includes competitive compensation and employee benefits package, 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
    Senior Associate, Azure Data Engineer

    Senior Associate, Azure Data Engineer

    PwC Canada • Toronto C6A, ON, Canada
    Full-time
    At PwC, our people in infrastructure focus on designing and implementing robust, secure IT systems that support business operations. They enable the smooth functioning of networks, servers, and data...Show more
    Last updated: 2 days ago • Promoted
    AWS data engineer DWIDC5725169

    AWS data engineer DWIDC5725169

    Compunnel Inc. • toronto, on, ca
    Full-time
    Data Engineer with AWS, Glue, Lambda, SQL, Python, Redshift.Must have working knowledge in designing and implementing data pipelines on any of the cloud providers (AWS is preferred).Must be able to...Show more
    Last updated: 3 days ago • Promoted
    Data Engineer

    Data Engineer

    Syndesus, Inc. • Toronto
    Full-time
    Our client is a high growth, exciting and already-profitable startup in Toronto - a chance to join a Rocketship at an early stage. We're seeking a Data Engineer to own the health, quality, and relia...Show more
    Last updated: 1 day ago • Promoted
    Senior Databricks Data Engineer - Lakehouse

    Senior Databricks Data Engineer - Lakehouse

    Citco GSGS • Toronto
    Full-time
    A leading financial services firm is seeking a Senior Data Engineer to enhance their Centralized Data Platform.Candidates should have over 6 years of experience in data engineering, strong skills i...Show more
    Last updated: 1 hour ago • Promoted • New!
    Data Engineer

    Data Engineer

    Insight Global • Toronto
    Full-time
    The data engineer will design and maintain the data infrastructure that powers the chatbot’s intelligence.This includes building pipelines, ensuring data quality, and enabling safe, compliant use o...Show more
    Last updated: 1 day ago • Promoted
    Data Engineer

    Data Engineer

    Vancity • Toronto
    Full-time +1
    Your Role In Supporting Our Members.You’ll work closely with cross-functional teams to troubleshoot issues, optimize processes, and contribute to the ongoing enhancement of Vancity’s Data Platform....Show more
    Last updated: 1 hour ago • Promoted • New!
    Databricks Data Engineer : Lakehouse & Real-Time Pipelines

    Databricks Data Engineer : Lakehouse & Real-Time Pipelines

    Citco GSGS • Toronto
    Full-time
    A global financial services firm in Toronto seeks a Data Engineer to contribute to their Centralized Data Platform built on Databricks. This role involves designing data solutions, optimizing ETL / EL...Show more
    Last updated: 1 hour ago • Promoted • New!
    Senior Data Engineer - Snowflake / Azure (Hybrid)

    Senior Data Engineer - Snowflake / Azure (Hybrid)

    Moneris • Toronto C6A, ON, Canada
    Full-time
    Senior Data Engineer (Corporate Data and Analytics).As the Senior Data Engineer, you will create data collection, extraction, and transformation frameworks for structured and unstructured data.You ...Show more
    Last updated: 20 days ago • Promoted
    Data Engineer

    Data Engineer

    Manulife Financial • Toronto
    Full-time
    This Data Engineer role is essential for driving efficiency and innovation within our organization.By developing and maintaining automation, this position helps streamline operations and improve ef...Show more
    Last updated: 1 day ago • Promoted
    Data Engineer - Databricks

    Data Engineer - Databricks

    The Citco Group Limited • Toronto
    Full-time
    Since the 1940s, Citco has provided specialist financial services to alternative investment funds, investors, multinationals, and private clients worldwide. Our data engineering initiatives represen...Show more
    Last updated: 1 day ago • Promoted
    Data Architect (Hybrid)

    Data Architect (Hybrid)

    Util-Assist Inc. • Newmarket L0G, ON, Canada
    Remote
    Full-time +1
    Data Architect (Hybrid / Remote).Util-Assist is a leading consulting and services partner to electric, water, and gas utilities across North America. We help utilities navigate digital transformation—...Show more
    Last updated: 30+ days ago • Promoted
    Databricks Data Engineer : Lakehouse & Real-Time Pipelines

    Databricks Data Engineer : Lakehouse & Real-Time Pipelines

    The Citco Group Limited • Toronto
    Full-time
    A global financial services provider is seeking a Data Engineer to contribute to their Centralized Data Platform using Databricks. You will develop ETL / ELT processes and work with advanced data tech...Show more
    Last updated: 1 day ago • Promoted
    Data Engineer – ETL & Medallion Architecture (Databricks)

    Data Engineer – ETL & Medallion Architecture (Databricks)

    emergiTEL Inc. • Toronto
    Full-time
    A leading technology firm in Ontario is seeking a Data Engineer to design and optimize data pipelines for effective data ingestion and transformation. The role demands a Bachelor’s degree in Compute...Show more
    Last updated: 1 day ago • Promoted
    Data Analytics Engineer

    Data Analytics Engineer

    Ignition • Toronto
    Full-time
    Founded in 2013, Ignition is theleading revenue generation platform for accounting and professional servicesbusinesses to spark greater efficiency and profitability. Ignition automates and optimizes...Show more
    Last updated: 1 day ago • Promoted
    Data Engineer

    Data Engineer

    SPECTRAFORCE • Toronto
    Full-time
    Location : Toronto, ON (Hybrid, 1-2 day per week on-site, while other days will be remote.The role is responsible for leading the functional design and development of ETL flow for Databricks across ...Show more
    Last updated: 1 day ago • Promoted
    AI and Data - Data Engineer

    AI and Data - Data Engineer

    EY • Toronto
    Full-time
    At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your u...Show more
    Last updated: 1 day ago • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Mastercard • Toronto
    Full-time
    Mastercard powers economies and empowers people in 200+ countries and territories worldwide.Together with our customers, we’re helping build asustainableeconomy where everyone can prosper.We suppor...Show more
    Last updated: 1 day ago • Promoted
    Senior Presales Engineer, Data Platform

    Senior Presales Engineer, Data Platform

    Perforce Software, Inc. • Toronto, ON, Canada
    Full-time
    A leading software firm is seeking a Senior Sales Engineer in Toronto, Ontario to partner with sales teams in presenting Delphix’s data management solutions. The role requires effective communicatio...Show more
    Last updated: 7 days ago • Promoted