Database Architect with DataStage and ETL

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

Job summary

A leading bank in the Americas is seeking a Database Architect to contribute to the success of the EDL ingestion team. The role involves designing procedures, supporting data ingestion, and ensuring compliance with regulations. Candidates should have strong analytical skills and the ability to manage data effectively. Join a collaborative environment where creativity and career growth are encouraged, and enjoy a competitive rewards package including salary, bonuses, and benefits.

Benefits

Collaborative working environment

Access to online and in-person courses

Competitive rewards package

Flexible dress code

Qualifications

• Strong analytical skills to collect, organize, analyze, and disseminate information.
• Ability to support data requests based on user needs.
• Experience with database architecture in data administration.

Responsibilities

• Champion a client centric culture to deepen client relationships.
• Create design procedures, write code, and perform testing.
• Lead data administration including data dictionary creation.

Skills

Strong analytical skills

Attention to detail

Ability to analyze complex data

Job description

Title: 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.

Overview

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 team’s business strategies and objectives. Ensure all activities conducted are following governing regulations, internal policies and procedures.

Responsibilities

• Champion a client centric culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Create design procedures, write code, perform testing, debug and troubleshoot technical issues to support EDL ingestions for the 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 ingestion related requirements.
• Perform and develop data ingestion and extract requests 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 Bank’s 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 Scotiabank’s 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 contribute to an inclusive work environment.
• Comply with Scotiabank’s IT Risk data standards.
• Support data ingestion and extract requests from EDL/Data Lake/Data Stage platform or other data sources based on user requests.
• Support 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.

Qualifications

What you need to succeed?

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

Benefits

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.
• You'll 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. We’ll equip you for success not only in your role, but also in your career as a whole.
• Dress codes don't 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.