Data Engineer

Canadian Imperial Bank of Commerce; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading financial institution in Toronto is looking for an experienced Data Engineer to join their Enterprise Technology team. You will contribute to a technology culture focused on digital transformation, cloud migration, and automation. The ideal candidate should possess over 5 years in BI infrastructure with a solid background in Python and SQL. This position offers a competitive salary, benefits, and the opportunity to work in a collaborative environment that supports your growth and development.

Benefits

Competitive salary

Incentive pay

Banking benefits

Defined benefit pension plan

Employee share purchase plan

Wellbeing support

Social recognition program

Qualifications

• 5+ years of experience in building and maintaining robust BI infrastructure.
• Solid experience in SQL, PL/SQL, Azure SQL, SQL Server, MySQL.
• Strong database administration knowledge including managing and optimizing relational and non-relational databases.

Responsibilities

• Collaborate with teams for continued improvements in BI functionality and performance.
• Participate in infrastructure design and implementation discussions.
• Develop and deliver BI reports and dashboards as needed.

Skills

SQL Databases

Python (Programming Language)

Business Intelligence (BI) Reporting Tools

Tools

SAS

Tableau

Alteryx

Power BI

ThoughtSpot

Azure SQL

SQL Server

MySQL

Databricks

Azure Data Factory

ADLS

Job description

We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients.

At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute.

To learn more about CIBC, please visit CIBC.com

What You’ll Be Doing

Your will be joining the Enterprise Technology team within CIBC. As a Data Engineer you’ll be a key part of an innovative, “first to market” technology culture, contributing to key CIBC’s strategies such as digital transformation, cloud migration, automation. As a Data Engineer, you’ll be part of Enterprise Business Intelligence (BI) Technology team delivering and managing enterprise-wide BI Services/Platforms to broad CIBC user community. You will also be on continuous exploration and evaluation of emerging BI technology platforms, as well as cloud solutions. You will facilitate easy to use, customer-centric BI services.

At CIBC, we enable the work environment most optimal for you to thrive in your role. Details on your work arrangement (proportion of on-site and remote work) will be discussed during your interview.

How You’ll Succeed

• Collaborative Development: Contribute to the BI team goals by collaborating with other functional teams, actively looking for continued improvements in functionality, stability, capacity and performance of the BI services.
• Infrastructure design and implementation: Get involved with various teams on the discussion and assignments for infrastructure design and implementation. Big Picture mind is essential to succeed for understanding the overall system integration and data flows.
• Programming Ability: Perform, coordinate and facilitate changes to the services as required. Develop and deliver BI reports, dashboards, workflows for the home department and business partners as required. Provide guidance to users on features and capabilities to assist them in timely solution delivery. Strive to automate relevant processes for efficiency and cost savings.
• Project Delivery and Influence: Actively participate and contribute to project activities and deliverables to ensure overall quality solution delivery that aligns with business and project requirements. Monitor production and user acceptance testing support to troubleshoot complex problems in the services and underlying technologies.

Who You Are

• You are an experienced Data Engineer with 5+ years of expertise in building and maintaining robust BI infrastructure. You have solid Database Application development experience using SQL, PL/SQL, Azure SQL, SQL server, MySQL. Your knowledge spans across BI tools such as SAS, Tableau, Alteryx, Power BI, and ThoughtSpot, with a primary focus on the backend infrastructure that powers these platforms. You excel in configuring and optimizing BI applications, including server farm setup, application configurations, feature enablement, and network security (e.g., whitelist management). You have solid Python and SQL coding experience. In addition, you bring strong database administration knowledge, including experience in designing, managing, and optimizing relational and non-relational databases. You are proficient in writing and tuning complex queries, managing database security, and ensuring high availability and performance of database system. You have a solid understanding of operating systems like Windows and Linux, and you are proficient in scripting and automation using tools such as Python, Bash, and PowerShell. You excel at automating infrastructure and governance tasks to streamline operations, reduce manual effort, and improve system reliability. IT's nice if your expertise extends to cloud computing, with a strong preference for experience in Microsoft Azure. You have hands‑on experience with cloud‑based infrastructure and analytic tooling (Databricks, Azure Data Factory, ADLS).
• Your influence makes an impact. You know that relationships and networks are essential to success. You inspire outcomes by making yourself heard.
• You're driven by collective success. You know that collaboration can transform a good idea into a great one. You understand the power of a team that enjoys working together to create a shared vision. You are passionate about client service – You want the work you do each day to result in a positive client experience.
• Values matter to you. You bring your real self to work and you live our values – trust, teamwork, and accountability.

What CIBC Offers

At CIBC, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential. We aspire to give you a career, rather than just a paycheck.

• We work to recognize you in meaningful, personalized ways including a 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.

• Our spaces and technological toolkit will make it simple to bring together great minds to create innovative solutions that make a difference for our clients.

• We cultivate a culture where you can express your ambition through initiatives like Purpose Day; a paid day off dedicated for you to use to invest in your growth and development.

*Subject to plan and program terms and conditions

What you need to know

• CIBC is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. If you need accommodation, please contact [e-mail]

• 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 tests (such as simulation, coding, French proficiency, MS Office). Our goal for the application process is to get to know more about you, all that you have to offer, and give you the opportunity to learn more about us.

Job Location

Toronto-81 Bay, 27th Floor

Employment Type

Regular

Weekly Hours

37.5

Skills

Business Intelligence (BI) Reporting Tools, Python (Programming Language), SQL Databases