Manager, Integrated Systems Solutions [Scotiabank]

Requisition ID: 179768

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

Job Purpose

The Manager, Integrated Systems Solutions is responsible for the management of Automotive Finance (AF) Data Mart used for manufacturer subvention invoicing, manufacturer reporting, AF management reporting, profit planning and forecasting, and pricing. This includes the development, implementation, and ongoing management of all AF databases and data related processes as well as the ongoing analysis and evaluation of AF data mart to determine opportunities for enhanced operational efficiency, new functionality and improved customer satisfaction for all invoicing, reporting, and planning activities. Additionally, the manager will ensure data integrity, help respond to data requests and support other team members on management reporting and business analytics.

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

• Develops, implements, and manages the process of processing billing records and generating invoices and flat files for the manufacturer partners.
• Responds to ad-hoc data requests for reports and statistics for all AF stakeholders as well as manages regular reporting to manufacturers and other needs of the AF Head Office. Manages requests for enhancements to regular daily, weekly, and monthly reports (buying statistics, Loyalty Program, daily/monthly/YTD bookings, etc.) and invoicing processes for all stakeholders, including development, implementation, and ongoing management of AF databases, systems, processes, and report templates used to generate the manufacturer reports based on the requirements from the AF manufacturer partners.
• Ensures integrity of data used for manufacturer subvention invoicing, manufacturer reporting, AF management reporting, profit planning and forecasting, by reconciling data sources and developing quality checks as part of the invoicing and reporting development process.
• Supports implementation and maintenance of Business Intelligence analytics and reporting solutions for various user groups within and outside AF, fully leveraging various platforms (Tableau, Power BI, Python, etc.)
• We'd Love To Work With You If You Have
• Provides advice, recommendations and support to AF team members with regards to issues and opportunities related to manufacturer subvention invoicing process.
• Prepares business requirements for the development of software solutions that meet AF short-, medium-, and long-term business needs for invoicing and reporting processes for manufacturer programs and other AF retail and commercial products. Participates in the implementation of developed solutions within AF. Provides recommendations to the Senior Manager, Business Intelligence and Information Systems on issues pertaining to development and implementation of IT solutions.
• Manages the comprehensive review, analysis and evaluation of AF Data Mart and all processes associated with the business line data, highlighting significant trends and developments and their potential impact on the business line and coordinates with IT&S on operational issues.
• Manages data extraction and data preparation processes for product pricing, AF management reporting, profit planning, and forecasting; works with AF Information Technology partners (EDL and IT&S) to ensure that all required data is correctly captured in the source systems and uploaded into the AF Data Mart.
• Manages the manufacturer subvention invoicing process for all Indirect Auto Manufacturer partners:

Do you have the skills that will enable you to succeed in this role.

• Understanding of systems modelling and development methodologies, databases, query structure, data structure and data extraction.
• 3-5 years of experience in information systems management, data analytics, software development or similar field, preferably in the financial or related industry
• Strong working knowledge of Microsoft Access, SQL, Apache Hive and Excel is required
• A deep understanding of Automotive Finance's structure, information systems and strategies, coupled with strong relationships across the network will be an asset
• University degree in computer science, engineering, business or similar field is required
• Solid knowledge and experience in Power BI / Tableau will be an asset
• Knowledge of data management, aggregation, and analysis techniques
• Master's degree in aforementioned fields preferred

What's in it for you?

• We offer a competitive rewards package: Performance bonus, Employee Share Ownership Program, and Pension Plan Matching, Health Benefits from day one!
• Your career matters! You will have access to career development and progression opportunities.
• An inclusive & collaborative working environment that encourages creativity, curiosity, and celebrates success!

#scotiafinancejobs
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. If you require technical assistance, please click here . Candidates must apply directly online to be considered for this role. 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.