Senior ETL & Data Migration Analyst

Cloud Analytics Technologies, LLC; Chicago (IL); On-site; USD 120,000 - 180,000; Full time

Job summary

Cloud Analytics Technologies, LLC seeks a senior data engineer/DBA to own SQL Server environments end-to-end, from design to migration and performance tuning. You will build robust ETL pipelines using SSIS, implement HA/DR, and partner on cloud migrations with Azure and AWS, while enabling BI reporting with Power BI/SSRS.

The role emphasizes strong stakeholder communication, enterprise-scale data stewardship, and hands-on automation using PowerShell and .NET technologies.

Qualifications

• 6+ years of MS SQL Server experience with enterprise deployments.
• 5+ years with SSIS ETL design and implementation.
• 5+ years in database architecture, modeling, and large-scale migrations.
• 4+ years in Windows Server administration and deployment.
• 4+ years with .NET stack including PowerShell, ASP.NET, C#.
• 4+ years implementing HA/DR solutions (Always On, Mirroring, Log Shipping).
• Experience with cloud DB platforms (Azure SQL, Azure Data Factory, AWS RDS).
• Familiarity with tSQLt and automated DB CI/CD, BI tooling (SSRS/Power BI).
• Strong stakeholder communication and design presentation skills.

Skills

SQL Server

T-SQL

ETL

SSIS

Data modeling

Data architecture

PowerShell

ASP.NET

C#

Always On

Azure SQL

Azure Data Factory

AWS RDS

tSQLt

Power BI

SSRS

Tools

Git

Azure DevOps

CI/CD

Job description

Cloud Analytics Technologies, LLC seeks a senior data engineer/DBA to own SQL Server environments end-to-end, from design to migration and performance tuning. You will build robust ETL pipelines using SSIS, implement HA/DR, and partner on cloud migrations with Azure and AWS, while enabling BI reporting with Power BI/SSRS.

The role emphasizes strong stakeholder communication, enterprise-scale data stewardship, and hands-on automation using PowerShell and .NET technologies.