> Markdown version of [/jobs/ext/2635949-lead-data-engineer-hybrid-rosemont-il](https://www.wearedevelopers.com/jobs/ext/2635949-lead-data-engineer-hybrid-rosemont-il). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Data Engineer ( Hybrid- Rosemont, IL ) - **Company:** Claire's Essentials LLC - **Location:** Rosemont, IL, United States - **Experience:** Expert - **Salary:** $135,000.0 - $145,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Unit Testing, Microsoft Azure, BigQuery, C Sharp (Programming Language), Information Systems, Data Infrastructure, Extract Transform Load (ETL), Data Warehousing, Relational Databases, Python (Programming Language), Microsoft SQL Server, Visual Basic .NET (Programming Language), Oracle (Applications), E2e Testing, Azure Data Lake, Software Engineering, SQL Databases, System Testing, Systems Integration, Enterprise Software Applications, Performance Testing, Azure Data Factory, Snowflake, Zapier, Data Lakes, Integration Tests, Information Technology, Data Analytics, Low-code, Software Coding, Software Version Control, Legacy Systems - **Published:** August 10, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=ca34a1d4317b30d5 ## About the Role * Bachelor's degree in computer science, Information Systems, or related field required or equivalent experience. * 7+ years' experience in implementing and supporting based ETL tools and technologies * Experience with building system integrations using either low-code tools (Flowgear, Zapier, etc.) or with using high-code customized integrations * Familiarity with functions in enterprise data warehouses including Snowflake, SQL Server, BigQuery, and other contemporary environments * Proficiency in using AI to accelerate code development for application and ETL development * Expert ability with complex SQL and relational databases * Expert ability in Python with the ability to build programs and applications * Familiarity with Microsoft Azure environments, including Azure Data Lake and Azure Data Factor * Net programming experience (VB.Net or C#) and familiarity with Oracle Retail Platform is a plus * Experience with version control software * Excellent written and verbal communication required * Experience writing process flows and requirements documents. * Experience in researching and interpreting data, with a solid understanding of relational database concepts and table design Strong demonstration of the skills to align business needs with IT capabilities require Claire's is committed to adhering to all applicable company policies and federal, state, and local laws and regulations. All positions will be compensated at or above the legally mandated minimum wage for the location in which work is performed. The final compensation will be determined by various factors such as relevant work experience, education, certifications, skills, and geographic location. ## Description The Data Engineer is responsible for analysis, design, development, maintenance and support for various data applications to enable business and advanced analytics in a retail domain environment. The Data Engineer also supports integrations between enterprise applications, helping to ensure that Claire's data is accurately and regularly accessible across the organization. Between these responsibilities, the Data Engineer is a highly visible role with significant interactions across IT, third-party vendors, and other business stakeholders., * Ability to architect, build, and support a comprehensive data platform that spans a data lake, data warehouse, ETL capabilities, and medallion views to support data analytics functions * Utilize emergent tools and capabilities in current data warehouses, particularly regarding to AI functions, intra-application integrations and pipelines, and application development toolkits * Leverage data quality prototypes and mappings to operationalize as production jobs * Work with technical leads, architects, subject matter experts, developers, vendor teams, technical support groups and test teams to deliver value to the business * Develop simple applications to support targeted enterprise functions, with the goal of developing end-to-end infrastructure to replace manual recurrent processes * Design, prototype, develop, test cases, and document ETL components * Ability to convert legacy systems to modern applications and platforms * Recommend new applications to Claire's that could produce measurably better results, particularly tools that democratize access and ability, save labor, or increase insight * Perform unit testing of ETL components and document test results * Support all testing, including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing and Performance Testing * Support the ongoing operation of data applications and scheduled jobs * Provide timely response and resolution of emergency production questions, issues and defects * Maintain and monitor job schedules ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [HR ROBO SAPIENS: Decoding AI Agents and Workflow Automation for Modern Recruitment](https://www.wearedevelopers.com/videos/1470-hr-robo-sapiens-decoding-ai-agents-and-workflow-automation-for-modern-recruitment) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Reimagining app development with Low-code and AI](https://www.wearedevelopers.com/videos/1651-reimagining-app-development-with-low-code-and-ai) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Create a Programmatic SEO Project Using Next.js and Static Site Generation](https://www.wearedevelopers.com/videos/449-create-a-programmatic-seo-project-using-next-js-and-static-site-generation) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)