Job Description

We\xe2\x80\x99re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what\xe2\x80\x99s 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

What you\xe2\x80\x99ll be doing

As a Consultant, Liquidity Reporting and Analysis you will support the Director in producing high quality data analysis, monitoring and reporting to provide key insights on liquidity management for Treasury\xe2\x80\x99s Funding & Liquidity Management function. The Consultant utilized the technical skills in Power BI (DAX and other programming languages like M) and SQL to support the development of best-in-class data modelling and analytical solutions to ensure accurate and timely reporting as well as providing key insight on liquidity positions. Acting as a resource integrator for their area, the role supports the execution of liquidity-related activities, and develops knowledge required to support the overall team objectives. The role uses independent judgement to participate in the development, testing and implementation of liquidity related initiatives.

At CIBC we enable the work environment most optimal for you to thrive in your role. You\xe2\x80\x99ll have the flexibility to manage your work activities within a hybrid work arrangement where you\xe2\x80\x99ll spend 1-3 days per week on-site, while other days will be remote. Details on your work arrangement (proportion of on-site and remote work) will be discussed at the time of your interview.

How you\xe2\x80\x99ll succeed

• Reporting - Develop and maintain highly sophisticated Power BI reports and dashboards that deliver actionable data insights. Manage Power BI services (Scheduling, workspace management) for reporting and report analytics. Support Treasury month end regulatory and management reporting.
• Analytics - Utilize DAX and other programming languages for effective data manipulation, transformation and creating complex measures; Demonstrate proficiency in SQL for data extraction, transformation, and loading (ETL) processes; Leverage Power Query for seamless data connectivity, transformation, and preparation; Integrate PowerBI with OLAP services, particularly SSAS, for efficient data analytics.
• Team Work and Collaboration \xe2\x80\x93 As an expert in data analytics, collaborate closely with stakeholders to discern intricate business requirements and seamlessly translate them into intuitive and visually compelling user experiences
• Be Proactive \xe2\x80\x93 Proactively identify gaps and enhancements to Treasury reporting. Conduct periodic reviews of the reporting processes and recommend ways to enhance existing processes.
• Problem solving skills - Lead investigations on issues and provide recommendations to resolve issues. This includes analyzing, assessing and documenting impacts; and developing recommendations, approaches and solutions.
• Detail oriented - Participate in establishing and implementing processes to verify the accuracy of Treasury reporting. Maintain accountability for accuracy.

Who you are

• Values matter to you. You bring your real self to work and you live our values \xe2\x80\x93 trust, teamwork and accountability.
• You can demonstrate hands on experience (i.e. 2-3 years) and advanced capabilities in Power BI (Dax, Powerquery [M], data modelling) and working with OLAP data sources like SSAS for report development.
• You can demonstrate proficiency and advanced capabilities in SQL and Power Query.
• You love to learn. You\'re passionate about growing your knowledge and developing your skills, and you know that there is no limit to what you can achieve. You have a keen interest in learning about treasury function, liquidity management, and develop knowledge of financial products across all asset classes.
• You\'re driven to succeed. You are motivated by accomplishing your goals and delivering your best to make an impact. You have proven experience in process improvement and automation initiatives.
• You give meaning to data. You enjoy investigating complex problems, and making sense of information through data analysis, understanding data patterns and trends, as well as resolving and troubleshooting data integrity. You\'re confident in your ability to solve problem through data analysis using Excel and communicate detailed information in an impactful way.
• You have excellent communication skills with the ability to present complex analyses to executive stakeholders.
• You understand that success is in the details. You notice things that others don\'t. Your critical thinking skills help to inform your decision making.
• You have a degree in scientific (statistics/engineering/computer science), economics or finance fields.
• Experience with VBA and Alteryx is considered an asset.
• Power BI Certification is considered an asset.

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

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.

Job Location Toronto-161 Bay St., 11th

Employment Type Regular

Weekly Hours 37.5

Skills Analytical Thinking, Communication, Data Analytics, Liquidity Management, Management Reporting, Market Liquidity, Microsoft Power BI, Project Management, Reporting and Analysis, Risk Management, Structured Query Language (SQL), Timely Reporting

CIBC