SQL Server ETL Developer (SSIS)

Radiological Society of North America (RSNA)

Oak Brook (IL)

Hybrid

USD 85,000 - 95,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Week-long Winter Break
Generous paid time off
Paid parental leave

Job summary

RSNA is seeking a SQL Server ETL Developer in Oak Brook, IL to build and support data pipelines powering reporting and analytics. You’ll work primarily with SQL Server, T-SQL, and SSIS, designing data solutions from requirements through production support.

You’ll own your work and collaborate with analysts and business teams to deliver scalable, accurate data. This role emphasizes ETL, CDC, MERGE patterns, and solid SQL Server performance tuning.

Qualifications

  • 3+ years of hands-on experience developing ETL solutions using Microsoft SSIS.
  • Strong T-SQL skills, including stored procedures, window functions, CTEs, and complex joins.
  • Experience troubleshooting and improving SQL Server performance using execution plans, indexing, and query optimization.
  • Understanding of relational database design and data warehousing concepts, including star schemas and slowly changing dimensions.
  • Experience monitoring and troubleshooting SQL Agent jobs and production ETL processes.
  • Familiarity with Git and structured development, testing, and deployment practices.
  • Ability to work independently while collaborating effectively with technical and non-technical partners.

Responsibilities

  • Design, develop, and maintain ETL/data pipelines using SSIS, APIs, scripts, and other integration tools.
  • Develop and optimize T-SQL queries, stored procedures, views, and functions supporting reporting and analytics.
  • Build efficient incremental data-load processes using CDC, watermarking, and MERGE/upsert patterns.
  • Optimize SQL Server and ETL performance using execution plans, indexing, Query Store, and SSIS tuning.
  • Build data validation, logging, error handling, reconciliation, and alerting into ETL processes to maintain data quality.
  • Monitor and troubleshoot SQL Agent jobs, SSIS packages, and production data processes.
  • Manage code in Git and participate in code review, testing, and deployment practices.
  • Partner with analysts and business stakeholders to gather requirements and translate business needs into effective technical solutions.
  • Document solutions and contribute to consistent development and data management practices.

Skills

ETL development
T-SQL
Data warehousing
Query optimization
Cross-functional collaboration

Education

Bachelor's degree in a related field

Tools

SSIS
Git
SQL Server

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Business Intel & Data Engineering Active - Regular full-time Oak Brook, IL, US

Salary Range: $85,000.00 To $95,000.00 Annually

RSNA is seeking a SQL Server ETL Developer to build and support the data solutions that power reporting, analytics, and decision-making across the organization.

Working primarily with SQL Server, T-SQL, and SSIS, you’ll design reliable data pipelines, integrate data from multiple systems, and help ensure our data is accurate, accessible, and ready for analysis.

You’ll have ownership of your work from requirements and solution design through development, testing, deployment, and production support. You’ll also partner directly with analysts and business teams to turn their needs into scalable data solutions they can trust.

This is a SQL Server-centric role. ETL is built in T-SQL and SSIS, not Python or cloud-based drag-and-drop tools.

Why Join RSNA?

At RSNA, you’ll combine meaningful, mission-driven work with a supportive environment that values collaboration and work-life balance. You can expect:

  • Work that supports an organization dedicated to advancing radiology and ultimately improving patient care.
  • A collaborative, experienced team that values knowledge sharing and continuous improvement.
  • Opportunities to solve a variety of real-world data and business challenges.
  • A hybrid or remote work environment with generally predictable hours and limited evening or weekend work.
  • Professional development and opportunities to expand your technical skills.
  • Competitive benefits, generous paid time off, paid parental leave, long-term savings benefits, and a week-long Winter Break.
What You’ll Do
  • Design, develop, and maintain ETL/data pipelines using SSIS, APIs, scripts, and other integration tools.
  • Develop and optimize T-SQL queries, stored procedures, views, and functions supporting reporting and analytics.
  • Build efficient incremental data-load processes using techniques such as Change Data Capture (CDC), watermarking, and MERGE/upsert patterns.
  • Optimize SQL Server and ETL performance using execution plans, indexing, Query Store, and SSIS tuning.
  • Build data validation, logging, error handling, reconciliation, and alerting into ETL processes to maintain data quality.
  • Monitor and troubleshoot SQL Agent jobs, SSIS packages, and production data processes.
  • Manage code in Git and participate in code review, testing, and deployment practices.
  • Partner with analysts and business stakeholders to gather requirements and translate business needs into effective technical solutions.
  • Document solutions and contribute to consistent development and data management practices.
