Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Lead Data Warehouse Developer in Des Plaines, IL vacancy
  •  ...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)... 
    Suggested
    Remote work

    Wintrust

    Rosemont, IL
    2 days ago
  •  ...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

    TechDigital Group

    Rosemont, IL
    5 days ago
  • 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... 
    Suggested
    Permanent employment
    Contract work
    Visa sponsorship

    Staff Hire, LLC

    Mount Prospect, IL
    2 days ago
  •  ...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... 
    Suggested
    Long term contract
    Local area
    Remote work

    RIT Solutions, Inc.

    Rosemont, IL
    3 days ago
  •  ...? 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

    Reyes Holdings

    Rosemont, IL
    3 days ago
  • $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

    Fortune Brands

    Deerfield, IL
    22 hours ago
  • $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

    Wintrust

    Rosemont, IL
    4 days ago
  •  ...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

    PremiStar

    Deerfield, IL
    5 days ago
  • $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 placement
    Work at office
    Worldwide
    Flexible hours

    Underwriters Laboratories

    Evanston, IL
    3 days ago
  • $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 sponsorship
    2 days per week

    TalentFish

    Deerfield, IL
    3 days ago
  • $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 work
    Flexible hours

    BradyPLUS

    Glenview, IL
    4 days ago
  • $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 time
    Contract work
    Part time
    Work at office
    Local area
    Remote work

    Booz Allen Hamilton

    Glenview, IL
    2 days ago
  • $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 pay
    Contract work
    Temporary work
    Work experience placement
    Remote work

    Randstad Digital Americas

    Deerfield, IL
    2 days ago
  • $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 placement
    Flexible hours

    ULSE

    Evanston, IL
    1 day ago
  •  ...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 time
    Work experience placement
    Work at office
    Remote work
    Work from home

    BinaryBees Business Solutions LLC

    Itasca, IL
    2 days ago
  • 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... 

    Cornerstone Global Partners (CGP Group)

    Schaumburg, IL
    2 days ago
  • $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 pay
    Full time
    Work experience placement
    Work at office
    Flexible hours
    Weekend work
    Afternoon shift

    ChenMed

    Deerfield, IL
    22 hours ago
  • $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... 

    PwC (US)

    Rosemont, IL
    4 days ago
  • $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 time
    Remote work

    UL

    Northbrook, IL
    3 days ago
  •  ...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.... 

    3B Staffing LLC

    Northbrook, IL
    10 hours ago
  •  ...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 start
    Remote work
    Flexible hours

    RIT Solutions, Inc.

    Schaumburg, IL
    5 days ago
  •  ...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... 

    Uline

    Glenview, IL
    5 days ago
  •  ...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... 

    NextStep

    Northbrook, IL
    1 day ago
  •  ...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... 

    Next Step Systems LTD

    Northbrook, IL
    4 days ago
  •  ...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 time
    H1b
    Local area
    Immediate start
    Remote work
    Visa sponsorship
    Work visa

    Bright Vision Technologies

    Buffalo Grove, IL
    4 days ago
  • $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

    BradyPLUS

    Glenview, IL
    4 days ago
  • $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 time
    Part time
    Local area
    Flexible hours

    Capital One

    Riverwoods, IL
    8 days ago
  •  ...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 placement
    Remote work

    Kasmo Global

    Schaumburg, IL
    2 days ago
  •  ...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 office
    Remote work

    Samprasoft

    Villa Park, IL
    2 days ago
  •  ...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 time
    Contract work
    Traineeship
    Internship
    Work at office

    Equinix

    Elk Grove Village, IL
    more than 2 months ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Lead Data Warehouse Developer. Be the first to apply!