SQL Server ETL Developer (SSIS)

Job Description

Job Description

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 .
• 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 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

You don’t 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.