Location: Canada, Ontario, Toronto 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 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, 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. Collaborate with business stakeholders, analysts, and other engineers to ensure high‑quality data infrastructure. Provide insights and recommendations on how to improve data processing, 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. Acquire and enhance knowledge of the division's business strategies, risk management practices, financial markets, instruments, regulatory requirements, and back‑office processes to provide effective business solutions. 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 (T‑SQL, PL/SQL) for writing and optimizing queries, stored procedures, and data transformations (6+ 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). 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. Benefits Diversity, Equity, Inclusion & Allyship – inclusive culture, respect, bias‑free practices, and employee resource groups. Accessibility – commitment to eliminating barriers and supporting accessibility requirements. Competitive rewards program including bonus, flexible vacation, personal and sick days, and benefits starting on day one. Dynamic ecosystem – free tea & coffee, universal washrooms, and collaborative spaces. Equal Employment Opportunity 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. #J-18808-Ljbffr