Lead Data Engineer (etl)

April 6 2021
Industries Bank, Insurance, Financial services
Categories Accounting, Finance, Data analyst, BI, Mining, AI, Data Business Analyst, Forensic accounting, Fraud, Information Technology
Toronto, ON

Requisition ID: 101186

Join the Global Community of Scotiabankers to help customers become better off.

The Role

The Lead Data Engineer contributes to the overall success of the Global Finance & Risk Technology, Technology, Operations and Digital 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 in compliance with governing regulations, internal policies and procedures.

Some of the Key Accountabilities include:

  • 7+ years of experience developing and managing dimensional data warehousing solutions.
  • 5+ years of hands-on experience in ETL and query tools including SAS, T-SQL, SSIS, dbVisualizer and Beeline
  • Expert knowledge of Microsoft SQL Server ecosystem including SSMS, SSIS, SSAS, Data Tools and Visual Studio
  • Experience in Reporting tools including Power BI Report Server and Services, Power BI Desktop
  • Experience in Atlassian Jira/Confluence, GIT, TFS/Azure DevOps
  • Knowledge of International Banking source systems data models and IDR is an asset
  • Excellent communication and presentation skills (written/verbal)
  • University degree in Software Engineering/Computer Science related field

What You Will Bring to Succeed:

  • Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
  • Executes International Banking Caribbean CRM data management strategy. Delivers data driven customer campaign management solution and data analytics support while ensuring data and application IT Risk and governance compliance
  • Identifies talent, builds and manages a high-performance team of developers by providing technical direction of Data Warehouse Lifecycle Methodology and standard development practices.
  • Builds and maintains a strong working relationship with peers across the business lines including key stakeholders in International Retail Products and Marketing, Corporate and Commercial Banking, and Global Risk Management
  • Supports, maintains and enhances International Banking Infor Omni Channel campaign management solution (Epiphany), Customer centric data mart and Caribbean Power BI reporting platform
  • Designs, develops and maintains complex distributed data pipelines, relational databases and API based interfaces with other banking systems and applications leveraging SAS and Microsoft technology stack including SQL Server, SSIS, SSAS as well as Big Data technologies
  • Designs and develops reporting capabilities leveraging Power BI Reporting Server and Analytical SSAS cubes
  • Effectively implements SDLC across the specification, design, build, test, and deployment phases of development. Enables Agile culture and facilitates Scrum and Kanban
  • Understands how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
  • Actively pursues effective and efficient operations of his/her 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.
  • Champions a high-performance environment and contributes to an inclusive work environment.

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.

Location(s): Canada : Ontario : Toronto

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. Our employees are committed to a superior customer experience and use the Bank’s six guiding sales practice principles to ensure they act with honesty and integrity.

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.

Apply now!

Jobs.ca network

#