Treasury Data Analytics Associate

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

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