Manager, Collections Business Intelligence & Analytics

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

Responsible for the automation & delivery of management reporting and analyses to enable the ScotiaHelps operations teams to make effective decisions to achieve the Bank's credit loss & operations expense plans.

Is This Role Right for You? In this role, you will:

• Responsible for developing and publishing management dashboards for key performance indicators, providing insights to drive improvements in collections effectiveness
• Researches & implements innovative approaches to automate data management, reporting, & data visualization
• Develops & maintains data architecture to enable automation of management reports through SQL Server and Power BI
• Design, develop, and implement data pipelines using Azure Data Factory to ensure efficient and scalable data integration.
• Develop and optimize ETL processes for data extraction, transformation, and loading from various sources into Azure data storage.
• Responsible for delivery of agent productivity & incentive reports
• Oversees production of analyses pertaining to collections performance. Identifies actionable insights to improve collection efforts and recoveries
• Supports strategic initiatives through data sourcing, manipulation, analyses, & visualizations
• Supports stakeholders within collections through analyses on collections effectiveness, communicating trends & value-added insights
• Generates clear analyses & presentations to stakeholders and senior management
• Establishes effective relationships across multiple business and technology partners, including program and project managers to ensure timely delivery of strategic priorities
• Fosters an inclusive, collaborative, and high-performance environment. Implements a people strategy that attracts, retains, develops, and motivates their team

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

• Five years' experience in a collection's operations environment delivering performance reporting
• Strong problem-solving, collaboration, and communication skills
• Experience with SQL Server Elements (SSMS, SSAS, SSIS, SSRS)
• Working knowledge of Azure Services: Azure Data Factory, Azure Data Lake Storage, and Azure SQL Database SQL scripting and Data Modeling
• Experience with reporting & statistical software packages such as SAS, SQL, Power BI and Python
• Experience manipulating large and complex databases.
• Proficient in SQL and scripting languages for data manipulation and transformation.
• Strong understanding of data modeling, data warehousing, and ETL principles.
• Results driven individual with high level of curiosity and ability to dive into details without losing sight of the big picture.
• Exceptional organization skills to prioritize, manage, and implement a variety of competing initiatives, on a concurrent or staggered basis
• A University degree in Economics, Finance, Mathematics, Computer science, or Information technology related discipline.
  

Location(s): Canada : Ontario : North York
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.