What You’ll Bring
  • 3+ years of hands-on experience developing ETL solutions using Microsoft SSIS.
  • Strong T-SQL skills, including stored procedures, window functions, CTEs, and complex joins.
  • Experience troubleshooting and improving SQL Server performance using execution plans, indexing, and query optimization.
  • Understanding of relational database design and data warehousing concepts, including star schemas and slowly changing dimensions.
  • Experience monitoring and troubleshooting SQL Agent jobs and production ETL processes.
  • Familiarity with Git and structured development, testing, and deployment practices.
  • Ability to work independently while collaborating effectively with technical and non-technical partners.
  • Bachelor’s degree in a related field or equivalent practical experience.
Nice to Have

Experience in any of the following would be a plus:

  • SQL Server 2022/2025
  • Power BI or DAX
  • .NET, Python, or PowerShell
  • Azure DevOps or GitHub Actions
  • Azure Data Factory or AWS data services
  • dbt or SQLMesh

The organization is unable to provide employment visa sponsorship for this position. Applicants must be authorized to work in the United States without the need for current or future employer-sponsored work authorization. This includes, but is not limited to, employer-sponsored H-1B, H-1B1, E-3, TN, O-1, L-1, and other employment-based visa classifications, as well as employer-sponsored extensions, changes of status, or transfers where applicable.

The Radiological Society of North America is an equal opportunity employer and prohibits discrimination and harassment of any kind. RSNA is committed to hiring and employing qualified people without regard to race, color, religion, sex, marital status, national origin, age, disability, veteran status, citizenship status, genetic information, sexual orientation, unfavorable military discharge, ancestry, order of protection status, pregnancy, or any other legally protected characteristic. All employment decisions at RSNA are based on business needs, job requirements, and individual qualifications.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Analyst
Business Intelligence Analyst

Radiological Society of North America (RSNA) • Oak Brook (IL)

Hybrid
USD 70,000 - 90,000
Medical and dental benefits
Employer 403(b) retirement plan (10-15
Winter Break
+2
SQL Server ETL Engineer (SSIS) - Hybrid/Remote
SQL Server ETL Engineer (SSIS) - Hybrid/Remote

Radiological Society of North America (RSNA) • Oak Brook (IL)

Hybrid
USD 85,000 - 95,000
Week-long Winter Break
Generous paid time off
Paid parental leave
Business Intelligence Analyst
Business Intelligence Analyst

Radiological Society of North America, Inc. • Oak Brook (IL)

Hybrid
USD 110,000 - 140,000
SQL Developer
SQL Developer

E-Solutions • United States

On-site
USD 90,000 - 130,000
SQL ETL Developer
SQL ETL Developer

Quantum Technologies LLC • Greenwood Village (CO)

On-site
USD 100,000 - 140,000
ETL Developer
ETL Developer

Ensure Data Solutions, LLC • United States

On-site
USD 85,000 - 120,000
SQL Server Developer
SQL Server Developer

Readerlink Distribution Services • Oak Brook (IL)

On-site
USD 115,000 - 140,000
Health plans
Flexible Spending Accounts
Life and Accident Insurance
+4
ETL & Data Integration Engineer (SSIS/SSRS)
ETL & Data Integration Engineer (SSIS/SSRS)

Compunnel Inc. • Aliso Viejo (CA)

On-site
USD 90,000 - 120,000
ETL Developer / Data Integration Professional
ETL Developer / Data Integration Professional

Compunnel Inc. • Aliso Viejo (CA)

On-site
USD 90,000 - 120,000
ETL Team Lead
ETL Team Lead

The Jacobson Group • United States

Hybrid
USD 120,000 - 135,000
Medical insurance
Dental insurance
Vision insurance
+1