Manager, Data Engineering

Scotiabank; Toronto; On-site; CAD 110,000 - 150,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits

Career development

Inclusive culture

Job summary

Scotiabank is seeking a Manager, Data Engineering to lead the Automotive Finance (AF) Data Mart development and operations. You will ensure data integrity, manage data extraction, and support management reporting and forecasting across AF processes.

The role requires 5–10 years in information systems or analytics, with expertise in Hive, SQL, Excel, and BI tools; familiarity with GCP/BigQuery is a plus. Toronto-based with competitive compensation and benefits.

Qualifications

• 5-10 years of experience in information systems management, data analytics, software development or similar field.
• Strong working knowledge of Apache Hive, Cisco Tidal Scheduler, SQL, DBeaver, MS Access and Excel is required.
• Experience with Google Cloud Platform / BigQuery 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.

Responsibilities

• 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.
• Design enhancements to AF Datamart to support the business line and work with IT&S to test and implement these solutions.
• Provides advice, recommendations and support to AF team members with regards to data issues and opportunities.
• Responds to ad-hoc data requests for reports and statistics for all AF stakeholders and manages regular reporting to manufacturers and other AFC stakeholders.
• Manages enhancements to regular daily, weekly, and monthly reports and invoicing processes for all stakeholders, including development and ongoing management of AF databases.
• Manages data extraction and data preparation processes for product pricing, AF management reporting, profit planning, and forecasting.
• Prepares business requirements for the development of software solutions meeting AF needs and participates in implementation of developed solutions.
• Supports implementation and maintenance of BI analytics and reporting solutions for various user groups, leveraging Power BI, Python, etc.

Skills

SQL

Power BI

BigQuery

Hive

Python

Excel

Data analysis

Data modeling

Stakeholder management

Cloud platforms

Education

University degree in computer science, engineering, business or similar field

Tools

DBeaver

MS Access

Apache Hive

Cisco Tidal Scheduler

Job description

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

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

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.

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 our 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.