SSIS ETL Engineer: Data Integration & Performance

ClinDCast LLC; Chicago (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

A data solutions company in Chicago is seeking an SSIS Developer / ETL Specialist to design and maintain ETL workflows. The ideal candidate will have over 3 years of experience in SSIS development and strong SQL Server skills. Responsibilities include tuning ETL processes, creating complex packages, and collaborating with BI teams for analytics. Understanding of data warehousing concepts and proficiency in Power BI are preferred.

Qualifications

• 3+ years of experience in SSIS development and ETL processes.
• Strong knowledge of SQL Server, T-SQL, and database objects.
• Experience with SSIS performance tuning and troubleshooting.

Responsibilities

• Design and implement complex SSIS packages for ETL from multiple sources.
• Tune SSIS packages and SQL queries for optimal performance.
• Work closely with BI teams to provide data for analytics.

Skills

SSIS development

ETL processes

SQL Server

T-SQL

Data integrity validation

Tools

SQL Server Integration Services (SSIS)

Power BI

SSRS

Job description

A data solutions company in Chicago is seeking an SSIS Developer / ETL Specialist to design and maintain ETL workflows. The ideal candidate will have over 3 years of experience in SSIS development and strong SQL Server skills. Responsibilities include tuning ETL processes, creating complex packages, and collaborating with BI teams for analytics. Understanding of data warehousing concepts and proficiency in Power BI are preferred.