Requisition ID: 104031Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
The Team
The Transformation Office plays a critical role in enabling Enterprise Technology to deliver against its mission to bring innovation and value to the Bank with confidence and reliability, by acting as a catalyst for Risk Management across the division.
The Role
Analyze data needs and produce an effective database system to meet the needs.
Some of the Key Accountabilities include:
Database Architect
Data Modeling
Schema design
PL/SQL code development
SQL query tuning
What You Will Bring to Succeed
BSc degree in Computer Science or relevant information technology field
10 Years Database Development (Oracle PL/SQL development, MS SQL Server etc.)
7 Years Data Modeling/Data Architect/Data Integration/Data Interface/Database Design
7 Years Database/SQL tuning
7 Years experience with data models in ERP (EBS, PeopleSoft, etc.) or CRM (Siebel, SFC, etc.) or other large OLTP applications
7 Years experience with data models in large Data Warehouse or OLAP (Essbase/SSAS/Oracle OLAP) system.
Excellent verbal and written communication skills
An ability to understand front-end users requirements and a problem-solving attitude
Excellent analytical and organization skills
Nice to have:
Hands on experience of ETL tools (ODI, Data Stage, Informatica, SSIS)
Hands on experience with Business Intelligence tools (OBIEE, PowerBI, Tableau)
Solid Knowledge of Web Services/XML/SOAP/REST/API
Experience with Linux shell scripting.
The Workplace
We are technology partners who help the business transform how our employees around the world work
We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!
You’ll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
We foster an environment of innovation and continuous learning
We care about our people, allowing them to design how they work to deliver amazing results
We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation
Scotiabank
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. 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.
Is this Role not the Exact fit?
Sign up to stay in touch; well let you know when we have new positions on the team.
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.