Requisition ID: 272368

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

The Manager, Data Engineering 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:

• 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
• Design enhancements to AF Datamart to support the business line and work with IT&S to test and implement these solutions, for processes such as pricing, planning, amortization, subvention billing, rate blending, etc.
• Provides advice, recommendations and support to AF team members with regards to issues and opportunities related to manufacturer subvention invoicing process and other reporting processes.
• 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.
• 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.
• 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.
• 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.
• Supports implementation and maintenance of Business Intelligence analytics and reporting solutions for various user groups within and outside AF, fully leveraging various platforms (Power BI, Python, etc.)

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

• 5-10 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 Apache Hive, Cisco Tidal scheduler, SQL, DBeaver, MS Access and Excel is required
• Experience with Google Cloud Platform / Big Query will be a significant asset
• Knowledge of data management, aggregation, and analysis techniques
• Understanding of systems modelling and development methodologies, databases, query structure, data structure and data extraction.
• A deep understanding of Automotive Finance’s structure, information systems and strategies, coupled with strong relationships across the network is essential
• Knowledge of in Power BI will be an asset
• University degree in computer science, engineering, business or similar field is required

  What’s in it for you?

• The opportunity to join a forward-thinking organization where you are surrounded by a collaborative team of innovative thinkers.
• A competitive compensation and comprehensive benefits plan.
• An organization committed to making a difference in our communities– for you and our customers.
• You can expect to be recognized and rewarded for high-performance. You’ll be supported by leadership through meaningful development conversations that enable faster advancement and internal training to support your growth and development.
• You’ll receive clear, transparent criteria to progress in your career.

  Working Conditions

• Work in a standard office-based environment; non-standard hours are a common occurrence.

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.