Share this Job

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

Title:  Data Engineer - Hybrid

 

 

 

Requisition ID: 160966

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

 

This is a hybrid position. Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office and from home with the details to be determined based on business needs.

 

The Team

The Retail Credit Risk Management Common Reporting Platform (CRP) is an application that contribute to the overall solution implemented by Scotiabank in response to the BCBS-239 principle regarding compliancy with risk management regulations from OSFI. CRP is a collection of software tools that take data from the Retail Risk Certified Data Store hosted on the Enterprise Data Lake (EDL) and allow the creation of Risk management reports, that are sent quarterly to the Board. Reports generated on the Common Reporting Platform (CRP) fall into three main categories: 1) Critical. These are regulatory reports that go through a validation/annotation workflow process before being sent to the Board for review. 2) Prioritized Canadian and international banking reports.

 

The Role

  • Build complex data management system in SQL Server based on user/application requirements
  • Contributes to the overall success of the Enterprise Technology, Technology & Operations in Canada ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives.  Ensures all activities conducted are following governing regulations, internal policies and procedures.

 

Some of the Key Accountabilities include:

  • Data/Application/Workflow analyzing
  • Data Modeling
  • Database Objects design
  • T-SQL programming
  • Performance tuning

 

What You Will Bring to Succeed

  • BSc degree in Computer Science or relevant information technology field
  • 7 Years SQL Server Database/T-SQL Development/Programming
  • 5 Years Data Modeling/Data Architect/Data Integration/Data Interface/Database Design
  • 5 Years Database/SQL tuning
  • 5 Years experience with data models in ERP or CRM or other large OLTP applications
  • Excellent verbal and written communication skills
  • An ability to understand complex requirements and a problem-solving attitude
  • Excellent analytical and organization skills

Nice to have:

Hands on experience of SSIS, SSAS, Talend, DataStage

Hands on experience with Business Intelligence tools (PowerBI, Tableau, CDM)

Solid Knowledge of Web Services/XML/SOAP/REST/API/Java

 

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; we’ll let you know when we have new positions on the team.

 

#Scotiatechnology

 

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.


Job Segment: Database, Risk Management, Developer, Engineer, Computer Science, Technology, Finance, Engineering