Remote SQL Server ETL Developer — SSIS & Data Warehouse

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

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,