Manager, Data Analytics - MIS - Finance

Scotiabank; Toronto; On-site; CAD 85,000 - 120,000; Full time

Job summary

Scotiabank is seeking a Manager, Data Analytics - MIS - Finance in Toronto to lead data analysis, reporting, and performance measurement within Canadian Banking Finance. You will drive data integrity, ETL processes, and business insights across Retail, Small Business, and Commercial Banking segments.

The role requires strong collaboration, data modeling, and end-to-end project delivery with a focus on MIS data controls and rapid learning of new technologies.

Qualifications

• Experience managing end-to-end data operations using multi-dimensional datasets.
• Proficient with Mainframe (JCL/SAS), ETL, and data warehousing tools.

Skills

Mainframe JCL/SAS

ETL data lifecycle

Data warehousing

Power BI/Excel

Full project lifecycle

Scripting/Programming 5+ yrs

Relational DBs 5+ yrs

Learning new tech

Tools

MSSQL

SSIS

Shell Scripting

SFTP

Hadoop

Hive

GCP

BigQuery

Job description

Select how often (in days) to receive an alert:

Title: Manager, Data Analytics - MIS - Finance

Requisition ID: 274469
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

Purpose

Canadian Banking Finance (CBF) is a divisional finance function providing financial management and analytical support to Canadian Banking Executive Management, as well as to the Business Line management in Retail, Automotive Lending, Small Business and Commercial Banking. The MIS team is responsible for development and support of applications and tools primarily for Canadian Banking in the areas of business analysis, reporting and performance measurement. The team also plays a key role in areas such as Customer Profitability and Regional P&L and Monthly Branch Report (MBR). This is a very dynamic environment and the unit is very team and results oriented. The incumbent must be a capable change agent, ensuring smooth and relevant changes and insightful analysis within Canadian Banking Finance, the business lines and support groups.

Is this role right for you? In this role you will:

• Collaboration & Communication - work effectively and diplomatically in a team environment across organizational lines, with excellent written and strong verbal communication skills.
• Business & Product Knowledge - have a solid understanding of the Bank’s Retail, Small Business, and Commercial products, including processes related to business growth and revenue analysis.
• Data Integrity & Control - knowledge of effective controls to ensure accuracy and completeness of MIS data, including user acceptance testing and validation processes.
• Data Operations & ETL Expertise

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

Experience managing end-to-end data operations using multi-dimensional datasets, including:

• Mainframe (JCL / SAS)
• Data Lifecycle (ETL): MSSQL, SSIS, Shell Scripting, SFTP
• Data Warehousing: Hadoop, Hive (EDL/EDW), GCP
• Data Modeling & Reporting: Power BI, MS Access, Excel
• Full project lifecycle: requirements gathering, analysis, testing, change control, implementation, and BCP.
• 5+ years of experience with scripting or programming languages (Mainframe / SAS / .net / SQL most desired)
• 5+ years of experience with relational database technologies (MSSQL, Hadoop, Oracle)
• Willingness and ability to learn new technologies quickly

Preferred Skills:

• SAS (JCL on mainframe, and PC SAS)
• Mainframe scripting (Bash, Korn)
• SQL/GCP BigQuery

What’s in it for you?

• The opportunity to join a forward-thinking company surrounded by a collaborative team of innovative thinkers.
• A rewarding career path with diverse opportunities for professional development.
• Internal development to support your growth and enhance your skills.
• An organization committed to making a difference in our communities - for you and our customers.
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!

Location(s): Canada : Ontario : Toronto
Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and our communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know.

We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.