Data Warehouse Developer

Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search companies in the United States, which was founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients which range from entrepreneurial start-ups to Global Fortune 500.

Job Description

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 clients 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 clients 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 the clients 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 teams Application DBA supporting database upgrades and index optimization.
• Actively identify new technologies, frameworks, and platforms to support growth and expansion of the clients Data Warehouse ecosystem.

Candidates selected to interview must meet the following minimum requirements :

#J-18808-Ljbffr