Lead Data Warehouse Engineer - ETL & SQL

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

Job summary

A leading IT consulting firm is seeking a Lead Data Warehouse Developer for their Des Plaines, IL office. This role is vital for overseeing the company's ETL processes and data warehousing solutions. Candidates must have over 5 years of ETL development experience, strong SQL skills, and a Bachelor's degree in a relevant field. The position requires collaboration in a fast-paced Agile environment. Attractive full-time opportunity with opportunities for innovation in data management.

Qualifications

• 5+ years of Data Warehouse ETL Development experience using commercial ETL tools.
• Expert SQL Scripting and Stored Procedure development skills.
• Hands-on experience leading the architecture and deployment of ETL platforms.
• Collaborative team member and technical expert.
• Production DBA skills with MS SQL Server preferred.
• Strong analytical skills and fluent English verbal communication.
• Experience in a fast-paced Agile environment.

Responsibilities

• Drive the technical design and support of the Enterprise Data Warehouse.
• Optimize ETL packages, Stored Procedures & SQL/C# scripts.
• Support data quality and integrity initiatives.
• Provide off-hours support as necessary.
• Own DBA responsibilities for database upgrades and optimizations.
• Identify new technologies to enhance the Data Warehouse.

Skills

Data Warehouse ETL Development

SQL Scripting

C# Development

Application DBA Skills

Analytical Skills

Agile Environment Experience

Communication Skills

Education

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

Tools

SSIS

Microsoft SQL Server

Job description

A leading IT consulting firm is seeking a Lead Data Warehouse Developer for their Des Plaines, IL office. This role is vital for overseeing the company's ETL processes and data warehousing solutions. Candidates must have over 5 years of ETL development experience, strong SQL skills, and a Bachelor's degree in a relevant field. The position requires collaboration in a fast-paced Agile environment. Attractive full-time opportunity with opportunities for innovation in data management.