Sr. ETL/SSIS Developer – Job Description

We are seeking an experienced Sr. ETL/SSIS Developer for a hybrid onsite contract role in Chicago, IL. This is a 6+ month engagement and is open to local candidates only.

The selected developer will play a key role in supporting a new core system implementation and will be responsible for the full data flow lifecycle into the enterprise data warehouse (EDW). This position involves development, testing, documentation, and support of robust ETL processes using SQL Server, SSIS, and advanced SQL/Python programming.

You’ll work closely with data architects and business analysts to ensure timely and accurate movement of data across systems, provide architectural input, and train junior developers on best practices and documentation standards.

Sr. ETL/SSIS Developer – Key Responsibilities

Serve as a senior ETL developer supporting the new core system implementation
Build and manage robust SSIS packages used in the Extract, Transform, and Load (ETL) processes
Develop complex queries and stored procedures in SQL Server to support data warehouse operations
Provide technical guidance on data architecture and EDW design aligned with the Kimball methodology
Maintain and enhance ETL pipelines and ensure end-to-end data integration workflows are reliable and efficient
Design and document data mappings, transformations, and load processes for enterprise-wide reporting needs
Oversee the documentation, security, testing, and deployment processes for all EDW procedures
Coordinate production, development, and sandbox environments and ensure smooth transitions across them
Collaborate with team members in an Agile/Scrum environment to meet sprint goals and resolve issues
Train and mentor junior developers and new team members on ETL standards, documentation, and design

Sr. ETL/SSIS Developer – Required Skills and Experience

7+ years of hands-on experience with SQL Server development
5+ years of experience working with SSIS and ETL development
Proven experience in building and maintaining data warehouses, preferably using Kimball methodology
Strong expertise in SQL programming, including complex joins, indexes, CTEs, window functions, and optimization
Proficiency with Python programming for data manipulation and automation
Familiarity with data modeling principles and ETL testing procedures
Understanding of data governance, version control, and data quality frameworks
Experience in Agile development environments with sprint planning, standups, and retrospectives
Solid verbal and written communication skills for cross-team collaboration

Sr. ETL/SSIS Developer – Preferred Qualifications

Cloud exposure, especially working with Azure, AWS, or GCP in a data pipeline context
Experience integrating SSIS with cloud-based storage, APIs, or third-party systems
Understanding of DevOps for Data, including automated deployments and CI/CD pipelines
Familiarity with BI tools like Power BI or Tableau is a plus
Prior involvement in enterprise-scale data migration or modernization projects

Sr. ETL/SSIS Developer – Work Location and Engagement Details

Location: Hybrid Onsite – Chicago, IL (Local candidates only)
Type: Contract – 6+ months
Engagement: Full-time, Monday through Friday
Environment: Agile team structure, close collaboration with data architects and BI professionals
Start Date: Immediate or as per candidate availability

Sr. ETL/SSIS Developer – Why You Should Apply

Lead mission-critical data flow into a modernized enterprise data warehouse
Be part of a high-performing team modernizing core systems
Gain visibility in a large-scale implementation project
Work in a hybrid environment that allows onsite collaboration and remote flexibility
Competitive hourly rates for experienced SQL/SSIS professionals

Sr. ETL/SSIS Developer – Ready to Apply?

If you are an experienced SSIS and SQL Server developer with a strong background in data warehousing, and you live near Chicago, this is a great opportunity to make an impact. Apply now to join a collaborative team delivering modern, reliable data systems.

Sr. ETL/SSIS Developer – Frequently Asked Questions (FAQs)

1. Is this a remote job?
No. This is a hybrid onsite role in Chicago, IL. Candidates must be local and available for onsite meetings.

2. How much experience is required with SSIS?
You need a minimum of 5 years of SSIS experience and at least 7 years with SQL Server.

3. Is data warehouse experience mandatory?
Yes. Data warehouse development experience is required, preferably using Kimball methodology.

4. What programming languages will I use?
Primarily T-SQL for SQL Server and Python for automation and data handling.

5. Are there cloud projects involved?
Cloud experience is a plus but not mandatory. Familiarity with Azure or AWS is helpful.

6. Will I be working on existing pipelines or building new ones?
Both. You will support legacy processes and help build new pipelines for the core system migration.

7. What tools will I be using?
Mainly SQL Server, SSIS, and possibly tools like Visual Studio, Git, and Data Loader.

8. Do I need to know any BI tools like Power BI?
It is not required, but knowledge of Power BI or Tableau is considered a plus.

9. Will I need to train or mentor others?
Yes. You will help train new staff and junior developers on ETL processes and documentation standards.

10. What is the team structure like?
You will work within an Agile team alongside data architects, BI developers, and QA analysts.

11. Is this a long-term role?
Yes. The contract is initially 6+ months, with potential for extension.

12. Are weekends or overtime expected?
Not typically, but availability during deployment or cutover weekends may be requested occasionally.

13. What kind of environment will I be working in?
A collaborative environment using Agile methodology, with a focus on performance, scalability, and governance.

14. Will there be interviews or coding tests?
Yes. Expect a technical interview and possibly a SQL or SSIS assessment.

15. When does the role start?
We are looking for immediate joiners, but notice periods will be considered for the right candidate.

Explore our Careers Page to see more job openings.

Check out other positions.

Let’s discuss your next career move!

To apply for this job email your details to narayana@absli.com