Data Warehouse Engineering Manager CATC - Offres d'emploi au Canada - jobs-ca.com

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.