Database Architect

   Requisition ID: 245190Join 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 team’s 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 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 contributes to an inclusive work environment. Comply with Scotiabank’s 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 setsProvide 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?Bachelor’s Degree in Computer Science or Mathematics or Statistics. Proven working experience with DataStage, ETL systems. Hadoop Systems/Apache HIVE HQL, Oracle, SQLTechnical expertise regarding data models, data mining, segmentation techniques, and Machine learning. Willing to learn or a fast learnerCoding/ Technical mindset with Wokring knowledge of at least one or more technologies (DataStage/ETL, Hadoop, Oracle, SQL, JavaScript, Java, .NET, 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 budgetingStrong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy What's 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.