We're building a relationship-oriented bank for the modern world. As an Azure SQL & Data Lakehouse Engineer, you will design, develop, and optimize backend databases and data warehousing solutions in Azure cloud environments, managing large datasets exceeding 5TB. You'll build and maintain robust ETL pipelines, write complex SQL queries and stored procedures, functions, triggers and advanced performance tuning.

Your daily work will involve performance tuning and troubleshooting database objects, as well as collaborating with cross-functional teams to ensure seamless end-to-end data flow. You'll implement data models and warehousing solutions to meet evolving business needs, leveraging your expertise in data modeling and Azure SQL. You'll support and enhance Azure Cloud infrastructure as it relates to database and data pipeline solutions.

Additionally, you may work with PySpark, Azure Data Factory, Databricks, and Delta tables/Lakehouse architecture to deliver modern data solutions and Proficient in understanding and utilizing Agentic AI technologies, such as Copilot, to enhance productivity and drive innovative solutions. You'll have the flexibility to manage your work activities within a hybrid work arrangement where you'll spend 1-3 days per week on-site, while other days will be remote. Design and development - Perform and coordinate complicated application programming activities.

Design the application's technical infrastructure using specific databases, programming languages, utilities, and testing approaches. Strategic planning - Develop multi-year technology roadmaps that align with the bank’s vision, strategy, and business goals. Lead multiple complicated projects involving backend systems, new technology, and the enhancement of existing applications.

Leadership skills - Act as the mobile development team lead and run code-review sessions with the wider team to ensure the project is on track to meet goals. Support and mentor intermediate and senior developers by sharing knowledge, collaborating and problem solving.



You know that relationships and networks are essential to success.

Designing and optimizing backend databases, writing complex SQL queries and stored procedures, functions, triggers and advanced performance tuning and building robust ETL pipelines for large datasets. You have implemented data models and warehousing solutions, and performed performance tuning and troubleshooting in Azure SQL environments. Additionally, you are familiar with modern data tools such as PySpark, Azure Data Factory, Databricks, and Delta tables/Lakehouse architecture.

We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a advantages program*, defined benefit pension plan*, an employee share purchase plan, a vacation offering, wellbeing support, and MomentMakers, our social, points-based recognition program. competitive salary, incentive pay, banking benefits, a benefits program*, defined benefit pension plan*, an employee share purchase plan, a vacation offering, wellbeing support, and MomentMakers, our social, points-based recognition program. You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit. We may ask you to complete an attribute-based assessment and other skills test (such as simulation, coding, French proficiency).

We use artificial intelligence tools during the recruitment process.

Job Location

Toronto-81 Bay, 17th Floor Employment Type Regular Weekly Hours 37.5 Skills Analytical Thinking, Application Development, Applications Programming, Emerging Technologies, IT Strategic Planning, Mentoring Staff, Project Management Technology, Work Collaboratively At CIBC, we are in business to help our clients, employees and shareholders achieve what is important to them. Working with CIBC makes you a part of a work environment committed to our clients, employees and communities - a place where you can excel. Every day, our 48,000 employees help our clients achieve their financial goals, because what matters to our clients, matters to us. #

📌 Azure Engineer, SQL and Data Lakehouse (Toronto)
🏢 CIBC
📍 Toronto