Integration Engineer

Requisition ID: 268187

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

Role

Results-driven Integrations Engineer with strong experience in designing, developing, and optimizing data pipelines and database solutions. Skilled in SQL, Azure data services, IBM DataStage, and database development, with a proven ability to build scalable ETL processes, integrate complex data sources, and ensure high data quality and performance. Experienced in developing data models, optimizing queries, and supporting analytics and reporting needs across enterprise environments. Adept at working with large datasets, implementing data governance practices, and collaborating with cross-functional teams to deliver reliable and efficient data solutions

Accountabilities

Data Engineering & Pipeline Development:

• Design, implement, and optimize robust and scalable data pipelines for extracting, transforming, and loading (ETL) data.
• Work with stakeholders to gather requirements and design solutions that align with business goals.
• Build and maintain data pipelines using Azure services and SSIS 2019.

SQL Development:

• Write complex SQL queries for data extraction, aggregation, and transformation.
• Develop and optimize stored procedures, views, and functions to support data processing and reporting.
• Manage and optimize relational databases and large datasets.

DataStage Development

• Create ETL solutions using DataStage
• Expert in DataStage solution conception design and development.

Cloud Data Solutions (Azure):

• Build and maintain cloud-based data solutions using Azure technologies such as Azure SQL Managed Instance (SQL-MI), Azure Data Factory and Azure Blob Storage.
• Leverage Azure tools for data warehousing and integration.
• Optimize data processing and storage costs using Azure resources.

Data Integration:

• Integrate data from various sources (internal and external) / files and databases to ensure seamless data flow within the organization.
• Maintain and monitor the data quality and consistency across all integrated systems.

Collaboration:

• Business stakeholders, analysts, and other engineers to ensure high-

quality data infrastructure.

• Provide insights and recommendations on how to improve data processing and transformation and distribution.

Optimization and Performance Tuning:

• Continuously monitor the performance of data systems and optimize them for speed, scalability, and cost.
• Perform regular database and pipeline performance tuning and troubleshooting.
• Continually acquire and enhance knowledge of the Division's business strategies and policies, risk management practices and methodologies, product offerings, financial markets, financial instruments, regulatory requirements, Back Office processes, and rapidly changing technology to be able to provide effective business solutions and services to the end user business lines.
• Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.

Skills and Experience

• Proven experience as a Data Engineer or similar role. (6+ years)
• Strong expertise in SQL (e.g., T-SQL, PL/SQL) for writing and optimizing queries, stored procedures, and data transformations. (6+ years)
• Proficient in Azure cloud services, including Azure SQL Database, Azure Data Factory, Azure Key Vault, Azure DevOps / BLOB Storage. (5+ years)
• Experience working with large-scale ETL processes and data pipelines. (5 + years)
• Knowledge of data modeling and data warehousing (5 + years)
• Solid understanding of data security and compliance within cloud environments. (4+ years)
• Expertise in IMBs DataStage development (2+ Years)
• Familiarity with version control tools such as Git. (5+ years)
• Ability to work in a collaborative, fast-paced environment.
• Knowledge in Autosys Workload Automation (2+ years)
• Bachelor’s degree in Computer Science, Engineering, or related field.
• Experience with DevOps practices, CI/CD pipelines, and automation tools.
• English with Spanish is a plus.
• Strong problem-solving skills and analytical mindset.
• Excellent communication and teamwork skills.
• Ability to prioritize and manage multiple tasks simultaneously.
• Detail-oriented and proactive approach to identifying and resolving issues.

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility - We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.

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.