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 5 days ago
Similar jobs that could be interesting for youBased on the Lead Data Warehouse Developer in Des Plaines, IL vacancy
  • • Design, build, and maintain data pipelines moving data from multiple source systems into centralized data warehouses • Perform day-to-day ETL operations using SSIS and SQL Server • Collaborate with offshore team members, providing guidance and ensuring accountability... 
    Suggested

    Insight Global

    Rosemont, IL
    3 days ago
  •  ...Role Descriptions: • 3+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets best-in-class standards offering...  ...• 3 + years' experience Implementing Data Warehouse solutions (Star Schema, Snowflake schema)... 
    Suggested

    Diverse Lynx

    Rosemont, IL
    2 days ago
  •  ...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
    1 day ago
  • $130k - $150k

     ...based in Chicago. Monthly per diem and mobilization is on offer. Lead the Systems That Keep Critical Infrastructure Running  At FST...  ...intended. Our Commissioning division partners with clients across data centers and mission-critical environments to validate that systems... 
    Suggested
    Daily paid
    For contractors
    Relocation

    FST Technical Services

    Elk Grove Village, IL
    2 days ago
  • $99k - $232k

     ...Specialty/Competency: Data, Analytics & AI Industry/Sector:...  ...and techniques to design and develop robust data solutions for clients...  ...our Firm. You are expected to lead with integrity and authenticity...  .../ELT pipelines, manage data warehouses and data lakes, and implement... 
    Suggested
    Full time
    H1b

    PwC

    Rosemont, IL
    4 days ago
  • $90k - $105k

     ...About Prime Data Centers Prime Data Centers develops, acquires, and operates data centers for some of the world's largest enterprises. A private firm owned by a group controlling $6 billion in assets, with a 15-year tenure in technology and real estate development... 
    For contractors
    Local area

    Prime Data Centers

    Elk Grove Village, IL
    3 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... 
    Contract work
    Traineeship
    Internship
    Work at office

    Equinix

    Elk Grove Village, IL
    3 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... 
    Long term contract
    Local area
    Remote work

    RIT Solutions, Inc.

    Rosemont, IL
    2 days ago
  • Indium Corporation in Elk Grove Village, IL, is seeking a Quality Engineer responsible for ensuring product quality meets customer requirements. The successful candidate will work across functions to implement quality objectives, reduce process variations, and prepare documentation...

    Indium Corporation

    Elk Grove Village, IL
    6 days ago
  • $62.5k - $101k

    What’s Upstate is seeking a Quality Engineer in Elk Grove Village, Illinois to ensure the quality of products meets customer requirements. Responsibilities include implementing quality engineering activities, reducing process variation, and preparing documentation per quality...

    What’s Upstate

    Elk Grove Village, IL
    2 days ago
  • A prominent recruiting agency is looking for a Senior Data Engineer to transform data into business insights. The ideal candidate will design and maintain data pipelines, ensuring data integrity and governance compliance. With 5-8 years of experience and strong skills... 

    Staff Hire, LLC

    Mount Prospect, IL
    3 days ago
  • JLL is seeking a Data Center Operating Engineer for their Elk Grove Village, IL location. The engineer will be responsible for maintaining building systems, ensuring operational uptime, and managing incidents within a data center environment. Candidates should possess... 
    Full time

    JLL

    Elk Grove Village, IL
    4 days ago
  • $96k - $148k

     ...8,000 per year Fuel the future of data engineering and analytics for our...  ...users to design and build BI and data warehouse solutions. Engage with project leads, analysts and business users to...  .... 5+ years of hands‑on experience developing ETL using Informatica PowerCenter.... 
    Local area

    Uline

    Glenview, IL
    3 days ago
  • $89.6k - $123.2k

     ...Senior Data Engineer We have an exciting opportunity for a Senior Data Engineer at UL Standards...  .... The Senior Data Engineer will design, develop, and scale enterprise data infrastructure...  ...initiatives across the organization. Lead the collection, integration, and management... 
    Work experience placement
    Work at office
    Flexible hours

    UL Standards & Engagement

    Evanston, IL
    4 days ago
  • $70 - $85 per hour

     ...Data Engineer – Role Description Work Environment & Data Landscape...  ...Multiple databases and data warehouses Files and cloud-based...  ...Data Modeling & Architecture Develop and maintain structured data...  ...Global Services We’re a leading provider of business and... 
    Contract work
    Temporary work
    Remote work

    TEKsystems

    Deerfield, IL
    3 days ago
  • $124k - $280k

     ...Specialty/Competency: Data, Analytics & AI Industry/Sector:...  ...and techniques to design and develop robust data solutions for clients...  ..., and experiences you need to lead and deliver value at this level...  ...; Experience with data warehouse technology including Snowflake... 
    Full time
    H1b

    PwC

    Rosemont, IL
    1 day ago
  •  ...Senior Data Engineer The Sr. Data Engineer at PremiStar is responsible for building...  ...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
    12 hours ago
  • $100k

     ...walmart lab s etc to name a few. Currently, We are looking for entry-level software programmers, Java Full stack developers, Python/Java developers, Data analysts/ Data Scientists, Machine Learning engineers for full time positions with clients. Who Should Apply... 
    Full time
    H1b

    SynergisticIT

    Evanston, IL
    4 days ago
  • $75k - $90k

     ...~ Vision insurance Overview: We are looking for a Data Engineer who will use various methods to transform raw data into...  ...and reliability Identify opportunities for data acquisition Develop analytical tools and programs Collaborate with data scientists... 
    Contract work

    Tree Top Staffing LLC

    Wheeling, IL
    5 days ago
  • $70k - $95k

    A leading project control company is seeking a Project Engineer in Elk Grove Village, IL, to support construction management for a data center project. The role involves overseeing design development, budget management, vendor billing, and team meetings. Candidates should... 

    Consultaegis

    Elk Grove Village, IL
    6 days ago
  • $70k - $95k

    A leading construction services firm in Elk Grove Village is looking for a Project Engineer to support construction management services for data center projects. This role involves overseeing design developments, managing vendor payables, and ensuring project safety while... 

    Aegis Project Controls

    Elk Grove Village, IL
    5 days ago
  •  ...Data Engineer Location: SCHAUMBURG, IL (Hybrid 2x per week in office) Job Description: Lead Behavioral Technology data engineering delivery and create data foundation to enable Behavioral strategic pillars. Participate in sessions to design API solutions centered... 
    Work at office
    Work from home

    Software Technology Inc

    Schaumburg, IL
    5 days ago
  •  ...Job Title : Databricks Data Engineer Location : Deerfield IL (ONSITE) FTE ONLY Job Description • Mandatory...  ...Responsible for Ops work managing production for the data products developed and deployed to production Responsible for testing data... 

    AceStack LLC

    Deerfield, IL
    5 days ago
  •  ...We are seeking a Senior Data Engineer to serve as a technical lead within our Google Cloud-native data ecosystem. In this role, you will be responsible for the end-to-end engineering of scalable, high-performance data pipelines that power our national retail data platform... 
    Local area
    Remote work

    Crate&Barrel

    Northbrook, IL
    3 days ago
  •  ...Position: Microsoft Data Fabric Developer Location: REMOTE length: 3-6 months Start: ASAP interview: Video Special note: This Position might reach its maximum submission limit in our System Within 1 - 3 Hour, So Please Share Profiles As soon as possible... 
    Immediate start
    Remote work

    RIT Solutions, Inc.

    Schaumburg, IL
    5 days ago
  •  ...Sr. Data Engineer The Howard Hughes name is synonymous with entrepreneurial vision, tenacity and a pioneering spirit—values still...  ...dedication to success. Our mission is to be the pre-eminent developer and operator of master planned communities and mixed-use properties... 

    Howard Hughes Corporation

    Deerfield, IL
    4 days ago
  • $97.63k - $131.75k

     ...t worry, we've got you covered. The Job at a Glance The Data Engineer- Data Products & Delivery will specialize in turning raw...  ...layers using Looker or dbt for consistent business metrics Develop data marts and star schemas optimized for analytics and self-service... 
    Casual work

    Parts Town

    Addison, IL
    13 hours ago
  • $91.7k - $163.7k

     ...people with the care, pharmacy benefits, data and resources they need to feel their best...  ...Primary Responsibilities: Design and develop Azure cloud-native enterprise data solutions...  ...effort, and create implementation roadmaps Lead a team of data engineers by providing... 
    Minimum wage
    Full time
    Work experience placement
    Local area
    Remote work

    UnitedHealth Group

    Schaumburg, IL
    4 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
    3 days ago
  •  ...Python, SQL, PySpark, Docker • Experience with streaming and batch data architectures at scale • Experience operating in an Agile...  ...offline batch optimizations. • Partner with data scientists to develop prototype solutions of algorithmic products leveraging... 

    RIT Solutions, Inc.

    Rosemont, IL
    3 days ago

Do you want to receive more vacancies?

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