Lead Data Engineer ( Hybrid- Rosemont, IL

The Data Engineer is responsibleforanalysis, design, development,maintenance and support for various data applications to enable business and advanced analytic sin 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 Engineerisa highly visible role with significant interactions across IT, third-party vendors, and other business stakeholders.

• Ability to architect,build, and supportacomprehensivedata platform thatspansa 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 supportgroupsand 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
• Providetimelyresponse and resolution of emergency production questions,issuesand defects
• Maintain andmonitorjob schedules

• 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.) orwith using high-code customized integrations
• Familiarity with functions in enterprise data warehouses including Snowflake, SQL Server,Big Query, 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.Netor 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