Finance Jobs Toronto

Scotiabank

Financial Analyst

Job Description

Job Purpose:

  • The Analyst, Business Intelligence Systems is responsible for administering subvention and performance reporting for the Automotive Finance OEM programs offered by Automotive Finance(AF) business line, and for providing support and service to AF management team on all matters related to AF data, data sources, and data extraction processes.

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

  • Responsible for subvention program performance reporting process for all Automotive Finance partners and customers:
    • Prepares and distributes subvention program reports (buying statistics, Loyalty Program, daily/monthly/YTD bookings, etc.) to all stakeholders
    • Responds to manufacturer representative inquiries on discrepancies and irregularities on manufacturer subvention program reports
    • Reviews manufacturer subvention program reports for consistency and accuracy, and provides recommendations to Manager, Integrated Systems Solutions on improving these reporting
  • Responsible for operating internal reports including for Audit, Finance and Risk Management
  • Responsible for the manufacturer subvention invoicing data preparation for all Automotive Finance partners (new loans, CPO, lease and sub-prime):
    • Prepares the subvention invoicing data and flat files for the manufacturer partners
    • Assists Senior Analyst, Business Intelligence and Information Systems and Senior Analyst, Finance with manufacturer representative inquiries and disputed subvention amounts
  • Assists the administration and maintenance of AF and DMS databases used for manufacturer invoicing, manufacturer and AF management reporting processes, provides recommendations to the Manager, Integrated Systems Solutions on solutions to improve processes, makes changes to Access database scripts to accommodate manufacturer’s requests for changes in manufacturer reporting/invoicing
  • Assists the analysis of integrity of data used for manufacturer subvention invoicing and manufacturer reporting including periodic reconciliation of data sources, and provides resolution for data related issues & support to core constituents – AF Management team, Dealer Finance Centers and Canadian Dealer Lease Services Inc.
  • Supports the finance planning team in running and maintenance of access databases to aid regular reporting activities
  • Assists the response to manufacturer representative’s requests for information on invoices, program performance reports, trend analysis, new initiatives/programs and any other data-related inquiries for OEM programs.
  • Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
  • Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
  • Champions a high performance environment and contributes to an inclusive work environment.

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

  • University degree in computer science, engineering, business or similar field is required
  • Database related (MS Access, SQL scripts) work experience preferred
  • Knowledge of and hands-on experience in the database management (design and analysis, SQL statements, macros, data import/export, VBA scripts).
  • Knowledge of business related computer software specifically Access, Excel, PowerPoint and Word
  • Expertise with data analysis and programming
  • Knowledge of financial management concepts and accounting principles
  • Strong customer service attitude and attention to detail

To apply for this job please visit ca.indeed.com.