Associate Data Engineer - Scotiabank, Toronto

AI Summary

This Associate Data Engineer role at Scotiabank in Toronto focuses on supporting enterprise data and server infrastructure. Key responsibilities include managing software lifecycles, leading infrastructure upgrades, and providing production support for data pipelines. Candidates require at least five years of experience with complex data and server infrastructure, strong SQL Server expertise, and familiarity with Power BI.

About the Role at Scotiabank

As an Associate Data Engineer within Scotiabank's Data Engineering Team, you will contribute significantly to the overall success of GOCT Solution Architecture & Engineering. This role involves providing essential support and maintenance for the enterprise server infrastructure within Microsoft environments, ensuring high availability, system stability, and strict alignment with Scotiabank's enterprise standards. A core aspect of your work will be to manage end-to-end software lifecycle activities, including vulnerability remediation, patching, and software currency upgrades, to keep all servers secure and compliant with internal policies and governing regulations. You will also lead and support critical infrastructure upgrade and migration initiatives, including SQL Server version upgrades to Microsoft-supported platforms, ensuring minimal business disruption across the organisation. This position requires conducting thorough server and infrastructure security assessments to identify potential risks, evaluate exposure, and collaborate closely with security teams to implement effective remediation and control measures. Furthermore, you will configure and maintain enterprise connectivity components such as ODBC drivers, data adapters, and integration tools to ensure reliable data access across various systems, supporting the broader business intelligence needs. The role also includes providing crucial production support for enterprise data pipelines and ETL processes, including proactive monitoring of daily jobs to ensure successful and timely execution. You will troubleshoot and resolve production incidents, ETL failures, and data issues by working closely with development and support teams to restore service quickly and prevent recurrence, including managing deployment activities and change requests for application and infrastructure migrations across Development, UAT, and Production environments with proper controls. Support for cloud and hybrid data platforms, including Azure Data Factory pipelines and Power BI Report Server, handling deployments and troubleshooting, is also a key responsibility. Ensuring compliance with data governance and security policies by managing SQL Server access controls, conducting PII and risk assessments, and supporting application portfolio management and ServiceNow processes is paramount.

What You'll Bring to the Team

To excel in this Associate Data Engineer position, you will bring a robust background of at least five years of experience supporting and maintaining complex data and server infrastructure, specifically enabling data analytics and business intelligence reporting. Your technical expertise should be strong in SQL Server, SSIS, and T-SQL, with extensive hands-on experience in ETL development and troubleshooting. Proven experience supporting enterprise data infrastructure and servers is essential, including a solid track record in production support, issue resolution, and maintaining system security and stability. Familiarity with the ServiceNow incident management system is also a required experience. You should possess experience with reporting tools such as Power BI Report Server, Power BI Services, and Power BI Desktop, demonstrating your ability to work with various data visualisation platforms. Exposure to Azure Data Factory pipeline development and deployments is considered an added advantage, showcasing your adaptability to cloud technologies. While not mandatory, knowledge of Canadian banking systems, particularly within Retail and International Business Banking, is considered a valuable asset for this role. A good understanding of the software development lifecycle, testing, and evaluation practices, alongside familiarity with data warehousing concepts and methodologies, will be crucial for your success. Excellent verbal and written communication skills are also vital for collaborating effectively with various teams and stakeholders across the enterprise.