Company DescriptionSonoma 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.Job DescriptionWe 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, Qualifications5 years of Data Warehouse ETL Development using commercial ETL tools, preferably SSIS 2012/2014Expert 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 platformComfortable working as both a collaborative team member and as a technical platform expert & ownerApplication and/or Production DBA skills, particularly with MS SQL Server, are strongly preferredStrong analytical skills and fluent English verbal communication are requiredPrior experience working within a fast paced, rapidly evolving Agile environment is desiredBachelor’s degree required, preferably in Computer Science, Math, Engineering or MISAdditional InformationTitles: Data Warehouse Developer, Lead Data Warehouse Developer, DHW Consultant, Data Warehouse ConsultantSkills: ETL, SQL Server, SSIS, Business Intellegence