SQL Server ETL Developer (SSIS)
About The Position
RSNA is seeking a SQL Server ETL Developer to build and support data solutions that power reporting, analytics, and organizational decision-making. The role primarily uses SQL Server, T-SQL, and SSIS to design reliable data pipelines, integrate data from multiple systems, and make data accurate, accessible, and ready for analysis. This is a SQL Server-centric role, with ETL built in T-SQL and SSIS rather than Python or cloud-based drag-and-drop tools. The developer owns work from requirements gathering and solution design through development, testing, deployment, and production support. The role partners directly with analysts, business teams, and other stakeholders to translate needs into scalable data solutions. The work environment is hybrid or remote, with generally predictable hours and limited evening or weekend work. RSNA describes its culture as collaborative and supportive, with knowledge sharing, continuous improvement, professional development, and work-life balance.
Requirements
- At least 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 and collaborate effectively with technical and non-technical partners.
- Bachelor’s degree in a related field or equivalent practical experience.
- Must be authorized to work in the United States without current or future employer-sponsored work authorization; RSNA is unable to provide employment visa sponsorship.
Nice To Haves
- Experience with SQL Server 2022 or 2025.
- Experience with Power BI or DAX.
- Experience with .NET, Python, or PowerShell.
- Experience with Azure DevOps or GitHub Actions.
- Experience with Azure Data Factory or AWS data services.
- Experience with dbt or SQLMesh.
Responsibilities
- Design, develop, and maintain ETL and data pipelines using SSIS, APIs, scripts, and other integration tools.
- Develop and optimize T-SQL queries, stored procedures, views, and functions that support 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 technical solutions.
- Document solutions and contribute to consistent development and data management practices.
Benefits
- Competitive benefits.
- Generous paid time off.
- Paid parental leave.
- Long-term savings benefits.
- A week-long Winter Break.
- Professional development opportunities.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
