Senior Analyst, Business Intelligence Systems

Scotiabank; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Scotiabank in Toronto, ON is seeking a Senior Analyst, Business Intelligence Systems to strengthen the Collections team. You will design, develop and maintain reporting solutions that support KPIs, SLAs and regulatory controls, using SSMS, SSIS, SSRS, SQL Server and Power BI.

Responsibilities include analyzing business data with advanced analytics, building complex databases, and delivering management reports with actionable insights.

Qualifications

• Strong problem-solving, collaboration and communication skills.
• Hands-on experience with SSMS, SQL Server Management Studio, SSIS, SSRS and deployment.
• Experience with SAS, SQL, Report Builder, Power BI and Python.
• Experience migrating SAS to SQL code.
• Two years’ experience in a collections operations environment delivering performance reporting.

Responsibilities

• Create, review, and maintain/distribute reporting to achieve KPIs, SLAs and compliance controls.
• Provide analysis of business data using advanced analytics and modelling tools.
• Work with team, partners and management to translate requirements into intuitive reports.
• Develop and maintain complex databases and reporting to support department needs.
• Prepare management reports with analysis, trends and recommendations; support projects and process improvements.
• Ensure day-to-day controls and risk/compliance adherence within operational framework.

Skills

SSMS

SSIS

SSRS

SQL Server

Power BI

Python

SAS

SQL

Report Builder

Job description

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

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.

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.