Lead Data Warehouse Engineer - ETL & SQL Mastery

Sonoma Consulting Inc.; Des Plaines (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

A national IT consulting firm is seeking a Lead Data Warehouse Developer for their Des Plaines, IL headquarters. This role involves leading the delivery of ETL and data warehousing solutions, alongside ownership of existing platforms. Ideal candidates will have over 5 years of experience with commercial ETL tools, strong SQL scripting skills, and analytical abilities. A Bachelor’s degree is required, preferably in Computer Science, Math, or Engineering. Experience in Agile environments is a plus.

Qualifications

• Experience with commercial ETL tools, preferably SSIS 2012/2014.
• Expert level coding with SQL and Stored Procedures.
• Hands-on experience with ETL platform architecture and deployment.
• Ability to work in a collaborative or expert role.
• DBA skills with MS SQL Server are preferred.
• Fluent English verbal communication skills required.
• Experience in an Agile environment is desired.

Responsibilities

• Deliver performance-oriented ETL and Data Warehousing technology solutions.
• Act as the technical steward for existing and future ETL platforms.

Skills

Data Warehouse ETL Development

SQL Scripting

Stored Procedure development

C# development

Database Administration

Analytical Skills

Education

Bachelor’s degree in Computer Science, Math, Engineering or MIS

Tools

SSIS 2012/2014

Microsoft SQL Server

Job description

A national IT consulting firm is seeking a Lead Data Warehouse Developer for their Des Plaines, IL headquarters. This role involves leading the delivery of ETL and data warehousing solutions, alongside ownership of existing platforms. Ideal candidates will have over 5 years of experience with commercial ETL tools, strong SQL scripting skills, and analytical abilities. A Bachelor’s degree is required, preferably in Computer Science, Math, or Engineering. Experience in Agile environments is a plus.