Requisition ID: 101186Join 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 teams 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 Banks 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 Scotiabanks 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; well 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 Banks 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.