Requisition ID: 101868Join the Global Community of Scotiabankers to help customers become better off.
Team
Canadian Banking Analytics: Sales & Channels
Purpose
The Senior Manager will enable the data infrastructure for Canadian Banking Analytics: Sales & Channels (CBA) ensuring business strategies, plans and initiatives are executed / delivered in compliance with internal policies and procedures. The role will be responsible for leading the development and ongoing dev-ops for data pipelines and data assets supporting the CBA group. The role will also coordinate the creation of new enterprise data sources by the Data Office and enable transition of the CBA team to these new data sources. The incumbent will report into the Director, Data Infrastructure
Key Accountabilities
Guides the data architecture for creation of data assets to be used for modelling, BI, Marketing operations and other analytic functions within the scope of Canadian Banking Analytics
Performs data engineering activities to create and maintain the data assets required. Leads the creation of data pipelines and design of ETL work to transform and manage data at scale. Responsible for the orchestration of the data pipelines / ETL processes and monitoring of these processes for accuracy, reliability and timeliness.
Enables the migration of data stores and analytical datasets from the data warehouse and enterprise data lake to global data & analytics platform.
Leads the migration away from SAS as the primary language for data processing to a Python and SPARK based approach.
Executes data management activities to design and build dataset for analytics and bring in data from multiple data platform and environments. Assemble large, complex data sets that meet functional / non-functional business requirements
Executes on data governance activities to ensure good data quality and integrity for critical datasets used by the CBA team across the various analytical use cases.
Responsible for ingesting new/alternative sources of data to generate business value.
Champions a high performance environment and contributes to an inclusive work environment.
Coach and mentor other team members and provide guidance on data management topics in EDL, google cloud environment.
Participate on special project teams as required to support the delivery of strategic Bank initiatives.
Actively pursues effective and efficient operations of his/her respective areas, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational risk, regulatory compliance risk, AML/ATF risk and conduct risk, including but not limited to responsibilities under the Operational Risk Management Framework, Regulatory Compliance Risk Management Framework, AML/ATF Global Handbook and the Guidelines for Business Conduct
Education and Other Requirements
University Degree in Customer Science, Information Technology, Engineering or related fields
Expert ability with data processing language: Python, SPARK (5+ years).
Expert ability with one or more query language ( SQL, PL/SQL, HiveQL, SparkSQL). Advanced SQL skills with experience in querying large and complex data sources and creation of highly optimized and efficient SQL queries.
Hands on experience with Big Data ecosystem tools (e.g. Hadoop, Hive, Spark) and data processing within the EDL for big data data pipelines, architectures & data sets
Expert ability to manage and organize information from data environments, including interpretation of the results for management presentation purposes.
Experience performing root cause analysis for data issues in order to identify opportunities for improvement
Experience with managing / functioning with ETL/ data engineering Dev Ops. Experience with container technologies (Docker) is desirable.
Experience with ETL tools (Informatica, DataStage, Talend, SSIS) is nice to have
Nice to have experience with stream or real time data processing (KAFKA)
Strong written and verbal communication skills
Advanced level of experience with Microsoft Office (PowerPoint, Excel, Access).
Must be flexible to adapt to a dynamic environment, and make quick and sound decisions under pressure.
Must be reliable, pro-active, results-oriented, customer-focused and attentive to details.
Must possess excellent time management and organizational skills in order to deliver initiatives in a timely manner and deal with conflicting priorities and tight deadlines.
Location(s): Canada : Ontario : Toronto
As Canada’s International Bank, we are a diverse and global team. We speak more than 100 languages with backgrounds from more than 120 countries. Our employees are committed to a superior customer experience and use the Banks six guiding sales practice principles to ensure they act with honesty and integrity.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.