Student Analyst: Hybrid BI & Performance Analytics

Business Development Bank of Canada; Montreal (administrative region); Hybrid; CAD 42,000 - 52,000; Full time

Benefits offered by this job

Hybrid work model

Wellness spending account

Flexible benefits

Job summary

BDC is seeking a Student Analyst, Business Performance and Analytics, to turn complex data into meaningful business insights. You will support managers and executives through business intelligence, performance and financial analysis, and create dashboards that guide strategic decisions across Financing, Growth and Transition Capital, and Advisory Services.

This four-month opportunity offers hands-on experience with SQL, Power BI and Azure Databricks, collaboration with experienced colleagues,

Qualifications

• Enrolled in a university program in BI, data analysis, finance or IT.
• Strong analytical potential with internship or project experience encouraged.
• Banking/financial services experience is an asset.

Responsibilities

• Develop performance scorecards and dashboards from strategic priorities.
• Analyze trends using models and reports to inform decisions.
• Collaborate with line teams to design effective performance measures.
• Maintain data models, data quality, and reporting tools.
• Extract and transform data from internal and external sources.
• Use SQL, Power BI, Azure Databricks to build dashboards.

Skills

SQL

Power BI

Azure Databricks

Excel

Data Modelling

Mathematics

Banking Operations

Communication

Education

University program enrollment

Tools

Power BI

Azure Databricks

Excel

Job description

BDC is seeking a Student Analyst, Business Performance and Analytics, to turn complex data into meaningful business insights. You will support managers and executives through business intelligence, performance and financial analysis, and create dashboards that guide strategic decisions across Financing, Growth and Transition Capital, and Advisory Services.

This four-month opportunity offers hands-on experience with SQL, Power BI and Azure Databricks, collaboration with experienced colleagues,