Lead Data Warehouse Developer
Sonoma Consulting
Lead Data Warehouse Developer
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.
Job Description
We 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,
Qualifications
- 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
- ...Select Market under the symbol "WTFC." Job Title: Principal Data Engineer Location: Job location - Rosemont, IL- The... ...anywhere in the U.S. will be considered. Responsibilities: Develop and maintain data solutions on Master Data Management (MDM)...SuggestedRemote work
- ...MuleSoft, AWS Gateway API CI/CD - Atlassian Bitbucket and Bamboo Build tools - Apache ANT and Maven RESPONSIBILITIES: Be an expert in Data Warehouse domain and relevant business function. Work with minimal supervision and provide status updates. Provide application support as...Suggested
- StaffHire is a leading recruiting partner specializing in the business and technology sectors... ...About the Role We are seeking a Senior Data Engineer to join a pivotal team. In this... ...needs, and propose effective solutions. Develop and maintain robust data transformation pipelines...SuggestedPermanent employmentContract workVisa sponsorship
- ...Senior Data Scientist Duration: Long-Term Contract 100 % remote Local to Chicago... ...Operations Research & Optimization Develop optimization solutions utilizing: • Linear... ...is seeking a Senior Data Scientist to lead the development of advanced Machine Learning...SuggestedLong term contractLocal areaRemote work
- ...? Apply a variety of methods including data mining, statistical analysis, predictive... ...network analysis to solve business problems Develop and implement machine learning models and... ..., data gathering and processing, leading approaches, final algorithm, detailed set...Suggested
$160.56k - $193k
Lead Data Engineer, Fortune Brands Innovations Group, Inc., Deerfield, IL. Administer a cloud data warehouse platform (e.g., Snowflake or similar), including roles/permissions, performance tuning, security, & cost governance. Utilize Git for version control & collaboration...Flexible hours$202.78k
...symbol "WTFC." Job Title: Principal Data Architect Location: Job location -... ...team members as necessary. Design, develop and maintain data solutions using best... ...security, and compliance (e.g., GDPR, HIPAA). Lead the creation of conceptual, logical, and...Remote work- ...The Sr. Data Engineer at PremiStar is responsible for building and optimizing the company... ...In this role, The Sr. Data Engineer will develop and maintain robust data pipelines and... ...unified data repositories (data lake and data warehouse) that consolidate information from...Work at office
$89.6k - $123.2k
## Senior Data EngineerApplylocations: Evanston, IL: Research Triangle Park, NCtime type:... ...sustainable. The Senior Data Engineer will design, develop, and scale enterprise data infrastructure... ...initiatives across the organization.* Lead the collection, integration, and...Work experience placementWork at officeWorldwideFlexible hours$110k - $130k
...Data & Analytics Engineer (Microsoft Fabric) Primary Location... ...The successful candidate will lead the design, development, and optimization... ...Fabric, including Lakehouse, Warehouse, OneLake, Data Factory, and... ...within Microsoft Fabric. Develop enterprise data models that...Visa sponsorship2 days per week$75k - $110k
...create, maintain, improve, and implement data models, dashboards, ad-hoc analyses, and... ...in the future. Essential Responsibilities Develop, maintain, and improve dashboards and reports... ...more. Company Overview BradyPLUS is a leading national distributor of solutions for...Remote workFlexible hours$61.9k - $141k
...intelligence means that there’s more structured and unstructured data available today than ever before. As a data engineer, you know... ...some of the most mission-driven projects in the industry. You’ll develop and deploy the pipelines and platforms that organize and make disparate...Full timeContract workPart timeWork at officeLocal areaRemote work$50 - $57.57 per hour
Join to apply for the Data Engineer role at Randstad Digital Americas We’re unlocking community knowledge in a new way. Experts add... ...for large, real‑time datasets to generate weekly data extracts Develop scalable ELT and ML pipelines using Python and Databricks Automate...Hourly payContract workTemporary workWork experience placementRemote work$89.6k - $123.2k
SENIOR DATA ENGINEER We have an exciting hybrid opportunity based in Raleigh‑Durham, NC or... ...initiatives across the organization. Lead the collection, integration, and management... ...and unstructured information repositories. Develop and optimize enterprise ETL/ELT processes...Work experience placementFlexible hours- ...Citizenship: Must be Citizen and Green Card The Data Engineer will be responsible for designing, developing, and maintaining scalable data pipelines and integrations... ...to extend existing frameworks. Designing data warehouse table architecture such as star schema or Kimball...Full timeWork experience placementWork at officeRemote workWork from home
- The Data Analytics Engineer plays a critical role in designing, developing, and supporting enterprise analytics solutions built on Microsoft Fabric . This position bridges... ...flow diagrams, and technical documentation. Lead and support User Acceptance Testing (UAT) efforts...
$99.37k - $141.96k
The Senior Data Engineer will play a crucial role in developing, improving, and maintaining our data infrastructure and Business Intelligence systems. This... ...Extract, Load, Transform) processes and adhering to data warehouse best practices Implement and manage scalable data...Hourly payFull timeWork experience placementWork at officeFlexible hoursWeekend workAfternoon shift$124k - $280k
...Senior Manager, Data and Analytics Engineering At PwC, our people in data and analytics... ...technologies and techniques to design and develop robust data solutions for clients. They... ...skills, knowledge, and experiences you need to lead and deliver value at this level include...$80k - $120k
...The Data Scientist is responsible for delivering data-driven insights and analytical solutions... ...datasets, build visualizations, and develop predictive models. The ideal candidate... ...pioneering change since 1894 and we're still leading the way. From day one, we've blazed a...Full timeRemote work- ...Processing, cleansing, and verifying the integrity of data used for analysis. Doing ad-hoc analysis and presenting results... ...implementation of new datalake. Support data science initiatives by developing the necessary tools to meet project requirements....
- ...Position: Data Engineering Manager Location: Palo Alto, CA - Hybrid - (Not On-site every week Mostly remote) Length: 6-12 months... ...required for the submissions. Job Overview: Client type: Leading mobile app marketing company Job Summary: We are...Immediate startRemote workFlexible hours
- ...Engineer at Uline, you'll turn data into insights that drive... ..., supporting operations from warehouse management to e-commerce.... ...Partner with business leaders to develop scalable solutions and dashboards... ...company, is North America's leading distributor of shipping, industrial...
- ...quantitative models and modeling resources, including legacy model evolution, new model development, and analysis of economic and financial data. Design, conduct, and administer studies of long-range trends significant to the securities markets. Organize and conduct data...
- ...quantitative models and modeling resources, including legacy model evolution, new model development, and analysis of economic and financial data. - Design, conduct, and administer studies of long-range trends significant to the securities markets. - Organize and conduct...
- ...arrangements for this role. Position Summary We are seeking an AI Data Engineer to build and operate the large‑scale data systems that... ..., filtering, and quality assurance at petabyte scale. Develop dataset versioning, lineage, and provenance tracking systems suitable...Full timeH1bLocal areaImmediate startRemote workVisa sponsorshipWork visa
$75k - $110k
...an Analytics Engineer to support its reporting and analytics initiatives. This role involves developing and improving dashboards, conducting ad-hoc analyses, and maintaining data pipelines. Candidates should have 2-4 years of experience with Power BI and SQL, with a...Remote work$147.1k - $167.9k
...Principal Associate, Data Scientist - Card DFS Integration Data is at the center of everything we do. As a startup, we disrupted... ...Data Scientist at Capital One, you'll be part of a team that's leading the next wave of disruption at a whole new scale, using the latest...Full timePart timeLocal areaFlexible hours- ...efficiency and automation of their data pipeline, including data... ...data processing workflows. Develop and test software to implement... ...various sources into our data warehouse. Optimize data pipelines... ...with Product Managers, Delivery leads, System Engineers, Data...Work experience placementRemote work
- ...Senior Data Architect Location: Hybrid ONSITE – In office MONDAY... ...and creates blueprints for developing, testing, and maintaining... ...analytics and reporting needs. Lead the transformation of... ...and manage the Enterprise Data Warehouse (EDW), including parent-child...Work at officeRemote work
- ...chapter in your professional life. We are accepting applications for our very own DoD SkillBridge Fellowship Program, supporting Data Center Operations and Critical Facilities. The training will be on the cutting edge of technology, in a digital infrastructure...Full timeContract workTraineeshipInternshipWork at office
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Lead Data Warehouse Developer. Be the first to apply!
- clinical data Des Plaines, IL
- data collection Des Plaines, IL
- data loss prevention engineer Des Plaines, IL
- data Des Plaines, IL
- test data management Des Plaines, IL
- data cabling installation Des Plaines, IL
- data modeling Des Plaines, IL
- data collection researcher Des Plaines, IL
- provider data management Des Plaines, IL
- data network cabling Des Plaines, IL

