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 s olid 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

- Visual Studio (ASP.NET, C#), VBA

- Version Control (GIT / Devops)

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 their 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. If you require technical assistance, please click here . Candidates must apply directly online to be considered for this role. 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.