Database Architect with DataStage and ETL

Requisition ID: 245190

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

The role:

Contributes to the overall success of the EDL ingestion team IB Technology in Canada (Supporting CCA region) ensuring specific individual goals plans initiatives are executed / delivered in support of the teams business strategies and objectives. Ensure all activities conducted are following governing regulations internal policies and procedures.

What will you do

Champion a client centric culture to deepen client relationships and leverage broader Bank relationships systems and knowledge.
Create design procedures writing codes performing testing debug trouble shoot technical issues to support EDL ingestions for CCA region.
Responsible for developing implementing and maintenance of data administration policy standards and models.
Develop policies and procedures for database access and usage for the backup and recovery of data
Lead data administration work including creation of data dictionary data security standards data warehouse analysis and technical architect work to support EDL data lake.
Confirm database architecture capabilities to support all EDL ingestions related requirements.
Perform and develop data ingestion and extract request from EDL/Data Lake/Data Stage platform or other data source based on user request.
Collaborate with stakeholders to design data solutions that drive data governance.
Understand how the Banks risk appetite and risk culture should be considered in day-to-day activities and decisions.
Actively pursue effective and efficient operations of their respective areas in accordance with Scotiabanks Values its Code of Conduct and the Global Sales Principles while ensuring the adequacy adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational compliance AML/ATF/sanctions and conduct risk.
Champion a high-performance environment and contributes to an inclusive work environment.
Comply with Scotiabanks IT Risk data standards.

The incumbent is responsible for supporting the following:
Perform and develop data ingestion and extract request from EDL/Data Lake/Data Stage platform or other data source based on user request.
Supporting ad hoc data requirements for regulatory reporting and strategy development for Senior management.
Interpret data analyze results using statistical techniques and provide ongoing support.
Identify analyze and interpret trends or patterns in complex data sets
Provide off hour support for the EDL data related tasks if required.
Good knowledge of Incident Change management process and Service Requests etc.

What do you need to succeed

Bachelors Degree in Computer Science or Mathematics or Statistics.
Proven working experience with DataStage ETL systems. Hadoop Systems/Apache HIVE HQL Oracle SQL
Technical expertise regarding data models data mining segmentation techniques and Machine learning. Willing to learn or a fast learner
Coding/ Technical mindset with Wokring knowledge of at least one or more technologies (DataStage/ETL Hadoop Oracle SQL JavaScript UNIX Python Perl BaSH Spark C/C/C# GCP/Google Cloud technologies etc.); Experience with the usage of version control tools like Bitbucket/GitHub.
Experience working in an agile development environment (Confluence Jira CiAD pipeline Scrum/Kanban)
Experience in creating project estimates and budgeting

Strong analytical skills with the ability to collect organize analyze and disseminate significant amounts of information with attention to detail and accuracy

Whats in it for you

We have an inclusive and collaborative working environment that encourages creativity and curiosity and celebrates success
We provide you with the tools and technology needed to create meaningful customer experiences
Youll get to work with and learn from diverse industry leaders who have hailed from top technology companies around the world
We hire you for your talent not just a job so you can grow with us. Well equip you for success not only in your role but also in your career as a whole
Dress codes dont apply here: being comfortable does
Access to thousands of online and in-person courses so you can hone your current skills or learn new ones
A competitive rewards package that includes a base salary a performance bonus company matching programs on pension and profit sharing paid vacation personal & sick days medical vision and dental and much more

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.