Senior Data Platform Engineer — AI & ETL

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

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.