Internship Excel Vba Developer Jobs in Toronto, ON

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 the Manager, Finance & Portfolio Analytics, you'll play a pivotal role in supporting the CIBC US portfolio through comprehensive analyses and reporting activities that occur weekly, monthly, and quarterly. You'll assess portfolio risk, monitor performance, develop KPIs, optimize credit exposure, and deliver data-driven recommendations to guide sound business decisions while ensuring alignment with CIBC's risk tolerance and regulatory standards.

You'll build and manage relationships with business and finance teams, collect and clean data from multiple sources, generate reports for risk monitoring, and implement logic for interactive dashboards to provide actionable insights. Applying your finance expertise, you'll create queries and conduct post-analysis to enable robust business intelligence capabilities across the organization.

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

• Relationship Building - Drive cross-functional analytics initiatives by proactively partnering with Finance, Risk, Line of Business (LOB) leaders, and other key stakeholders to identify high-impact opportunities and deliver data-driven solutions.

• Goal Driven - Lead multiple concurrent initiatives with minimal oversight, often serving as the primary point of contact for executive stakeholders.

• Detail Oriented - Compile data to support diverse reporting requirements related to credit risk and financial statement analysis, generating regularly scheduled and ad hoc reports as needed.

• Data Driven - Gather and clean data from multiple sources using SQL queries and process information with programming languages to develop reporting dashboards.

• Analytical - Support analytics for RWA, Regulatory Capital, Economic Capital, and contribute to the production of various risk reports. Assist team members in advancing analytical capabilities and participate in ongoing ad hoc risk analyses.

• Communication - Draft clear and concise documents describing all developed and developing models within the division.

• Leveraging Technology - Create professional PowerPoint presentations or Power BI dashboards to deliver regular reports and special project proposals to senior management.

Who you are

• You have experience. You bring 2-5 years of experience in finance, risk management, portfolio analytics, or reporting within a major bank or related environment.

• You are a certified professional. You hold a Bachelor's or Master's degree in economics, statistics, finance, analytics, computer science, MBA, or a related field. CPA, CFA, or FRM designation (completed or in progress) is considered an asset.

• You act like an owner. You thrive when empowered to take initiative, go above and beyond, and deliver results.

• You can demonstrate technical experience. You have excellent skills with Excel, VBA, SQL, Power BI, Tableau, and other reporting frameworks. Solid proficiency in Python and/or R, and the associated analytics packages, is required for this role. You may be asked to complete a live coding assessment as part of the interview process. Exposure to third-party tools such as Microsoft Azure, Tableau, Python Plotly, and strong research and analytical skills are considered assets.

• You are a caring and accountable leader. You provide guidance and mentorship to analysts on the team, fostering skill development, ensuring analytical rigor, and elevating the quality and impact of deliverables.

• You're motivated by collective success. You collaborate effectively and follow up to ensure achievement of deadlines, outcomes, and results.

• 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 Mailbox.careers-carrieres@cibc.com

• 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

Employment Type

Weekly Hours

Skills