BI Engineer

CIBC•Toronto, ON

1d•Hybrid

About The Position

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. You 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.

Requirements

5+ years of expertise in building and maintaining robust BI infrastructure.
Solid Database Application development experience using SQL, PL/SQL, Azure SQL, SQL server, MySQL.
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.
Solid Python and SQL coding experience.
Strong database administration knowledge, including experience in designing, managing, and optimizing relational and non-relational databases.
Proficient in writing and tuning complex queries, managing database security, and ensuring high availability and performance of database system.
Solid understanding of operating systems like Windows and Linux.
Proficient in scripting and automation using tools such as Python, Bash, and PowerShell.
Excel at automating infrastructure and governance tasks to streamline operations, reduce manual effort, and improve system reliability.
Hands-on experience with cloud-based infrastructure and analytic tooling (Databricks, Azure Data Factory, ADLS).
You know that relationships and networks are essential to success.
You inspire outcomes by making yourself heard.
You’re motivated by accomplishing your goals and delivering your best to make a difference.
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 want the work you do each day to result in a positive client experience.
You bring your real self to work and you live our values - trust, teamwork, and accountability.

Nice To Haves

Expertise extends to cloud computing, with a strong preference for experience in Microsoft Azure.

Responsibilities

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.
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.
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.
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.