SQL Server ETL Developer

Radiological Society of North America•Oak Brook, IL

About The Position

As a SQL Server ETL Developer, you will design, build, and support the data pipelines and databases that power reporting and analytics across RSNA. Working primarily with SQL Server, T-SQL, and SSIS, you will move and transform data between SQL Server and other source systems, vendor platforms, and file-based feeds, keeping data systems accurate, reliable, and performant. You will own work from requirements gathering and design through testing, deployment, and production support, partnering with analysts and business stakeholders to deliver trusted data. The role offers work at a not-for-profit, mission-based organization focused on its members, with a welcoming and supportive environment and an opportunity to impact patient care. It involves creating solutions for a variety of business needs and working with a team known for longevity, continuous improvement, teamwork, support, and a sense of humor. The position has reasonable working hours and is generally free of evening and weekend work in a hybrid or remote environment. RSNA offers a competitive compensation package, medical and dental benefits, long-term savings benefits, generous time off including a week-long Winter Break, paid parental leave, and training and professional development opportunities. Applicants must be authorized to work in the United States without current or future employer-sponsored work authorization; RSNA cannot provide employment visa sponsorship. RSNA is an equal opportunity employer and makes employment decisions based on business needs, job requirements, and individual qualifications, without discrimination or harassment based on protected characteristics.

Requirements

At least 3 years of hands-on experience developing ETL solutions with Microsoft SSIS.
Strong T-SQL skills, including stored procedures, window functions, CTEs, and complex joins.
Experience tuning query and database performance, including execution plans, indexing, and resolving slow-running or blocking queries.
Solid understanding of relational design and data warehousing, including star schemas and slowly changing dimensions.
Experience monitoring and troubleshooting SQL Agent jobs and production ETL processes.
Familiarity with source control such as Git and structured development, testing, and deployment practices.
Ability to work independently and communicate clearly with non-technical stakeholders.
Bachelor's degree in a related field or equivalent practical experience.
Authorization to work in the United States without the need for current or future employer-sponsored work authorization.

Nice To Haves

SQL Server 2022 or 2025 experience.
Power BI and/or DAX experience.
.NET, Python, and/or PowerShell scripting experience.
CI/CD experience with Azure DevOps or GitHub Actions.
Experience with cloud data services such as AWS or Azure Data Factory.
Experience with SQL-based transformation frameworks such as DBT or SQLMesh.

Responsibilities

Design, develop, and maintain data pipelines that move data from source systems to destinations using SSIS, APIs, scripts, and other tools as needed.
Write and optimize T-SQL stored procedures, views, functions, and queries for reporting and analytics.
Build incremental load patterns, including watermarking, Change Data Capture, and MERGE/upsert, for SQL Server Integration.
Tune performance using execution plans, indexing, Query Store, and package-level optimization.
Design, build, and maintain dimensional data models, including facts, dimensions, and slowly changing dimensions, for the data warehouse and Enterprise Data Marts.
Ensure warehouse and mart data is accurate, consistent, and ready for reporting.
Build data quality checks, logging, error handling, and alerting into ETL processes, including row count reconciliation, data validation rules, and failure notifications.
Monitor and troubleshoot SQL Agent jobs and SSIS executions, resolving failures and data discrepancies.
Manage code in Git and follow team practices for code review, testing, and deployment.
Gather requirements, translate them into technical designs, estimate work, and document it.
Provide production support for data pipelines and databases.