Lead Data Warehouse Developer

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

Job summary

Join a forward-thinking company as a Lead Data Warehouse Developer where your expertise in ETL and SQL Server will drive innovative solutions. In this pivotal role, you will oversee the architecture and deployment of cutting-edge ETL platforms, ensuring the delivery of performance-oriented data warehousing technology. Collaborate with an agile-driven team to build disruptive technologies that empower clients across various industries. If you thrive in a fast-paced environment and are passionate about data solutions, this opportunity is designed for you to make a significant impact.

Qualifications

• 5+ years of ETL Development using commercial tools, preferably SSIS.
• Expert level SQL Scripting and Stored Procedure development skills.

Responsibilities

• Lead the architecture, construction, and deployment of ETL platforms.
• Serve as the technical steward and platform owner for Data Warehousing.

Skills

ETL

SQL Server

SSIS

Business Intelligence

C#

Analytical Skills

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Math

Bachelor’s degree in Engineering

Bachelor’s degree in MIS

Tools

Microsoft SQL Server

SSIS 2012/2014

Job description

Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search companies in the United States, 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 ranging from entrepreneurial start-ups to Global Fortune 500.

Job Description

We currently have an excellent career opportunity for a Lead Data Warehouse Developer in our 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 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. If you enjoy building disruptive technology as part of an agile-driven innovation team, this role is for you.

Qualifications

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

Additional Information

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

Skills: ETL, SQL Server, SSIS, Business Intelligence