Salary Range: $125,000.00 To $150,000.00 Annually

Reference ID: 001-CATC-78

Line of Business: Shared Services

Position Type: Full time, Permanent

Vacancy Status: This Posting is for a Recent Role

Compensation: $125,000 - $150,000

WHAT YOU’LL LOVE ABOUT CATC:

AS A MULTIDISCIPLINARY HEALTHCARE TEAM - TOGETHER, WE:

C ompassion - we meet people where they are, ready to help

A ccountability - we take responsibility for outcomes

R spect - we work well with others

E xcellence - we deliver exceptional experiences to everyone we encounter

- Wellness: Group Benefits Plan for you and your family along with Employee Assistant Programs through TELUS Health, discounted GoodLife fitness memberships, paid time off for vacation, wellness days for illness, and mental health, and bereavement.
- Career Development: Professional Development, i ncluding CNO License reimbursement, Lunch & Learn Sessions and access to 100+ courses within the Company’s Learning Management System.
- Preparation for the Future: Retirement Savings Plan (RRSP/DPSP).
- Employee Recognition: Service Recognition Program.

ABOUT THE POSITION:

Canadian Addiction Treatment Centres (“CATC”) is a leading Canadian provider of addiction treatment services, operating a large and growing network of treatment centres, pharmacies and related healthcare services across Canada. CATC is is seeking a Manager, Data Engineering & Platforms to lead the development, operation and continuous improvement of CATC's enterprise data platform.

Reporting to the Director of Information Technology, the Manager will have primary responsibility for CATC's Azure SQL data warehouse and the Python, SQL and dbt-based pipelines,



integrations and APIs that connect CATC's operational systems, automation platforms and business applications to the warehouse, including current integrations involving Zapier and Salesforce.

The Manager will work closely with Finance, FP&A;, Information Technology, operational leaders and system owners to ensure that reliable, timely and appropriately structured data is available to support financial planning and analysis, management reporting, Power BI analytics and operational decision-making.

This is a hands-on technical leadership position. The successful candidate will combine strong data engineering and data architecture capabilities with an ability to understand business requirements, investigate data problems across source systems, and work collaboratively with business and technical stakeholders to develop sustainable solutions.

YOUR DUTIES AND RESPONSIBILITIES:

- Own and maintain the Python, SQL and dbt-based data connections, integrations, APIs and data pipelines between CATC's operational systems and its Azure SQL data warehouse.
- Design, develop, implement and support new data integrations required to meet evolving business and reporting requirements.
- Own and support data integrations between automation platforms and core business systems, including current integrations involving Zapier, Salesforce and related operational data flows.




- Develop and maintain ETL/ELT processes using Python, SQL and dbt to extract, transform and load information from source systems into CATC's data warehouse.
- Work with third-party software providers and internal IT resources to understand available APIs, database structures, data exports and integration options.
- Monitor data pipelines and interfaces for failures, latency, completeness and other issues, and implement appropriate monitoring and exception-handling processes.
- Troubleshoot integration and data-processing issues and perform root-cause analysis to prevent recurring problems.

Data Warehouse & Architecture

- Own the technical operation, maintenance and continuous improvement of CATC's Azure SQL data warehouse.
- Design and maintain scalable data structures, tables, relationships and data models that support financial, operational and analytical requirements.
- Develop and maintain appropriate data architecture standards, including naming conventions, data models, dbt transformation logic and documentation.
- Optimize database structures, queries and data pipelines for reliability, usability and performance.
- Evaluate opportunities to improve CATC's data architecture and recommend appropriate technologies, tools and architectural changes as requirements evolve.
- Maintain appropriate development, testing, change-management and deployment practices for the data environment.

- Own the technical operation, maintenance and continuous improvement of CATC's Azure SQL data warehouse.
- Design and maintain scalable data structures, tables, relationships and data models that support financial

📌 Manager – Data Engineering (Markham)
🏢 Canadian Addiction Treatment Centres
📍 Markham