Data Integration Engineer (SSIS)

Role : Sr. Data Integration Engineer Location : Ottawa / Toronto (Hybrid) Skills: Strong focus on Snowflake, SQL, SSIS, Python, Data Warehouse, Databricks JD: This position is for an Integration engineer with a background in SSIS, Python, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise. Major Responsibilities: • Provide Level 2/3 support of existing ETL processes. • Monitor and troubleshoot Scheduled ETL jobs, identify and resolve issues or bottlenecks. • Proficient in developing ETL processes in SSIS, Python and SQL (SQL Server / Oracle) • Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process. • Build and optimize data pipelines for efficient data ingestion, transformation and loading from various sources while ensuring data quality and integrity. • Working with structured, semi structured and unstructured data. • Implement best practices for data management, security, and governance. • Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards. Required Skills: • 5+ years SSIS development experience • 5+ years Python coding experience. • 5+ years SQL Server based development of large datasets Additional Skills: • Experience in Financial Services industry • Experience with Enterprise Schedulers / Orchestration platforms such as Tidal, Airflow. • Experience in any cloud data warehouse like Snowflake. • Experience in Data warehousing - OLTP, Dimensions, Facts, and Data modeling. • Experience with Cloud based data architectures, messaging, and analytics. • Experience with developing and deploying ETL pipelines using Databricks Pyspark. Education: • Minimally a BA/BS degree within an engineering and/or computer science discipline • Master’s degree preferred

Provide Level 2/3 support for existing ETL processes and monitor scheduled jobs to resolve bottlenecks. Develop and optimize data pipelines using SSIS, Python, and SQL while ensuring data quality and security.

Requires over 5 years of experience in SSIS development, Python coding, and SQL Server-based development with large datasets. A bachelor's degree in engineering or computer science is required, with a master's degree preferred.

Identified from the job description. Confirm important requirements above.

• SSIS
• Python
• SQL
• Snowflake
• Databricks
• Data Warehousing
• ETL
• SQL Server
• Oracle
• Data Modeling
• PySpark
• Tidal
• Airflow
• Data Ingestion
• Data Governance
• Data Pipelines

Minimum education

Bachelor’s degree

Minimum experience

5+ years

Apply by

Aug 15, 2026