BI Automation Engineer
About The Position
You will be joining the Enterprise Business Intelligence (BI) Technology team delivering and managing enterprise-wide BI Services/Platforms to broad CIBC user community. As a BI Automation 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. 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. 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.
Requirements
- 5+ years of expertise in building and maintaining robust Power BI infrastructure.
- Manage the full cycle of power BI integration and deployment end to end.
- Solid Python and PowerShell database coding experience.
- Solid understanding of operating systems like Windows.
- Proficient in scripting and automation using tools such as Python, 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).
- 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.
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.
- programming using Python and/or Powershell.
- 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.
Benefits
- competitive salary
- incentive pay
- banking benefits
- a benefits program
- defined benefit pension plan
- an employee share purchase plan
- a vacation offering
- wellbeing support
- MomentMakers, our social, points-based recognition program
- Purpose Day; a paid day off dedicated for you to use to invest in your growth and development
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
