Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

SQL Server ETL Developer (SSIS)

Full-time

Radiological Society of North America

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 youll design reliable data pipelines integrate data from multiple systems and help ensure our data is accurate accessible and ready for analysis.

Youll have ownership of your work from requirements and solution design through development testing deployment and production support. Youll 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 youll 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 Youll 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 .
  • Design and maintain dimensional data models including fact tables dimensions and slowly changing dimensions.
  • 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 Youll 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.
  • Bachelors 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

You dont need to check every box. If you have strong SQL Server and ETL experience and enjoy building reliable data solutions we encourage you to apply. Apply within our Career Center on our website.

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.

Required Experience:

IC

Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the SQL Server ETL Developer (SSIS) in Oak Brook, IL vacancy
  • $60 - $75 per hour

     ...technologies, cloud data platforms, ETL processes, Master Data...  ...and data validation • Advanced SQL skills for data analysis, reconciliation...  ...languages • Experience with SSIS packages or related ETL...  ...across enterprise platforms • Develop and maintain testing documentation... 
    SSIS
    Full time
    Temporary work
    Flexible hours

    Motion Recruitment

    Chicago, IL
    1 day ago
  •  ...Business Systems Inc. is a quickly developing worldwide System Integrator,...  ....Job DescriptionJob Tile : ETL DEVELOPERLocation : Oak Brook...  ...SUMMARY: The Senior SSIS Developer is a member of the...  ...complex ETL processes using MS SQL Server 2005/2008/2012 (DTS and SSIS)... 
    SSIS
    Temporary work
    Casual work
    Work at office
    Worldwide

    USM Systems

    Oak Brook, IL
    2 days ago
  •  ...Description Job Description Salary is 110k to 130k SQL Server Database Developer (SQL Server, SSIS & SSRS) Design, develop, optimize, and maintain...  ...views. Design, build, and support SSIS packages for ETL processes, including data extraction, transformation,... 
    SSIS

    Phaxis LLC

    Dolton, IL
    23 days ago
  •  ...Description Job Summary: We are seeking a highly motivated Senior SQL Developer with strong technical and analytical skills. Experience in...  ..., VBScript, and JavaScript experience. Experience with ETL, SSIS packages, and workflow/automation tools. Proficiency... 
    SSIS

    Macpower Digital Assets Edge Private Limited

    Chicago, IL
    23 days ago
  • $27 - $42 per hour

     ...delivery of high-impact work. Developing a sense of account leadership,...  ...needs, and retrieve data using SQL or other query tools, while...  ...pipelines, data integration, ETL processes and data management...  ...one of the ETL tools such as SSIS, Talend, Informatica etc. Experience... 
    SSIS
    Hourly pay
    Internship
    Local area
    Immediate start
    Worldwide

    Crowe

    Chicago, IL
    1 day ago
  •  ...seeking an experienced Senior Database Developer for a temporary engagement to...  ....8-10 years of experience in SQL Server development/DBA, data modeling, and...  ...Strong expertise in:Data migration, ETL processes, and integration tools (e.g., SSIS)Data analysis, data quality, and... 
    SSIS
    Temporary work

    Apex Systems

    Chicago, IL
    2 days ago
  • $112.29k - $161.28k

     ...PHM Data Warehouse Developer PHM is the leading health media agency...  ...solutions built on the Microsoft SQL Server and AWS technology stacks. These solutions include ETL, data modeling, data quality assessment...  ...and ETL solutions using SSIS, python and Spark... 
    SSIS

    TEAM One Inc Defunct

    Chicago, IL
    18 hours ago
  •  ...years of experience in Microsoft SQL Server (2016 through current), T-SQL...  ...experience designing and implementing ETL pipelines using SQL Server Integration Services (SSIS) and ETL best practices. 5+...  .... 4+ years of experience developing automation and application... 
    SSIS

    Cloud Analytics Technologies LLC

    Chicago, IL
    27 days ago
  •  ...or history in fully hands-on ETL pipeline end to end. You...  ...Engineers and solutions surrounding developing data pipelines, create...  ...Experience with ETL tool such as SSIS, Talend, DataFlow, ADF or airflow...  ...Reporting and Analysis tools, SQL, and visual analytic... 
    SSIS
    Permanent employment
    Contract work
    Remote work

    3B Staffing LLC

    Chicago, IL
    2 days ago
  •  ...BI DeveloperCGS is seeking a Power BI Developer to join our team in supporting a wide-ranging...  ...5, Microsoft AzureStrong experience in SQL and RDBMS technologiesExperience...  ...ExperienceKnowledge of Azure DevOps (VSTS)ETL, SSAS, and SSIS experienceSSRS Reporting... 
    SSIS
    Work at office

    Contact Government Services LLC

    Chicago, IL
    4 days ago
  •  ...ETL Architect We are seeking an experienced Onsite Lead to manage and drive end-to-end ETL Data Migration activities. The role involves...  ...Experience with ETL tools such as Informatica, Talend, SSIS, or DataStage. Working knowledge of cloud data platforms (AWS,... 
    SSIS

    United IT

    Chicago, IL
    19 hours ago
  •  ...systems and creates blueprints for developing, testing, and maintaining...  ...environments. Utilize SSIS for data extraction and transformation...  ...Data Warehouses and writing ETL processes. 2+ years of...  ...Strong proficiency in Microsoft SQL Server T-SQL, SSIS, and DAX.... 
    SSIS
    Work at office
    Remote work

    Samprasoft

    Villa Park, IL
    2 days ago
  • $90k - $200k

     ...share knowledge with other developers, architects, and our...  ...proficiency with at least one ETL / Data Orchestration...  ...(Azure Data Factory, SSIS, Informatica, Alteryx, Ab...  ...years of experience with SQL or NoSQL database (PostgreSQL, MySQL, SQL server, Oracle, Aurora, Presto,... 
    SSIS
    Work at office
    Remote work
    Visa sponsorship
    Work visa
    Flexible hours

    CapTech

    Chicago, IL
    1 day ago
  • $123k - $169k

     ...escalation point for complex SQL Server performance, replication, availability...  ..., and related SQL Server ETL/data integration...  ...infrastructure roadmap initiatives.Develop, implement, and support enterprise...  ...automation solutions using SSRS, SSIS, Visual Studio, PowerShell, and... 
    SSIS
    Full time

    Sidley Austin

    Chicago, IL
    3 days ago
  •  ...DescriptionUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software...  ...users.Perform Data Migration from SQL Server to Netezza.Plans, coordinates and...  ...and Data Warehouse products5 years ETL experience with SSIS or DataStageTableau experience highly... 
    SSIS
    Full time
    Temporary work
    Casual work
    Work at office
    Worldwide
    Flexible hours

    USM Systems

    Oak Brook, IL
    4 days ago
  •  ...DescriptionUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development...  ...DataStage - strong preference• Basic knowledge of SQL Server 2012 preferred• Basic knowledge of SSIS ETL Tools preferred Job DescriptionPerform physical... 
    SSIS
    Local area
    Worldwide

    USM Systems

    Chicago, IL
    2 days ago
  • $120k - $160k

     ...performance indicators. Collaborate with department heads to develop annual budgets and forecasts. Support project...  ...performance.Design, develop, and implement ETL workflows using SQL Server Integration Services (SSIS) to meet business and data processing needsIntegrate... 
    SSIS
    Full time
    For contractors
    Local area

    Perkins&Will

    Chicago, IL
    2 days ago
  • $130k - $160.8k

     ...Databricks, Azure Data Factory, and Azure SynapseImplement robust ETL/ELT workflows for structured and unstructured financial data...  ...DevOpsSupport migration of legacy data and application solutions (SQL, SSIS, Synapse, custom ETLs) to modern Azure‑native architecturesImplement... 
    SSIS
    Temporary work

    William Blair

    Chicago, IL
    14 hours ago
  • $129.7k - $226.9k

     ...lead a high performance team by attracting developing engaging and retaining team members...  ...medallion architecture PySpark and Spark SQL and Lakeflow Jobs orchestration sufficient...  ...Experience migrating or modernizing legacy ETL onto a lakehouse architecture Experience... 
    Full time
    Temporary work
    For contractors
    Work experience placement
    Worldwide

    Chamberlain Group

    Oak Brook, IL
    4 days ago
  •  ...We are seeking a Senior Oracle Developer to support legacy applications and help with a future migration to the cloud Key Responsibilities...  ..., applications, and enterprise solutions. Write and maintain SQL, PL/SQL, stored procedures, triggers, and database objects.... 

    The Judge Group

    Chicago, IL
    14 days ago
  • $140k - $175k

     ...integrating data from various sources, ETL (Extract, Transform, Load)...  ....• Manage and enhance complex SSIS packages for data integration...  ...data integration processes.• Develop and optimize Databricks...  ...pipelines using Azure DevOps.• Lead SQL Server database optimization and... 
    SSIS
    Full time
    Work experience placement
    Work visa

    Ryan Specialty Group

    Chicago, IL
    2 days ago
  • $99k - $164.8k

     ...Bridge structures) and dimensional models. Develop and optimize Snowflake platform...  ...performance optimization on Snowflake workloads, SQL queries, pipelines, and integrations. Position...  ...ELT frameworks. ~ Proficiency with ETL/ELT and data integration tools such as... 
    Full time
    Temporary work
    For contractors
    Casual work
    Work at office
    Local area
    Remote work

    Kemper

    Downers Grove, IL
    2 days ago
  •  ...DescriptionUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and...  ..., maintain, and administer complex ETL processes using IBM Data Stage· Provide...  ...and system stability· Proficiency in SQL including Joins, Inserts, Updates, Creates... 
    Full time
    Temporary work
    Casual work
    Work at office
    Worldwide
    Flexible hours

    USM Systems

    Oak Brook, IL
    4 days ago
  •  ...external providers, maintaining databases, and developing internal reporting tools. The intern...  ...Strong programming skills in Python and SQL , with experience in data processing,...  ...Data Engineering concepts, including ETL/ELT pipelines, data modeling, data validation... 
    Internship

    Solar Digital Agro LLC

    Chicago, IL
    a month ago
  •  ...• Overall responsibility for leading MDM server development• Hands on working knowledge of...  ...environments.• Assists application developers and business partners in research, problem...  ...systems.• Have hands on exp on MDM.• MS-BI SSIS technology• Excellent Communication skills... 
    SSIS

    System Canada Technologies

    Chicago, IL
    14 hours ago
  •  ...knowledge of Azure Data Factory, Azure Data Lake Storage, Azure SQL, SQL/T-SQL, PySpark, and Spark-based processing. Deep understanding...  ..., GitHub Actions, API integrations, data governance and lineage concepts, and legacy data platforms such as Informatica and SSIS.... 
    SSIS

    Plante Moran

    Chicago, IL
    1 hour ago
  • $150k - $180k

     ...automate complex workflows end-to-end Develop and maintain agent skills discrete,...  ...extend MCP (Model Context Protocol) servers and clients to connect AI agents with...  ...experience with data engineering: pipelines, ETL/ELT, data modeling, SQL and NoSQL databases Proficiency in... 
    Permanent employment
    Full time
    Shift work

    TEKsystems

    Westmont, IL
    14 hours ago
  • $175k - $225k

     ...frameworks, and streaming or event-driven ingestion Expert-level SQL and strong proficiency in Python or another language used to...  ...Working familiarity with the Microsoft data stack-including MSSQL, SSIS, SSAS, SSRS, and Power BI-sufficient to understand and migrate existing... 
    SSIS
    Flexible hours

    Group One Trading

    Chicago, IL
    2 days ago
  •  ...on data modeling, Microsoft tech Stack, SQL Server, Azure, Azure Synapse Analytics, and Microsoft...  ...the design of Extract, Transform, Load (ETL) processes to ensure efficient data...  ...security measures to protect sensitive data. Develop and utilize Structured Query Language (... 
    Permanent employment
    Full time
    Remote work

    Request Technology, LLC

    Chicago, IL
    2 days ago
  • $120k - $140k

     ...will be doingAs a Database Engineer for SQL/Azure Cosmos, you will be responsible for...  ...platforms. You will work with Microsoft SQL Server, PostgreSQL, Azure SQL Database, Azure...  ...database Management tasks. You are a DBA with developer skills and a mindset.Collaboration -... 
    Full time
    Remote work
    Flexible hours
    2 days per week

    CIBC Bank

    Chicago, IL
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to SQL Server ETL Developer (SSIS). Be the first to apply!