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.

Design, implement, and optimize scalable ETL data pipelines and database solutions using Azure and IBM DataStage. Collaborate with stakeholders to integrate complex data sources and ensure high data quality and performance across enterprise environments.

Requires a Bachelor's degree in Computer Science or Engineering with over 6 years of experience in SQL and data engineering. Proficiency in Azure cloud services and experience with large-scale ETL processes are essential.

• Bonus • Flexible Vacation • Personal Days • Sick Days • Health Benefits

Identified from the job description. Confirm important requirements above.

• SQL
• Azure Data Factory
• IBM DataStage
• ETL
• Azure SQL Managed Instance
• SSIS 2019
• Data Modeling
• Data Warehousing
• Azure Blob Storage
• Git
• Autosys Workload Automation
• CI/CD
• T-SQL
• PL/SQL
• Data Governance
• Performance Tuning
• Allyship
• Pipelines
• Private Banking
• Git (Version Control System)
• Azure Cloud Services
• Azure DevOps
• American Sign Language (ASL)
• Automation
• CA Workload Automation Ae
• Microsoft Azure
• Commercial Banking
• Capital Markets
• Version Control
• Communication
• Computer Science
• Data Processing
• Language Interpretation
• Data Engineering
• Data Extraction
• Dataflow
• Data Infrastructure
• Data Integration
• Extract Transform Load (ETL)
• Data Quality
• Data Security
• Relational Databases
• Database Development
• IBM InfoSphere DataStage
• DevOps
• Document Formatting
• English Language
• Equities
• Spanish Language
• Financial Instrument

• Data & Analytics
• Technology
• Engineering
• Software
• Finance & Accounting
• Integration Engineer
• Data Engineer
• Software Developers
• Database Administrators

Minimum education

Bachelor’s degree

Minimum experience

5+ years

Apply by

Aug 18, 2026

Posting language

English

Working hours

40 hours per week