Corporate Finance Intern: Analytics, Dashboards & Forecasting

National Bank of Canada; Montreal (administrative region); On-site; CAD 16,000 - 21,000; Part time

Benefits offered by this job

Health and wellness program

Group insurance

Generous pension plan

Employee and Family Assistance Program

Preferential banking services

Community involvement opportunities

Telemedicine service

Virtual sleep clinic

Job summary

National Bank of Canada offers an internship in Corporate Finance to contribute to financial analysis, tool development, and decision-support analytics. You will work within a large Finance team and report to the Director of Financial Planning and Analysis, gaining exposure to capital, treasury, and real estate strategy topics.

The role emphasizes advanced Excel, SQL, Python/SQL programming, and AI concepts, with opportunities to automate tasks and develop dashboards across business lines.

Qualifications

• 1st or 2nd cycle student in data, finance, mathematics or business analytics.
• Advanced Excel skills and working knowledge of artificial intelligence.
• Programming knowledge in Python, SQL or VBA.

Responsibilities

• Improve an analytics environment SQL/SAP/Excel.
• Set up or improve Excel analysis tools and develop dashboards.
• Participate in capital monitoring calculations.
• Develop liquidity monitoring measures and forecasting supervision tools.
• Analyze the bank's revenues and expenses at different levels.
• Evaluate client profitability.
• Optimize our methods and simplify disclosure and management analysis with different business lines.
• Automate tasks related to the real estate business strategy using tools such as Power Platform.

Skills

Advanced Excel

Python/SQL/VBA

Education

1st or 2nd university cycle in data/finance/math/business analytics

Tools

Python

SQL

VBA

Job description

National Bank of Canada offers an internship in Corporate Finance to contribute to financial analysis, tool development, and decision-support analytics. You will work within a large Finance team and report to the Director of Financial Planning and Analysis, gaining exposure to capital, treasury, and real estate strategy topics.

The role emphasizes advanced Excel, SQL, Python/SQL programming, and AI concepts, with opportunities to automate tasks and develop dashboards across business lines.