ETL Data Conversion Analyst

Machine Learning Technologies, LLC; Chicago (IL); On-site; USD 110,000 - 160,000; Full time

Job summary

Machine Learning Technologies, LLC in Chicago seeks an experienced database professional to design, implement, and optimize SQL Server-based data solutions across on-prem and cloud migrations.

The role requires 6+ years with SQL Server, T-SQL, ETL (SSIS), data modeling, and disaster recovery. Join a team delivering enterprise-scale data platforms and analytics, with opportunities to leverage Power BI and governance practices.

Qualifications

• 6+ years of experience with SQL Server (2016–current) including performance tuning and query optimization.
• 5+ years designing and implementing ETL pipelines with SSIS and ETL best practices.
• 5+ years of experience in database architecture, data modeling, and large-scale data migration projects.
• 4+ years with Windows Server (2008–current) and DB platform deployment/administration.
• 4+ years developing automation and application components using .NET technologies (PowerShell, ASP.NET, C#).
• 4+ years implementing SQL Server high availability and disaster recovery (Always On, Mirroring, Log Shipping).
• 4+ years of equivalent combination of education, experience, or military service.

Skills

SQL Server

T-SQL

ETL development

Database design

Data migration

PowerShell scripting

C#/.NET

Always On/DR

Windows Server

BI tooling

Data modeling

Tools

SSIS

Azure SQL

Azure Data Factory

AWS RDS

Git

Azure DevOps

SSRS

Power BI

tSQLt

Job description

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 SQL Server Integration Services (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.

Experience that would be great to have:

• Certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Data Engineer Associate.
• Experience with cloud database platforms and migration tools (Azure SQL, Azure Data Factory, AWS RDS).
• Familiarity with T-SQL unit testing frameworks (e.g., tSQLt) and automated database CI/CD using Git/Azure DevOps.
• Experience with BI tooling and reporting (SSRS, Power BI) and data governance practices.
• Proven track record in stakeholder management and presenting technical designs to enterprise and client audiences.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.