STUDENT ANALYST - BUSINESS PERFORMANCE AND ANALYTICS

Socket.dev; Montreal (administrative region); Hybrid; CAD 38,000 - 52,000; Full time

Benefits offered by this job

Flexible benefits

Wellness account

Hybrid work model

Training and development

Pension plan

Job summary

BDC is seeking a Student Analyst, Business Performance and Analytics, to turn data into actionable insights across multiple lines of business. You will build and improve dashboards, reports and analytical models, collaborating with stakeholders to drive informed decisions.

You will strengthen technical and business acumen in SQL, Power BI, Azure Databricks and Excel, while supporting performance measurement and financial analysis in a purpose-driven banking environment.

Qualifications

• Currently enrolled in a university program related to BI, data analysis, finance or IT.
• Strong analytical potential with academic, internship or project exposure.
• Interest in performance analytics, data modelling and banking operations.

Responsibilities

• Support development and rollout of performance scorecards with dashboards.
• Analyze models and reports to identify trends and provide insights.
• Collaborate with operations to design measures for business success.
• Maintain data models, processes and dashboards for accuracy.
• Extract, validate and organize data from internal/external sources.
• Use SQL, Azure Databricks, Power BI and Excel for reporting solutions.
• Prepare analyses on productivity, costs and profitability for management.

Skills

SQL

Power BI

Azure Databricks

Excel

Data modelling

Data analysis

Communication

Education

University program in BI/Data analysis

Tools

Power BI

Azure Databricks

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

Explore the BDC Way in Culture Book

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.