What You'll Be DoingYou 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.
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: 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.
- 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 can demonstrate experience with 5+ years of expertise in building and maintaining robust Power BI infrastructure. You manage the full cycle of power BI integration and deployment end to end. You have solid Python and PowerShell database coding experience. You have a solid understanding of operating systems like Windows and you are proficient in scripting and automation using tools such as Python, and PowerShell. You excel at automating infrastructure and governance tasks to streamline operations, reduce manual effort, and improve system reliability. 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). 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 love to learn. You're passionate about growing your knowledge. You have a strong sense of curiosity.
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
#LI-TA
What CIBC OffersAt 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
Job LocationToronto-81 Bay, 27th Floor
Employment TypeRegular
Weekly Hours37.5
SkillsAnalytical Thinking, Application Development, Applications Programming, Automation, Business Intelligence (BI), Emerging Technologies, IT Strategic Planning, Microsoft Power Automate, Microsoft Power Platform, Microsoft PowerShell, Project Management Technology, Work Collaboratively