Lead Data Engineer ( Hybrid- Rosemont, IL )

Claire's; Rosemont (IL); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) match

Vacation and paid time off

Sick time and paid leave

Bonus plan eligibility

Job summary

Claire’s is seeking a Data Engineer to analyze, design, develop, maintain, and support data applications enabling business analytics in a retail domain. The role includes enabling data access across the organization, with significant collaboration across IT, vendors, and stakeholders.

The ideal candidate will architect and implement data platforms (data lake, data warehouse, ETL, medallion views), leverage AI-enabled tools, and drive production ETL pipelines.

Qualifications

• Bachelor’s degree in computer science, Information Systems, or related field required or equivalent experience.
• 7+ years’ experience implementing and supporting ETL tools and technologies.
• Experience with building system integrations using low-code or high-code approaches.
• Familiarity with Snowflake, SQL Server, BigQuery and other data warehouses.
• Proficiency in AI to accelerate code development for ETL and applications.
• Expert ability with complex SQL and relational databases.
• Expert ability in Python for building programs and apps.
• Familiarity with Azure environments including Azure Data Lake and Azure Data Factory.
• VB.Net or C# experience and familiarity with Oracle Retail Platform is a plus.
• Experience with version control software.
• Excellent written and verbal communication.
• Experience in researching and interpreting data and relational database design.

Responsibilities

• Architect, build, and support a data platform spanning data lake, data warehouse, ETL capabilities, and medallion views.
• Utilize emergent tools in data warehouses, especially for AI functions, and intra-application integrations.
• Operationalize data quality prototypes and mappings as production jobs.
• Collaborate with IT, vendor teams, and stakeholders to deliver business value.
• Develop simple applications to support enterprise functions and replace manual processes.
• Design, prototype, develop, test, and document ETL components.
• Convert legacy systems to modern applications.
• Recommend new tools to improve results and accessibility.
• Perform unit testing of ETL components and document results.
• Support testing phases: DIT, System, UAT, E2E, and Performance.
• Maintain and monitor data application operations and job schedules.
• Provide timely resolution of production issues and defects.

Skills

SQL

Python

ETL design

Data integration

Data analytics

Communication

AI-assisted coding

Education

Bachelor’s degree in computer science or related field

Tools

Snowflake

SQL Server

BigQuery

Azure Data Lake

Flowgear

Zapier

Git

Oracle Retail Platform

Job description

About the Role

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.

Brief Description

About the Role

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.

Key Responsibilities

• 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

Qualifications

• 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

Summary

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.

Benefits for full-time employees included medical, dental, and vision insurance, voluntary welfare plans, bonus plan eligibility, 401(k) match, vacation time, sick time* and paid leave.

Benefits for part-time employees included voluntary welfare plans, 401(k) match, vacation time, sick time* and paid leave in required states.

• Sick Time: For the State of Washington, all employees will accrue paid sick time at the rate of 1 hour for every 30 hours worked.

Claire's is an equal opportunity employer committed to diversity, equity, and inclusion and we encourage applications from members of all underrepresented groups, including those with disabilities. We will accommodate applicants' needs, upon request, throughout all stages of the recruitment process. Please inform us of the accommodation(s) that you may require.

Information received relating to accommodation will be addressed confidentially. To request accommodation, please email [e-mail]. Only messages sent for this purpose will be considered.