Data Warehouse Developer
At a glance
Mid-level Data Engineering role at Sonoma Consulting Inc. Des Plaines · full-time · no salary stated · we estimate $112,500–$160,000 across the United States.
Sonoma Consulting Inc. has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Lead the design, build and daily upkeep of the enterprise warehouse and its connected ETL workflows
- Improve ETL packages, stored procedures and SQL or C# scripts to keep processing performant
- Run checks, alerts and recovery steps that protect data quality and integrity
- Handle database upgrades and index tuning as the application DBA, with occasional support outside regular hours
- Assess technologies and platforms that can extend the data warehouse environment
What you bring
- At least five years developing data warehouse ETL with commercial tools, ideally SSIS
- Expert SQL scripting and stored procedure skills, plus hands-on leadership building and deploying a complete ETL platform
- A bachelor’s degree is required
Who this fits
This suits a hands-on technical owner who can contribute with a team and lead platform decisions. The position is onsite in Des Plaines, Illinois, and may require occasional support outside regular hours.
From the employer
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.
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 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
Titles: Data Warehouse Developer, Lead Data Warehouse Developer, DHW Consultant, Data Warehouse Consultant
Skills: ETL, SQL Server, SSIS, Business Intellegence
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.