Senior Manager, Transformation Data Management and Automation (12-month contract)

Scotiabank; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading bank in the Americas is seeking a Senior Manager, Transformation MIS and Data Management in Toronto. This role involves centralizing and automating reporting for International Banking portfolios while ensuring compliance with risk policies. The ideal candidate has extensive experience in data automation, SQL programming, and reporting tools like PowerBI.

Qualifications

• Minimum 5 years data automation and database management experience.
• Minimum 3 years experience with reporting automation leveraging PowerBI data flows.
• Strong proficiency in programming language, such as SQL, SAS, R, Python.

Responsibilities

• Centralize data across multiple sources by designing database tables.
• Design and establish data pipelines to develop and automate data outputs.
• Assist data management and reporting initiatives without compromising standards.

Skills

Data Automation

Database Management

SQL

Python

SAS

Reporting Automation

PowerBI

Education

Bachelor degree in Finance, Economics, Business or related field

Job description

Requisition ID: 227181

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

The Senior Manager, Transformation MIS and Data Management will work closely with the Director, Portfolio Oversight Reporting Management and the Transformation office to centralize and automate reporting requirements to report on the performance of International Banking portfolios across the credit lifecycle by ensuring that monthly portfolio performance reporting is delivered and executed in accordance with Scotiabank’s Risk Appetite and policies framework, governing regulations, guidelines, procedures and best practices across the industry.

Specifically, the individual is responsible for centralizing data across multiple sources by designing database tables, maintaining, and implementing automations required for reporting automation for all aspects of the credit lifecycle from Originations to Collections leveraged for dashboards and decks for executive level consumption. The individual is also responsible for all ETL, job implementations and full end to end automation.

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

• Work closely with local MIS counterparts and the transformation office to identify reporting requirements and alignment of key risk indicator reporting methodology.
• Design and establish data pipelines to centralize different data sources to develop and automate data outputs required for monthly and quarterly reporting.
• Identify, evaluate, review, and align reporting metrics and methodology aligned to reporting requirements established with Transformation office.
• Assist data management and reporting initiatives without compromising standards of risk and internal control. The jobholder will liaise with businesses to foster the understanding and spirit of controls and ensure accurate and objective reporting to Senior Management.
• Design and develop SQL database tables, PowerBI Data Flows, and standardized views to increase operational efficiency, data accuracy, and support the reporting automation of the credit risk lifecycle including originations, portfolio oversight, and collections.
• Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
• Identifies and executes any opportunities that will result in improvements to operational efficiency or accuracy of data and reporting.
• Creates an environment in which their team pursues effective and efficient operations of their respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.

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

• Bachelor degree in Finance, Economics, Business or related field
• Minimum 5 years data automation and database management experience.
• Minimum 3 years experience with reporting automation leveraging PowerBI data flows.
• Ability to manage the consolidation of data across various data sources into a concise, standardized, and automated output.
• Strong proficiency in programming language, such as SQL, SAS, R, Python, etc and managing and automating data flows from PowerBi
• Experience in Credit Risk Reporting across credit lifecycle considered an asset.

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.