Senior ETL & Data Migration Engineer - SQL Server

Valiant Technologies LLC; Chicago (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

Valiant Technologies LLC in Chicago, IL is seeking an experienced SQL Server professional to lead data design and ETL initiatives. You will optimize T-SQL, implement SSIS pipelines, and drive database architecture for large-scale migrations.

The role requires strong Windows Server administration, .NET skills, CI/CD with Git/Azure DevOps, and experience with BI tools like SSRS and Power BI. Equal-opportunity employer in a dynamic environment.

Qualifications

• 6+ years in Microsoft SQL Server with T-SQL, performance tuning and query optimization.
• 5+ years designing SSIS ETL pipelines and ETL best practices.
• 5+ years in database architecture, data modeling, and large-scale migrations.
• 4+ years Windows Server administration and DB deployment.
• 4+ years .NET stack development (PowerShell, ASP.NET, C#).
• 4+ years implementing SQL Server HA/DR (Always On, Mirroring, Log Shipping).
• 4+ years of equivalent education/experience/military background.
• Familiar with tSQLt or similar TS unit testing and CI/CD with Git/Azure DevOps.
• Experience with BI tooling (SSRS, Power BI) and data governance.

Responsibilities

• Collaborate with stakeholders to design data solutions for enterprise needs.
• Develop and optimize SQL Server-based solutions and ETL workflows.
• Implement and maintain high availability and disaster recovery.
• Lead data migration and conversion projects at scale.
• Deliver BI reporting and governance across teams.

Skills

SQL Server

T-SQL

Performance tuning

Query optimization

ETL design

Data modeling

Database architecture

Windows Server

PowerShell

C#

ASP.NET

HA/DR implementation

Git/Azure DevOps

BI tooling

Education

4+ years of equivalent education/experience

Tools

SSIS

SSRS

Power BI

Azure Data Factory

Azure SQL

AWS RDS

tSQLt

Git

Azure DevOps

Job description

Valiant Technologies LLC in Chicago, IL is seeking an experienced SQL Server professional to lead data design and ETL initiatives. You will optimize T-SQL, implement SSIS pipelines, and drive database architecture for large-scale migrations.

The role requires strong Windows Server administration, .NET skills, CI/CD with Git/Azure DevOps, and experience with BI tools like SSRS and Power BI. Equal-opportunity employer in a dynamic environment.