Data Engineer SSIS Developer

Job Title:

Data Engineer SSIS Developer Location:

Rosemont, IL (Hybrid)

Duration:

6 Months Job Description We are looking for an experienced Data Engineer / SSIS Developer with strong expertise in SQL Server, SSIS, ETL/Data Warehousing, and Azure DevOps. The ideal candidate should have hands-on experience building scalable ETL/ELT pipelines, optimizing SQL queries, and implementing enterprise-level data warehouse solutions. Required Skills SSIS (SQL Server Integration Services) SQL Server

ETL / ELT

Development Data Warehousing (DWH) T-SQL Azure DevOps Python Star Schema / Snowflake Schema Query Optimization ODS, Data Marts, Staging Roles & Responsibilities Develop and maintain Batch ETL/ELT processes using SQL Server and SSIS. Design and build data pipelines for ODS, Staging, Data Warehouses, and Data Marts. Write and optimize complex SQL queries, stored procedures, and T-SQL scripts. Implement Data Warehouse solutions using Star Schema and Snowflake Schema models. Perform large-scale data processing and query optimization. Build and support CI/CD pipelines using Azure DevOps. Implement audit, balance, and control mechanisms in data solutions. Ensure high-performance and scalable data integration processes. Mandatory Skills 3+ Years of SSIS Development Experience Strong SQL Server & T-SQL Experience ETL/Data Warehousing Experience Azure DevOps Exposure Python Knowledge Data Modeling Concepts Preferred Skills CI/CD Pipeline Experience Reporting & Analytical Data Solutions Performance Tuning Experience