BI Automation Engineer

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 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. 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 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 [email protected] CIBC is committed to clarity in our hiring process. All roles posted are opportunities we’re actively recruiting for, unless stated otherwise. 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. 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 Analytical 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