Senior SQL ETL & Data Migration Analyst

Robotic Technologies Automation; Chicago (IL); On-site; USD 110,000 - 170,000; Full time

Job summary

ROBOTIC PROCESS AUTOMATION LLC in Chicago is seeking an experienced SQL Server/ETL specialist to design, implement, and optimize large-scale data solutions. The role focuses on SQL Server architecture, T-SQL development, ETL pipelines with SSIS, and high availability strategies.

Ideal candidates have 6+ years in SQL Server, 5+ years in ETL, and a strong background in data modeling, migration, and .NET automation using PowerShell, ASP.NET, and C#.

Qualifications

• 6+ years of experience in Microsoft SQL Server (2016 through current), T-SQL development, performance tuning, and query optimization.
• 5+ years of experience designing and implementing ETL pipelines using SSIS and ETL best practices.
• 5+ years of experience in database architecture, data modeling, schema design, and executing large-scale data migration/conversion projects.
• 4+ years of experience with Microsoft Windows Server (2008 through current) and database platform deployment/administration.
• 4+ years of experience developing automation and application components using Microsoft .NET technologies, including PowerShell scripting, ASP.NET, and C#.
• 4+ years of experience implementing SQL Server high availability and disaster recovery solutions (Always On Availability Groups, Database Mirroring, Log Shipping).
• 4+ years of equivalent combination of educational background, related experience, and/or military experience.

Skills

SQL Server

T-SQL development

Performance tuning

ETL with SSIS

Data modeling

Windows Server

PowerShell scripting

ASP.NET

C#

Always On / DR

Tools

Azure Database Administrator Associate

Azure Data Engineer Associate

tSQLt

Job description

ROBOTIC PROCESS AUTOMATION LLC in Chicago is seeking an experienced SQL Server/ETL specialist to design, implement, and optimize large-scale data solutions. The role focuses on SQL Server architecture, T-SQL development, ETL pipelines with SSIS, and high availability strategies.

Ideal candidates have 6+ years in SQL Server, 5+ years in ETL, and a strong background in data modeling, migration, and .NET automation using PowerShell, ASP.NET, and C#.