ETL Data Conversion Analyst

Robotic Technologies Automation; Chicago (IL); Vor Ort; USD 110.000 - 170.000; Vollzeit

Zusammenfassung

ROBOTIC PROCESS AUTOMATION LLC in Chicago is seeking an experienced SQL Server/ETL specialist to design, implement, and optimize large-scale data solutions. The role focuses on SQL Server architecture, T-SQL development, ETL pipelines with SSIS, and high availability strategies.

Ideal candidates have 6+ years in SQL Server, 5+ years in ETL, and a strong background in data modeling, migration, and .NET automation using PowerShell, ASP.NET, and C#.

Qualifikationen

• 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 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.

Kenntnisse

SQL Server

T-SQL development

Performance tuning

ETL with SSIS

Data modeling

Windows Server

PowerShell scripting

ASP.NET

C#

Always On / DR

Tools

Azure Database Administrator Associate

Azure Data Engineer Associate

tSQLt

Jobbeschreibung

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.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.