Azure Engineer, SQL & Data Lakehouse

Design, develop, and optimize backend databases and data warehousing solutions in Azure cloud environments.,Manage large datasets exceeding 5TB.,Build and maintain robust ETL pipelines.,Write complex SQL queries and stored procedures.,Support reporting platforms such as Cognos and Power BI.,Perform performance tuning and troubleshooting database objects.,Collaborate with cross-functional teams to ensure seamless end-to-end data flow.,Implement data models and warehousing solutions to meet evolving business needs.,Support and enhance Azure Cloud infrastructure related to database and data pipeline solutions.,Develop multi-year technology roadmaps.,Lead multiple complicated projects involving backend systems, new technology, and enhancement of existing applications.

Experience in designing and optimizing backend databases.,Experience in writing complex SQL queries and stored procedures.,Experience in building robust ETL pipelines for large datasets.,Experience in supporting reporting tools like Cognos and Power BI.,Experience in implementing data models and warehousing solutions.,Experience in performing performance tuning and troubleshooting in Azure SQL environments.,Familiarity with modern data tools such as PySpark, Azure Data Factory, Databricks, and Delta tables/Lakehouse architecture.,Embraces and advocates change, continuously evolving thinking and work methods.,Strong influence and relationship-building skills.,Digitally savvy, seeking innovative solutions and embracing evolving technologies.,Motivated by collective success and teamwork.,Lives CIBC values: trust, teamwork, and accountability.

Must be legally eligible to work at the specified location(s). May require completing attribute-based assessments and other skills tests (simulation, coding, French proficiency).