Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search companies in the United States, 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 ranging from entrepreneurial start-ups to Global Fortune 500.
The following information aims to provide potential candidates with a better understanding of the requirements for this role.
Job Description
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 the 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.
J-18808-Ljbffr
Data Warehouse Developer
As an experienced data warehouse developer, you will be joining a collaborative IT data warehouse team as we bring Guidehouse data together to meet our business’s reporting needs. Participate in development and maintenance of our corporate data warehouse and data lake as a member of our corporate da...
Data Warehouse Developer
As an experienced data warehouse developer, you will be joining a collaborative IT data warehouse team as we bring Guidehouse data together to meet our business’s reporting needs. Participate in development and maintenance of our corporate data warehouse and data lake as a member of our corporate da...
Lead Data Warehouse Developer
We currently have an excellent career opportunity for a Lead Data Warehouse Developer in our Des Plaines, IL corporate headquarters. Data Warehouse ETL Development using commercial ETL tools, preferably SSIS 2012/2014. Candidates for this role must have a passion for the hands-on delivery of perform...
Data Warehouse Developer
Design, develop, and maintain the data warehouse using Oracle database and Oracle Data Integrator (ODI) for ETL. Develop ETL jobs using ODI to extract, transform, and load data from various sources into the data warehouse. Perform performance tuning of the data warehouse, ETL jobs, and SQL queries t...
Data Warehouse Developer
Title: Lead Data Warehouse Developer. We currently have an excellent career opportunity for a Lead Data Warehouse Developer in our client’s Des Plaines, IL corporate headquarters. Own and drive the technical design, development, and day-to-day support of the client’s Enterprise Data Warehouse and as...
Data Warehouse Developer
We’re looking for a motivated Data Warehouse Developer responsible for preparing corporate data for reporting and analysis using the relational database and OLAP technologies. Maintains data integrity by reducing data redundancy, trends in data use and single sources of data. This position will anal...
Data Warehouse Developer
Data Warehouse Developer needs 7 years of experience in data warehousing development, implementation, and support. Design, develop, and maintain the data warehouse using Oracle database and Oracle Data Integrator (ODI) for ETL. Data Warehouse Developer requires:. Data Warehouse Developer duties:. ...
Senior Data Warehouse Developer
A typical day as a senior data warehouse developer:. ETL specialist with a deep understanding of relational databasesSolid experience of working with data models, database design development, performance tuning techniques. Incumbent's responsibilities will include conducting full development li...
Software Developer - Java
Software Developer - JavaCorporate Headquarters12575 Uline Drive, Pleasant Prairie, WI 53158Are you ready to design, innovate and lead in a collaborative, cutting-edge tech environment? Uline is seeking a Java Software Developer to spearhead the development, deployment and maintenance of sophisticat...
SQL Server Database Developer
As a Database Developer, you will design and implement database models and scripts that support commission payout processes. Your expertise in SQL Server and database modeling will be crucial in ensuring accurate and efficient calculations. Design and implement robust database models to support busi...