Data Warehouse Developer

Title: Lead Data Warehouse Developer

Location : Des Plaines, IL

Full time

Job Description:

We currently have an excellent career opportunity for a Lead Data Warehouse Developer in our client’s Des Plaines, IL corporate headquarters. Candidates for this role must have a passion for the hands-on delivery of performance oriented ETL and Data Warehousing technology solutions. You will be a crucial facet of our growing Business Intelligence & Analytic Applications organization. This role serves as the technical steward and platform owner of the client’s existing and future Data Warehousing and ETL platforms. The ideal candidate will have a broad set of ETL development, DBA, and data analysis skills with extensive hands-on expertise using the Microsoft SQL Server stack.

Responsibilities include:

• Own and drive the technical design, development, and day-to-day support of client’s Enterprise Data Warehouse and associated ETL processes.

• Analyze, tune and optimize ETL packages, Stored Procedures & SQL/C# scripts to ensure peak performance.

• Support ongoing data quality and data integrity initiatives through audit, balance, and control procedures, alerts and reports, and automated recovery.

• Occasional off-hours support as required to maintain platform and data availability.

• Serve as the team’s Application DBA supporting database upgrades and index optimization.

• Actively identify new technologies, frameworks, and platforms to support growth and expansion of the client’s Data Warehouse ecosystem.

Candidates selected to interview must meet the following minimum requirements:

• 5+ years of Data Warehouse ETL Development using commercial ETL tools, preferably SSIS 2012/2014

• Expert level SQL Scripting and Stored Procedure development skills, C# development skills a plus.

• Demonstrated hands-on experience leading the architecture, construction, and deployment of an end-to-end ETL platform

• Comfortable working as both a collaborative team member and as a technical platform expert & owner

• Application and/or Production DBA skills, particularly with MS SQL Server, are strongly preferred

• Strong analytical skills and fluent English verbal communication are required

• Prior experience working within a fast paced, rapidly evolving Agile environment is desired

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

Titles: Data Warehouse Developer, Lead Data Warehouse Developer, DHW Consultant, Data Warehouse Consultant

Skills: ETL, SQL Server, SSIS, Business Intellegence