Sr. ETL/SSIS Developer – Hybrid – Chicago, IL (Locals Only) Alrek Business Solut

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!

#J-18808-Ljbffr