Senior ETL & Data Migration Architect

Quantum Technologies. LLC; Chicago, Northern (IL, KY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Quantum Technologies LLC in Chicago seeks a senior SQL Server professional to design, optimize, and maintain data platforms. You will own T-SQL development, ETL pipelines with SSIS, and data migration projects while implementing HA/DR and performance tuning.

You will also collaborate with stakeholders to ensure scalable, reliable data services and leverage BI tooling for reporting needs.

Qualifications

• 6+ years of experience with Microsoft SQL Server (2016+), TS-SQL development, performance tuning, and query optimization.
• 5+ years designing and implementing ETL pipelines using SSIS and ETL best practices.
• 5+ years in database architecture, data modeling, schema design, and large-scale data migration/conversion projects.
• 4+ years Windows Server (2008+), database platform deployment/administration.
• 4+ years developing automation using Microsoft .NET, including PowerShell scripting, ASP.NET, and C#.
• 4+ years implementing high availability and disaster recovery solutions (Always On, Mirroring, Log Shipping).

Responsibilities

• Lead database design and architecture for enterprise-scale data platforms.
• Design and optimize ETL pipelines and data migrations.
• Implement and maintain HA/DR strategies and performance tuning for SQL Server databases.
• Collaborate with stakeholders to ensure scalable, reliable data services.

Skills

SQL Server

T-SQL

Performance tuning

Query optimization

PowerShell scripting

ASP.NET

C#

Windows Server administration

Data migration

Tools

SSIS

SSRS

Power BI

Git/Azure DevOps

Job description

Quantum Technologies LLC in Chicago seeks a senior SQL Server professional to design, optimize, and maintain data platforms. You will own T-SQL development, ETL pipelines with SSIS, and data migration projects while implementing HA/DR and performance tuning.

You will also collaborate with stakeholders to ensure scalable, reliable data services and leverage BI tooling for reporting needs.