Data Integration Engineer (SSIS)

E-Solutions; Canada; Remote; CAD 99,000 - 108,000; Full time

Job summary

A leading company in IT Services is seeking a skilled Integration Engineer for a remote position. The ideal candidate will have extensive experience in SSIS, SQL, and Python, with responsibilities including managing ETL processes and ensuring data quality. This role demands strong technical expertise in data warehousing and collaboration with business users, making it a critical position for enterprises seeking to enhance their data management capabilities.

Qualifications

• 5+ years of SSIS development experience.
• 5+ years of Python coding experience.
• 5+ years in SQL Server based development.

Responsibilities

• Provide Level 2/3 support of existing ETL processes.
• Monitor and troubleshoot Scheduled ETL jobs.
• Build and optimize data pipelines for quality data ingestion.

Skills

ETL

SQL

SSIS

Python

Data Warehousing

Education

BA/BS degree in an engineering or computer science discipline

Tools

Tidal

Airflow

Snowflake

Databricks Pyspark

Job description

3 days ago Be among the first 25 applicants

Direct message the job poster from E-Solutions

Location : Remote (open for Canada only)

Skills: Strong focus on ETL, SQL, SSIS, Tidal, Airflow

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting and Banking

Referrals increase your chances of interviewing at E-Solutions by 2x

Sign in to set job alerts for “Data Integration Specialist” roles.

Mississauga, Ontario, Canada CA$99,600.00-CA$107,100.00 14 hours ago

Release Engineer | North America | Canada | Europe | Fully Remote

Contract Opportunity at BrightCat Data: Data Engineer (Remote, 6–8 Week Project)

Data Quality Analyst (Fraud Investigation)

Part-time Data Quality Analyst (Fraud Investigation)

Freelance Data Analyst (Python) - AI Trainer

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.