Sonoma Consulting Inc.
Consulting & Professional ServicesDirect SmartRecruiters career site

Lead Data Warehouse Developer

Location
Des Plaines, IL · On-site
Job type
Full-time
Level
Lead / Staff
Experience
5+ years
Education
Bachelor's degree
Listed
Today

Skills & highlights for this role

  • SSIS
  • expert SQL scripting
  • stored procedure development
  • ETL platform architecture

Also useful

  • C#
  • production DBA
  • Agile
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Sonoma Consulting Inc. role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

About the role

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 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. If you enjoy building disruptive technology as part of an agile driven innovation team,

Qualifications & 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

Additional Information

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

Skills: ETL, SQL Server, SSIS, Business Intellegence

About the Company

Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company 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.

Read the original posting

From Sonoma Consulting Inc.'s careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Lead Data Warehouse Developer role at Sonoma Consulting Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the Lead Data Warehouse Developer job at Sonoma Consulting Inc. located?

This Lead Data Warehouse Developer position at Sonoma Consulting Inc. is located in Des Plaines, IL (On-site). Always check Sonoma Consulting Inc.'s application page for specific state eligibility or relocation policies.

What qualifications are required for Lead Data Warehouse Developer at Sonoma Consulting Inc.?

For the Lead Data Warehouse Developer role, Sonoma Consulting Inc. highlights 5+ years of relevant experience; a bachelor's degree; experience with SSIS, expert SQL scripting, stored procedure development, ETL platform architecture. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the Lead Data Warehouse Developer position at Sonoma Consulting Inc.?

This listing links directly to Sonoma Consulting Inc.'s SmartRecruiters application page. You can apply directly on Sonoma Consulting Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.