Chief Fonctional and Data Analyst

Attendance

Hybrid

Job number

29493

Category

Senior Professional

Status: Permanent

State

Quebec

Type of Contract

Permanent

Country

Canada

Schedule: Full-Time

Full Time / Part Time?

Full-Time

Posting date

17-Nov-2025

Area(s) of interest: Information technology

Location(s): Montreal

A career as a Senior Functional and Data Analyst means taking on a key role in National Bank's technological transformation, to analyze, optimize and evolve business applications and information systems, while working closely with a multidisciplinary team.

This role allows you to actively contribute to our organization through your understanding of user needs, requirements management, and process analysis to ensure functional consistency of the solutions implemented.

Your job

Ensure data quality and integrity, including data evolution management (Slowly Changing Dimension (SCD) vs. Snapshot)
Translate needs into functional requirements and maintain documentation (use cases, diagrams)
Analyze and produce complex SQL queries to support the accounting team
Respond to changing needs, ad hoc requests, resolve technical issues, and offer reliable support to ensure the integrity of the data consumed by the accounting team
Collaborate with the various stakeholders (technical teams, projects, architecture, analysts and production support) to ensure the quality of deliverables and the performance of data delivery processes
Actively participate in corporate projects and optimize data processing.

Your team

IT is more than 2300 specialists who work in an agile, proactive and collaborative manner to seize opportunities, stay on the cutting edge of technology and continuously improve processes.

Within the IT Delivery Management Corporate Services sector in Finance, you will be part of a large team of 6 colleagues and you will report to the Application Director. Our team stands out for its level of maturity, experience and knowledge of the business sector.

We aim to offer you maximum flexibility to promote your quality of life. This is reflected in a hybrid work environment, as well as a flexible and adaptable schedule.

The Bank values continuous development and internal mobility. Our personalized training programs, based on learning in action, allow you to master your craft and develop new areas of expertise. Tools such as the Data Academy, language training, the Harvard Learning Center, and coaching and mentoring support are available to you at all times.

Prerequisites

Computer science degree or equivalent, with 5+ years of experience as a functional analyst (banking environment preferred)
5 years of experience in functional analysis and excellent command of SQL
Good understanding of complex data structures, relational models, and data warehouses
Knowledge of relational databases (mandatory); Oracle and Datastage (assets)
Data integration and problem-solving skills
Familiarity with Agile methodologies and Atlassian tools (Jira, Xray, Confluence)
Excellent interpersonal skills and ability to evolve in a changing environment.

Languages:

French

Skills

Bilingual Communications DataStage Functional Analysis Functional Specifications Atlassian Jira MySQL Problem Solving Teamwork Initiative Learning Agility Oracle Active collaboration Active listening Synthesis Management

Your benefits

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.

* Health and wellness program, including many options

* Flexible group insurance

* Generous pension plan

* Employee Share Ownership Plan

* Employee and Family Assistance Program

* Preferential banking services

* Opportunities to get involved in community initiatives

* Telemedicine service

* Virtual sleep clinic

These are a few of the benefits available to you. 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 actively listen to employees’ ideas. Whether through our surveys or programs, regular feedback and ongoing communication is encouraged.

We're putting people first

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 peoples' lives. Our core values of partnership, agility, and empowerment inspire us, and inclusivity is central to our commitments. We offer a barrier-free workplace that is accessible to all employees. 

We want our recruitment process to be fully accessible. If you require accommodation, feel free to let us know during your first conversations with us. We welcome all candidates! What can you bring to our team?

Come live your ambitions with us!

Apply

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?