Data Warehouse Engineering Manager CATC
Summary
Manages CATC's enterprise data environment, designing and operating an Azure SQL data warehouse with advanced SQL, relational/dimensional modelling, dbt transformations, and ETL/ELT integrations. Supports Finance, FP&A, and analytics teams with dependable reporting datasets, including enabling Power BI developers.
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.