SQL Server ETL Developer

Radiological Society of North America (RSNA); Oregon; Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical/dental benefits

Winter Break

Paid parental leave

Generous time off

Long-term savings benefits

Job summary

RSNA is seeking a SQL Server ETL Developer to design, build, and support data pipelines and databases powering reporting and analytics. You will work primarily with SQL Server, T-SQL, and SSIS to move and transform data across source systems and file feeds, ensuring accuracy and performance.

You’ll own work from design through deployment, collaborating with analysts and stakeholders. The role emphasizes a balance between work quality and patient-focused mission, with a welcoming environment,

Qualifications

• 3+ years of hands-on ETL development with Microsoft SSIS.
• Strong T-SQL skills including stored procedures, window functions, CTEs, and complex joins.
• Experience tuning queries and database performance (execution plans, indexing).
• Familiarity with data warehousing concepts (star schemas, slowly changing dimensions).

Responsibilities

• Design, develop, and maintain data pipelines moving data between source systems and destinations.
• Write and optimize T-SQL queries for reporting and analytics.
• Build incremental load patterns (watermarking, CDC, MERGE/upsert) for SQL Server Integration.
• Tune performance using execution plans, indexing and Query Store.
• Design and maintain dimensional data models for the data warehouse and marts.
• Implement data quality checks, logging, error handling, and alerting in ETL processes.
• Monitor and troubleshoot SQL Agent jobs and SSIS executions.
• Manage code in Git and follow team practices for review, testing, and deployment.
• Gather requirements and translate into technical designs and documentation.

Skills

ETL development

T-SQL

SQL Server

Performance tuning

Data warehousing

Git

Education

Bachelor's degree

Tools

SSIS

Azure DevOps

Job description

What we’re looking for:

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.

This job might be for you if you're interested in:

• Working at a not‑for‑profit, mission‑based organization that focuses on its members.
• A welcoming and supportive environment that gives you an opportunity to impact patient care.
• 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.
• The challenge of creating new solutions for a variety of business needs.
• An opportunity to work with a team that has longevity at RSNA, a culture of continuous improvement, a true sense of teamwork and support, and a fabulous sense of humor.

What you’ll do:

• 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.
• Write and optimize T‑SQL stored procedures, views, functions, and queries for reporting and analytics.
• 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.

Requirements:

• 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 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.
• Ability to work independently and communicate clearly with non‑technical stakeholders.
• Bachelor's degree in a related field or equivalent practical experience.

Nice to have:

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

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.