STUDENT ANALYST - BUSINESS PERFORMANCE AND 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

We are banking at another level. Choosing BDC as your employer means working in a healthy, inclusive, and skilled workplace that puts forward the best conditions to bring together unique teams where employees are empowered to act. It also means being at the centre of ambitious economic and financial projects to see further and to do things differently, to fuel the success of Canadian entrepreneurs. Choosing BDC as your employer also means: Flexible and competitive benefits, including an Employee Savings and Investment Plan where BDC matches part of your voluntary contributions, a Defined Benefit Pension Plan, a $750 wellness and health care spending account, to name a few In addition to paid vacation each year, five personal days, sick days as necessary, and our offices are closed from December 25 to January 1 A hybrid work model that truly balances work and personal life Opportunities for learning, training and development, and much more...

POSITION OVERVIEW

Are you curious, analytical and motivated by the opportunity to turn complex data into meaningful business insights? As a Student Analyst, Business Performance and Analytics, you will play an active role in supporting BDC managers and executives through business intelligence, performance and financial analysis, as well as create dashboards that help guide strategic and operational decisions. In this role, you will work at the intersection of data analysis, business intelligence and financial performance. You will contribute to the development, maintenance and continuous improvement of analytical models, Power BI dashboards and performance measurement tools that support several BDC business lines, including Financing, Growth and Transition Capital, and Advisory Services. You will analyze and connect data from multiple BDC ecosystems, including loan portfolio activity, authorization volumes, employee and business unit performance, incentive plan models, and operational performance indicators. This is a great opportunity for someone who enjoys working with data, asking the right questions, solving business problems and translating information into clear, useful insights. You will collaborate with experienced colleagues and business stakeholders, deepen your expertise in tools such as SQL, Power BI and Azure Databricks, and gain exposure to high-impact business questions across BDC. The role is ideal for a candidate who wants to grow both technically and professionally by combining analytics, data visualization, stakeholder collaboration and business acumen in a purpose-driven banking environment. *This role is temporary for 4 months.

CHALLENGES TO BE MET

• Support the annual development and rollout of business line performance scorecards by turning strategic priorities, regional objectives and business needs into clear performance indicators and dashboards
• Support management decision-making by using models and reports in performance analysis to identify trends, highlight key results and provide useful insights
• Collaborate with the business line operation support teams to understand performance objectives and help design effective measures that drive business success
• Support the production and validation of quantitative indicators related to individual performance objectives, including financing performance guidelines and other performance measurement frameworks
• Contribute to the maintenance and continuous improvement of performance related data models, process and dashboards to help data integrity, operational relevance and financial accuracy
• Extract, validate, transform and organize data from internal systems and external sources while ensuring data quality, consistency and usability for analysis
• Use analytics and BI tools, including SQL, Azure Databricks, Power BI and Excel, to build, maintain and improve data models, dashboards, and reporting solutions that support performance monitoring and decision making
• Prepare analysis related to productivity, efficiency, costs and profitability to help inform recommendations presented to management and key stakeholders
• Support cost allocation, return on risk adjusted capital (RORAC) and loan-level profitability analysis to help improve the understanding of business performance and resource allocation
• Stay curious about available data sources, system definitions and best practices, and share ideas to improve the way the team works

WHAT WE ARE LOOKING FOR

Currently enrolled in a university program in business intelligence, data analysis, financial engineering, finance, information technology, mathematics, or a related field. Candidates with strong analytical potential and relevant academic, internship or project experience are also encouraged to apply. Experience in banking, financial services, financial analysis, performance analytics, operations, market risk management or portfolio risk management is an asset Interest in performance analytics, business intelligence, data modelling, mathematics and banking business operations Strong SQL skills and good knowledge of data modelling, mathematics and reporting tools such as Power BI, Azure Databricks and Excel Ability to understand business processes, data structures and reporting needs, with curiosity for data engineering and data visualization Attention to detail, patience and commitment to producing accurate, reliable analysis Ability to organize information, gather requirements from stakeholders, ask good questions and communicate findings clearly Ability to manage priorities, work under pressure when needed and meet deadlines Ability to grasp new concepts quickly, apply feedback and contribute to continuous improvement and change initiatives Good interpersonal and collaboration skills Good oral and written communication skills in both official languages (french and english).

*As part of the hiring process, we conduct background checks (credit, criminal, educational, international) that must meet our internal guidelines.

**Please take note that temporary employees are not eligible for benefits.

Proudly one of Canada’s Top 100 Employers and one of Canada’s Best Diversity Employers, we are committed to fostering a diverse, equitable, inclusive and accessible environment where all employees can thrive and feel empowered to bring their whole selves to work. If you require an accommodation to complete your application, please do not hesitate to contact us at [e-mail]. While we appreciate all applications, we advise that only the candidates selected to participate in the recruitment process will be contacted.

BDC is a bank unlike any other. We are the only bank dedicated exclusively to the development of Canadian businesses. The only institution whose purpose is to promote the growth of the Canadian economy by focusing on the success of small and medium-sized businesses, with a human touch and a genuine presence. At BDC, we’re changing people’s and businesses’ lives for the better. That’s what makes us unique as a bank. That’s why we are banking at another level.