Senior Analyst, Business Intelligence Systems

About This Role

This role contributes to the overall success of the Collections department of Scotia Dealer Advantage, ensuring specific individual goals, plans, and initiatives are executed and delivered in support of the team’s business strategies and objectives. You will ensure all activities conducted are in compliance with governing regulations, internal policies, and procedures.

Responsibilities

• Champion a customer-focused culture to deepen client relationships and leverage broader Bank relationships, systems, and knowledge
• Create, review, and maintain/distribute necessary reporting required to achieve key performance indicators, service level agreements, and operational business controls
• Provide analysis of business data using advanced analytics and modelling tools
• Work closely with team members, business partners, and management to clearly understand business and/or data requirements to provide intuitive files/reporting in a user-friendly format
• Develop and maintain complex databases and reporting to support Department needs, including current reporting and future developments
• Prepare reports for trending info/analysis, obtaining and reviewing explanations for discrepancies, and preparing management reports for review which includes analysis and recommendations
• Provide analytical support in the implementation or review of new/existing projects, systems, processes, and technology, as well as assisting in the delivery and implementation of solutions as required
• Actively pursue effective and efficient operations of his/her respective areas, while ensuring the adequacy, adherence to, and effectiveness of day-to-day business controls to meet obligations with respect to operational risk, regulatory compliance risk, AML/ATF risk, and conduct risk
• Champion a high-performance environment and implement a people strategy that attracts, retains, develops, and motivates their team by fostering an inclusive work environment; communicating vision/values/business strategy and managing succession and development planning for the team
• Conduct payment collection activity to provide the Bank with optimal delinquency ratios and loan loss levels by acting in a timely manner to identify the risk associated with all assigned accounts and executing prompt action to minimize loss and secure the Bank’s position
• Conduct timely and constructive collection activity by telephone, letter, text message, e-mail, or other appropriate means

Requirements

• Strong problem-solving, collaboration, and communication skills
• Hands-on experience of SSMS, SQL Server Management Studio and SSIS, SQL Server Integration Services, and SSIS project deployment and SSRS, SQL Server Reporting Services
• Experience with reporting & statistical software packages such as SAS, SQL, report builder, and Power BI