SQL Server ETL Developer

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 in SQL Server, T-SQL, and SSIS, you will move and transform data between SQL Server and our other source systems, vendor platforms, and file-based feeds, keeping our data systems accurate, reliable, and performant.
You will own your work from requirements gathering and design through testing, deployment, and production support, partnering with analysts and business stakeholders to deliver data they can trust.
Excellent work-life balance – reasonable working hours, generally no evenings or weekends in a hybrid or remote environment.
A competitive compensation package that includes outstanding medical/dental benefits, incredible long-term savings benefits, generous time off (including a week-long Winter Break), paid parental leave and more.
Training and professional development opportunities.
Design, develop, and maintain data pipelines that move data from various source systems to their destinations using SSIS, APIs, scripts, and other tools as needed.
Build incremental load patterns (watermarking, Change Data Capture, 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 (facts, dimensions, and slowly changing dimensions) for the data warehouse and Enterprise Data Marts, ensuring data is accurate, consistent, and ready for reporting.
Build data quality checks, logging, error handling, and alerting into ETL processes (such as row count reconciliation, data validation rules, and failure notifications), so issues are caught early and resolved before they affect reporting.
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, and document your work.
3+ years of hands-on experience developing ETL solutions with Microsoft SSIS.
~ Experience tuning query and database performance, including execution plans, indexing, and resolving slow-running or blocking queries.
~ Solid grasp of relational design and data warehousing (star schemas, slowly changing dimensions).
~ Experience monitoring and troubleshooting SQL Agent jobs and production ETL processes.
~ Familiarity with source control (Git) and structured development, testing, and deployment practices.
~ Bachelors degree in a related field or equivalent practical experience.

SQL Server 2022/2025 Experience, Power BI/DAX, and/or .Net/Python/PowerShell scripting.
CI/CD (Azure DevOps, GitHub Actions) or cloud data services (AWS, Azure Data Factory).
SQL-based transformation frameworks such as DBT or SQLMesh.
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.
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.