Consultant, Liquidity Reporting and Analysis

Canadian Imperial Bank of Commerce; Toronto; Hybrid; CAD 75,000 - 95,000; Full time

Job summary

A leading financial institution in Toronto seeks a Consultant, Liquidity Reporting and Analysis. The role involves high-quality data analysis using Power BI and SQL, ensuring timely liquidity reporting and process improvement. Candidates should have hands-on experience with Power BI, SQL, and a relevant degree. Join a dynamic team in a hybrid work environment.

Benefits

Competitive salary

Employee share purchase plan

Defined benefit pension plan

Wellbeing support

Paid day off for personal growth

Qualifications

• 2-3 years' hands-on experience with Power BI and OLAP data sources.
• Proficient in SQL and Power Query for data extraction and transformation.
• Strong analytical skills and ability to solve complex problems.

Responsibilities

• Ensure timely delivery of liquidity reports and continuous process improvement.
• Develop and maintain Power BI reports and dashboards.
• Collaborate with stakeholders to transform business requirements into data solutions.
• Identify gaps in reporting processes and recommend enhancements.

Skills

Power BI

SQL

Data analysis

Problem solving

Communication

Education

Degree in scientific (statistics/engineering/computer science), economics, or finance

Tools

Power Query

VBA

Alteryx

Job description

Overview

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

As a Consultant, Liquidity Reporting and Analysis you will support the Senior Manager 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 will utilize 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. The role also supports daily and monthly manual adjustment preparation and improving current processes 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 2-3 days per week on-site, while other days will be remote.

How you’ll succeed

• Reporting - Ensure the timely and accurate delivery of liquidity reports through execution and continuous improvement of the process. 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 daily and 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 Power BI with OLAP services, particularly SSAS, for efficient data analytics.
• Teamwork 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, Power Query [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 inscientific (statistics/engineering/computer science), economics or finance fields. Experience with VBA and Alteryx is considered an asset.Power BI Certification is considered an asset.
• 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 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 [e-mail]

• 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.

Job Location

Toronto-161 Bay St., 11th

Employment Type

Regular

Weekly Hours

37.5

Skills

Corporate Treasury, Finance, Financial Reporting and Analysis, Funding, Liquidity Management, Management Reporting, Operations Processes, Strategic Objectives