This job board retrieves part of its jobs from: Fort Saskatchewan Jobs | Mississauga Jobs | Work From Home

Canadian Jobs Board for Customer Service!

To post a job, login or create an account |  Post a Job

   Customer service jobs   

Looking to progress on your career as customer representative? Here we are!

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

Manager, ETL Business Profitability & Decision Support


This is a Full-time position in Vancouver, BC posted July 2, 2021.

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

The Manager is required to provide technology guidance, project delivery and product support for the PISCO application.

PISCO is a network of models spanning 17 countries and calculates profitability by segment, product and channel as well as providing insights into volumes, revenues and costs.

The incumbent will have at least 7 years of progressive IT experience, preferably in the financial services industry, and the ability to manage multiple projects concurrently.

The incumbent should be considered a specialist in the Microsoft SQL Server suite of products and strong knowledge of SAS.

They should also have a strong Project Management & Technical Support background.

The individual must thrive on challenge, be proactive, dynamic and demonstrate initiative.

The incumbent ensures delivery of technically complex solutions for PISCO in order to get a better use for this application.

The candidate will be responsible for ensuring standards and best practices around the development of application services and common components.

The incumbent will present the technological solution in relationship to the architecture, design and development.

Key Accountabilities: Run Extraction Transformation Load (ETL) processes of intermediate level of complexity to meet the high availability, data integrity and reliability requirements of the production environment.

The incumbent must have a strong knowledge of the following: Server operational and application platforms: Windows 2016/2017 Database and programming platforms and technologies: MS SQL Server 2016/2017, DTS, SSIS, TSQL, SAS, SAS Macro, VBA, VBScript.

Monitor, assess and evaluate ETL results.

Through various dimensions of analysis, work closely with BIS, IBS and Country teams to develop actionable recommendations to enhance data quality & productivity.

Provides technological support to the existing PISCO processes and any future development that is prioritized Operationalize business rules where appropriate.

Meet Bank policies for data security, privacy and regulatory requirements Keep abreast of applicable technology and best practices and propose cost effective changes.

Oversee data storage and usage in the environments available to Microsoft SQL Server by: optimizing PISCO data architecture optimizing production data processing
• Lead major technological initiatives by conducting or arranging for: project plans, resources & status reports relevant research, analysis and findings solution design & recommendations production of project deliverables implementation
• Document PISCO policies, logic and practices: data architecture data transformation logic Establish and champion quality improvement activities for the department The incumbent is expected to function independently to ensure that the assigned tasks and project objectives are met.

Experience / Education: Undergraduate degree in Computer Science or equivalent work experience Knowledge and skills of data architecture specifically using Microsoft SQL Server 5 to 7 years’ experience in Microsoft SQL Server Knowledge in SAS programming.

Knowledge of Bank GL hierarchy, Finance (EGL) and core banking platforms.

Knowledge of relevant hardware & software tools.

Strong Written and oral communication skills Strong project management skills and ability to multi-task and manage concurrent projects Disciplined in development methodology and familiar with software development technologies and concepts Excellent problem-solving skills have vision and innovative approach to computer-based solutions and ability to convey these ideas.

Must be flexible to adapt to a dynamic environment, make quick and sound decisions under pressure.

Must be reliable, pro-active, results-oriented, customer-focused and attentive to details Hands on/technical knowledge and experience with web-based technologies.

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.