Sonoma Consulting Inc.
Consulting & Professional ServicesDirect SmartRecruiters career site

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

  • SQL Server
  • SSIS
  • stored procedure development
  • ETL performance tuning

Also useful

  • C#
  • 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

  • Title: Lead Data Warehouse Developer
  • Location: Des Plaines, IL
  • Full time

About the role

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

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 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 Data Warehouse Developer job at Sonoma Consulting Inc. located?

This 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 Data Warehouse Developer at Sonoma Consulting Inc.?

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

How do I apply for the 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.