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
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.
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.
Similar roles
- Data Warehouse/ETL DeveloperWilson Legal Solutions · Newtown Township, PA
- Talend HVR Consultant (AWS is must)(Independent consultants only)Ajna Infotech · Dallas, TX
- Data Intelligence ConsultantHylaine · Raleigh, NC
- Lead Data Engineer/ETLPrincipal Software · Pleasanton, CA
- Solution Enablement PractitionerCore Compete · United States
- Data Warehouse Developer (Data Warehouse Engineer, Data Engineer)Cleveland Steel Container · Hudson, OH
More at Sonoma Consulting Inc.
All Sonoma Consulting Inc. jobsCommon 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.