Title:  Manager Data Analytics - MIS

Requisition ID: 243104

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

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

• Managing ETL data operations from end to end, satisfying monthly processing and reporting deadlines with high accuracy. This includes quality assurance and data validation.
• Leading development and maintenance efforts of performance reports and various other core departmental applications to support Canadian Banking’s’s business growth and strategic projects.
• Partnering with stakeholders to lead analytical and investigative tasks.
• Proactively looking for ways to improve and enhance our processing efficiency and accuracy. Adding value to our deliverables for both current and prospective consumers of our outputs.
• Lead other team members and provide guidance. In addition, the incumbent must possess excellent communication skills and will be interacting with various business lines. It is essential that the incumbent is a proactive and a fast learner.
• 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.
• Responsible for designated business processes, system tools, and analyses to ensure that the Canadian Banking Finance meets its current and ongoing business requirements.
• Plan, organize and execute the Canadian Banking Finance MIS projects in accordance with departmental priorities. The incumbent is required to review and refine user requirements and develop effective solutions from existing financial and product systems. The role requires the effective use of programming resources, post-completion reviews, and the identification of problems/issues/opportunities where automation can improve on the provision of data for analytical support, planning, forecasting, expense, and performance measurement.
• Contribute to successful team performance in accordance with the Department’s mandate.  Provide support to other team members and contribute to shared accountability for team objectives.  Participate in cross-functional projects.
• Manage other projects as assigned related to core Canadian Banking Finance responsibilities

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

• Ability to work effectively and diplomatically in a team environment across organizational lines, with excellent written and strong verbal communication skills.
• Solid understanding of the Bank’s Retail, Small Business, and Commercial products, including processes related to business growth and revenue analysis.
• Knowledge of effective controls to ensure accuracy and completeness of MIS data, including user acceptance testing and validation processes.
• Highly organized with demonstrated ability to solve problems, make decisions, and manage multiple priorities under pressure.
• Experience managing end-to-end data operations using multi-dimensional datasets, including:
• 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
• 5+ years of experience with relational database technologies (MSSQL, Hadoop, Oracle)
• Willingness and ability to learn new technologies quickly
• Technical skills that will be considered an asset: SAS, SQL / GCP BigQuery, Mainframe scripting (Bash, Korn), Visual Studio (ASP.NET, C#), VBA, Version Control (GIT / Devops)

What’s in it for you?

• An inclusive & collaborative working environment that encourages creativity, curiosity, and celebrates success!
• We offer a competitive rewards package: Performance bonus, Employee Share Ownership Program, and Pension Plan Matching, Health Benefits from day one!
• Your career matters! You will have access to career development and progression opportunities.

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.