Senior ETL & Data Migration Engineer - SSIS & SQL Server

Cloud Hybrid Technologies LLC; Chicago, Northern (IL, KY); Hybrid; USD 90,000 - 140,000; Full time

Job summary

Cloud Hybrid Technologies LLC in Chicago is seeking a senior database engineer to manage MS SQL Server environments, design data models, and lead migrations. You will implement ETL pipelines with SSIS, support HA/DR solutions, and drive automation with .NET, PowerShell, and CI/CD pipelines.

Proficiency across Azure SQL, Azure Data Factory, and AWS RDS, plus BI tools like SSRS/Power BI, will support data governance and stakeholder presentations.

Qualifications

• 6+ years of experience with Microsoft SQL Server (2016–current) including T-SQL development and performance tuning.
• 5+ years designing ETL pipelines with SSIS and ETL best practices.
• 5+ years in database architecture, modeling, schema design, and large-scale data migrations.
• 4+ years Windows Server administration and database deployment.
• 4+ years developing automation with .NET, PowerShell, ASP.NET, and C#.
• 4+ years implementing SQL Server HA/DR (Always On, Mirroring, Log Shipping).
• Certifications such as Azure DB Admin Associate or Azure Data Engineer Associate are a plus.
• Experience with cloud platforms and migration tools (Azure SQL, Azure Data Factory, AWS RDS).
• Knowledge of tSQLt and automated DB CI/CD with Git/Azure DevOps.
• BI tooling and reporting (SSRS, Power BI) and data governance.

Skills

MS SQL Server

T-SQL

Performance Tuning

Query Optimization

Data Modeling

Data Architecture

Schema Design

Data Migration

Windows Server

PowerShell

ASP.NET

C#

Always On

HA/DR

CI/CD

Git

Azure DevOps

Azure SQL

Azure Data Factory

AWS RDS

tSQLt

SSRS

Power BI

Data Governance

Stakeholder Management

Education

4+ years of combined education/experience

Tools

SSIS

PowerShell

Git

Azure DevOps

Azure SQL

Azure Data Factory

AWS RDS

tSQLt

Job description

Cloud Hybrid Technologies LLC in Chicago is seeking a senior database engineer to manage MS SQL Server environments, design data models, and lead migrations. You will implement ETL pipelines with SSIS, support HA/DR solutions, and drive automation with .NET, PowerShell, and CI/CD pipelines.

Proficiency across Azure SQL, Azure Data Factory, and AWS RDS, plus BI tools like SSRS/Power BI, will support data governance and stakeholder presentations.