Shape CATC’s Azure SQL data warehouse using advanced SQL, relational modelling, and dbt. This permanent, full time role connects critical business systems. The Data Engineering & Platforms Manager owns the technical operation and continuous improvement of CATC’s enterprise data environment. Reporting to the Director of Information Technology, you will design structures, relationships, transformations, and integrations. You will help Finance, FP&A;, and analytics teams use dependable data for reporting and decisions.

Key Responsibilities
- Design data structures supporting financial, operational, and analytical requirements
- Optimize queries, databases, and pipelines for performance and reliability
- Develop ETL/ELT processes from multiple source systems
- Support Power BI developers and business analysts with warehouse datasets




- Document sources, flows, transformations, dependencies, and business rules

Requirements:
- Approximately 5–8+ years of progressive data experience
- Advanced SQL, including transformations, optimization, procedures, and troubleshooting
- Strong relational database and data warehouse design experience
- Knowledge of dimensional and relational data modelling principles
- Experience supporting Power BI or another enterprise business-intelligence platform Use warehouse architecture, advanced SQL, dbt transformations, and analytics enablement to strengthen CATC’s business data foundation.

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