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 (https://www.cibc.com/en/about-cibc.html) **What you’ll 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’s 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’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. Details on your work arrangement (proportion of on-site and remote work) will be discussed at the time of your interview._ **How you’ll 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 –** 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 –** 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** + **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. + **Values matter to you.** You bring your real self to work and you live our values – trust, teamwork and accountability. **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 work to recognize you in meaningful, personalized ways including a competitive compensation, a banking benefit*, wellbeing support and additional offers such as employee and family assistance programs 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. *Subject to 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 Mailbox.careers-carrieres@cibc.com + 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 tests (such as simulation, coding, French proficiency, MS Office). 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. **Expected End Date** 2025-10-31 **Job Location** Toronto-161 Bay St 11th Floor **Employment Type** Temporary (Fixed Term) **Weekly Hours** 37.5 **Skills** Corporate Treasury, Finance, Financial Reporting and Analysis, Funding, Liquidity Management, Management Reporting, Operations Processes, Strategic Objectives, Technical Knowledge At CIBC, we are in business to help our clients, employees and shareholders achieve what is important to them. Our ability to create value for all CIBC stakeholders is driven by a business culture based on common values: Trust, Teamwork and Accountability. Working with CIBC makes you a part of a work environment committed to our clients, employees and communities - a place where you can excel. Every day, our 44,000 employees help our clients achieve their financial goals, because what matters to our clients, matters to us.