Hirejobs Canada
Register
Auckland Jobs
Canterbury Jobs
Northland Jobs
Otago Jobs
Southland Jobs
Tasman Jobs
Wellington Jobs
West Coast Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Manager, ETL Business Profitability & Decision Support - Jobs in Toronto, ON

Scotiabank
Job LocationToronto, ON
EducationNot Mentioned
SalaryNot Disclosed
IndustryNot Mentioned
Functional AreaNot Mentioned
Job TypeFull Time

Job Description

Requisition ID: 103255Join 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/2017Database 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 prioritizedOperationalize business rules where appropriate.Meet Bank policies for data security, privacy and regulatory requirementsKeep 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 architectureoptimizing production data processing

  • Lead major technological initiatives by conducting or arranging for:
project plans, resources & status reportsrelevant research, analysis and findingssolution design & recommendationsproduction of project deliverablesimplementation
  • Document PISCO policies, logic and practices:
data architecturedata transformation logicEstablish and champion quality improvement activities for the departmentThe 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 experienceKnowledge and skills of data architecture specifically using Microsoft SQL Server5 to 7 years’ experience in Microsoft SQL ServerKnowledge 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 skillsStrong project management skills and ability to multi-task and manage concurrent projectsDisciplined in development methodology and familiar with software development technologies and conceptsExcellent 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 detailsHands on/technical knowledge and experience with web-based technologies.Location(s): Canada : Ontario : TorontoScotiabank 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.

APPLY NOW

Manager, ETL Business Profitability & Decision Support Related Jobs

© 2021 HireJobsCanada All Rights Reserved