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.