Associate Data Analytics

Banque Nationale du Canada; Montreal; On-site; CAD 65,000 - 95,000; Full time

Benefits offered by this job

Health and wellness program

Employee Share Ownership Plan

Employee and family assistance program

Preferential banking services

Involvement in community initiatives

Virtual sleep clinic

Job summary

National Bank of Canada (NBCCM) is seeking an Associate, Data Analytics in Montreal to transform complex data into insight and scalable reporting for Global Funding & Treasury. You’ll build dashboards, validate data, and automate recurring analyses using SQL, Python and Power BI to support deposit forecasting and pricing decisions.

You’ll collaborate with Finance, Risk and Liquidity teams, contribute to portfolio segmentation, KPIs and scorecards, and drive data-quality improvements while

Qualifications

• Bachelor’s degree in a quantitative, technology, finance or business-related field.
• Two to five years of relevant experience in data analytics, business intelligence, banking, treasury, finance.
• Proficiency in SQL, Python, Power BI or a comparable visualization tool, and Excel.
• Knowledge of data management practices, with a focus on quality, reliability and controls.
• Strong analytical, problem-solving and communication skills, with the ability to collaborate across teams and manage competing priorities.
• Knowledge of banking, treasury, deposits, liquidity, FTP or balance-sheet management is an asset; a strong interest in developing this expertise is essential.

Responsibilities

• Build and maintain dashboards and analytical tools that monitor deposit volumes, mix, pricing, profitability, stability, concentration and performance against plan.
• Prepare, reconcile and validate data from multiple sources; define business rules and document data lineage so reporting is reliable, repeatable and well controlled.
• Use SQL, Python or other programming tool and business intelligence tools to automate recurring analysis, streamline processes and improve the speed and scalability of reporting.
• Support deposit forecasts, scenario analysis, client pricing and business cases.
• Identify trends, anomalies and performance drivers, then translate the findings into concise recommendations.
• Partner with business lines and Data teams to translate business questions into practical analytical solutions.
• Help develop portfolio segmentation, key performance indicators and scorecards that track execution of deposit initiatives and the Bank's broader deposit strategy.
• Contribute to ad hoc analysis, resolution of data-quality issues and continuous improvement of the team's analytical framework and controls.

Skills

SQL

Python

Power BI

Excel

Data management

Analytical thinking

Communication

Team collaboration

Education

Bachelor’s degree in quantitative, technology, finance or business-related field

Tools

Power BI

Excel

Job description

Area(s) of interest: Capital Markets and treasury

Location(s): Montreal

A career as an Associate, Data Analytics within the Deposit Solutions team at National Bank of Canada Capital Markets (NBCCM) means using data, technology and business insights to support the Bank's deposit strategy. You will transform complex data into clear insights, scalable tools and decision-ready reporting for Global Funding & Treasury and internal stakeholders across the Bank.

Working closely with business lines, Finance, Risk, and Liquidity teams, you will help strengthen how we forecast, monitor and manage deposits evolution. This is an opportunity for an early-career professional to build strong banking and treasury expertise while contributing to visible, bank-wide priorities.

Your Job

• Build and maintain dashboards and analytical tools that monitor deposit volumes, mix, pricing, profitability, stability, concentration and performance against plan.
• Prepare, reconcile and validate data from multiple sources; define business rules and document data lineage so reporting is reliable, repeatable and well controlled.
• Use SQL, Python or other programming tool and business intelligence tools to automate recurring analysis, streamline processes and improve the speed and scalability of reporting.
• Support deposit forecasts, scenario analysis, client pricing and business cases.
• Identify trends, anomalies and performance drivers, then translate the findings into concise recommendations.
• Partner with business lines and Data teams to translate business questions into practical analytical solutions.
• Help develop portfolio segmentation, key performance indicators and scorecards that track execution of deposit initiatives and the Bank's broader deposit strategy.
• Contribute to ad hoc analysis, resolution of data-quality issues and continuous improvement of the team's analytical framework and controls.

Your Team

Within Global Funding & Treasury, the Deposit Solutions team supports the development and execution of NBCCM's bank-wide deposit strategy. The team works at the intersection of Treasury, funding, data and the business lines, with a focus on deposit growth, quality, pricing, profitability and balance-sheet resilience.

You will join a proactive and results-oriented team and collaborate with experienced professionals across the Bank. This role reflects our development approach: providing broad exposure to Treasury, Capital Markets and the Bank’s main business lines, supported by coaching and progressively greater ownership. You will contribute to a key funding priority, see the direct impact of your work on business decisions, and build a distinctive combination of data, business and balance-sheet expertise. Curiosity, rigour and a willingness to challenge and improve existing approaches will be important to your success.

Prerequisites

• Bachelor’s degree in a quantitative, technology, finance or business-related field.
• Two to five years of relevant experience in data analytics, business intelligence, banking, treasury, finance.
• Proficiency in SQL, Python, Power BI or a comparable visualization tool, and Excel.
• Knowledge of data management practices, with a focus on quality, reliability and controls.
• Strong analytical, problem-solving and communication skills, with the ability to collaborate across teams and manage competing priorities.
• Knowledge of banking, treasury, deposits, liquidity, FTP or balance-sheet management is an asset; a strong interest in developing this expertise is essential.

Languages:

Reason to require this language: you will need to serve clients who speak a language other than French regularly.

Skills

Press space or enter keys to toggle section visibility

Communication Critical Thinking Diversity & Inclusion Driving Results Emotional Intelligence Information Analysis Teamwork Accountability Client-focused Empathy Initiative Learning Agility Resiliency Humility

In addition to competitive compensation, upon hiring you’ll be eligible for a wide range of flexible benefits to help promote your wellbeing and that of your family such as:

• Health and wellness program, including many options
• Employee Share Ownership Plan
• Employee and family assistance program
• Preferential banking services
• Involvement in community initiatives
• Virtual sleep clinic

We have an offer that keeps up with trends as well as your needs and those of your family.

Our dynamic work environments and cutting-edge collaboration tools foster a positive employee experience. We value employees’ ideas. Whether through our surveys or programs, regular feedback and ongoing communication are encouraged.

Making a bold move in a people-first environment

We’re a bank on a human scale that stands out for its courage, entrepreneurial culture, and passion for people. Our mission is to have a positive impact on people’s lives. Our core values of partnership, agility, and empowerment inspire us, and inclusion is central to our commitments. We aim, wherever possible, to provide a barrier-free and accessible environment to all employees.

We strive to provide accessibility measures throughout the recruitment process within the limits of our available resources. If you require accommodations, feel free to let us know during our initial conversations. We welcome all candidates! What can you bring to our team?

Why work at National Bank?

For an environment that supports your career path

There are many varied opportunities for you to progress and develop, and move ahead in your career. This includes on-the-job learning and training, co-development and pairing with other employees, professional support and mentoring, internal career days or discussion forums with our leaders.

For an inclusive and diverse environment

We foster inclusion in an environment where each person’s unique qualities, whether visible or invisible, are celebrated and valued. We welcome all candidates! What can you bring to our team?

National Bank of Canada 2.96K subscribers