Senior Analyst, Business Intelligence Systems

Scotiabank; Toronto; Sur place; CAD 90 000 - 120 000; Plein temps

Résumé du poste

Scotiabank in Toronto is seeking a Senior Analyst in Business Intelligence Systems to drive reporting, analytics and data solutions for the Collections department. You will create and maintain performance reports, work with data partners, and develop complex databases to support business goals.

The role emphasizes compliance, risk management, and a collaborative, high-performance culture within a major banking group.

Qualifications

• Experience creating and maintaining performance reporting to meet KPIs and SLAs.
• Experience with SQL-based data analysis and reporting.
• Two years’ experience in a collections operations environment delivering performance reporting (nice to have).

Responsabilités

• Create, review, and distribute reporting to achieve KPIs, SLAs and regulatory controls.
• Provide analysis of business data using analytics and modelling tools.
• Collaborate with team members and partners to translate business/data requirements into intuitive reports.
• Develop and maintain complex databases and reporting to support department needs.
• Prepare management reports with trends, explanations and recommendations.

Connaissances

SQL & BI skills

SSIS/SSRS

Power BI

Python

SAS

Analytical skills

Communication

Outils

SSMS

SSIS/SSRS

Power BI

Python

SAS

SQL Server

Description du poste

Select how often (in days) to receive an alert:

Title: Senior Analyst, Business Intelligence Systems

Requisition ID: 272689

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

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

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

• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Create, review, and maintain/distribute of necessary reporting required to achieve key performance indicators, service level agreement and operational business controls and achieve SLAs and identified compliance/regulatory 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 user friendly format.
• Develop and maintain complex databases and reporting to support Department needs. This will include current reporting and future developments
• Prepare reports for trending info/analysis, obtaining and reviewing explanations for discrepancies as well as preparing management reports for review which includes analysis and recommendations. This includes providing 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 pursues 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, including but not limited to responsibilities under the Operational Risk Management Framework, Regulatory Compliance Risk Management Framework, AML/ATF Global Handbook and the Guidelines for Business Conduct.
• Champions a high performance environment and implements a people strategy that attracts, retains, develops and motivates their team by fostering an inclusive work environment; communicating vison/values/business strategy and managing succession and development planning for the team.
• Conducts 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; conducting timely and constructive collection activity by telephone, letter, text message, e-mail, or other appropriate means.

Is this role right for you? We’d love to work with you if you have:

• 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, Power BI, and Python (Experience with Python is a nice to have)
• Experience with SAS to SQL code migration • 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
• Two years’ experience in a collection’s operations environment delivering performance reporting is a nice to have

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.