Lead Data Architect
Hybrid (2-3 days onsite in Chicago) Lead Data Architect role placed by IT staffing firm Glint Tech Solutions to modernize an eCommerce platform for a large enterprise retail client. Day-to-day involves designing data architecture, building ETL/ELT pipelines, and leading migrations using Azure Data Factory, Synapse, Databricks, and PySpark.
- Compensation
- Not disclosed
- Location
- Chicago, Illinois, United States
- Work setup
- Hybrid
- Seniority
- Lead
- Employment
- Not specified
- Experience
- 1+ years
- Category
- Architecture
- Posted
Skills
Must have
- 8+ years overall experience, minimum 1 year in a Lead/Architect role
- 3+ years recent hands-on Azure Data Factory & Synapse experience
- Data modeling: conceptual, logical, physical
- Azure Data Lake Storage, Synapse Analytics, Databricks, PySpark
- ETL/ELT pipeline development and multi-source data integration
- Data warehousing patterns: star schema, Data Mesh, Lakehouse, Data Vault
- Advanced SQL (querying, transformation, performance tuning)
- Metadata and governance integration
- Python / Python ETL tools
Nice to have
- Shell scripting (Bash/Unix/Windows)
- Elasticsearch
- Docker, Kubernetes
- Azure/Databricks certification
- Strong stakeholder communication, mentoring, and delivery tracking
- CS/Data Science academic background
Full description
Job Title: Lead Data Architect
Location: Chicago, IL (Hybrid – 2-3 days onsite)
Company Overview
Glint Tech Solutions is a women-owned, global IT staffing and recruiting firm serving enterprise clients across the USA and Canada.
Project Description
Modernization and development of an eCommerce platform for a leading enterprise retail client serving millions of omnichannel customers weekly. Work spans Customer, Loyalty, Search & Browse, Data Integration, and Cart domains, with current focus on brand onboarding, re-architecture, database migrations, and cloud-native consolidation.
Key Responsibilities
- Design data architecture to support large-scale data processing
- Integrate new solutions with existing enterprise architecture
- Lead cross-functional teams and define technical/architectural strategy
Mandatory Skills
- 8+ years overall experience, minimum 1 year in a Lead/Architect role
- 3+ years recent hands-on Azure Data Factory & Synapse experience
- Data modeling: conceptual, logical, physical
- Azure Data Lake Storage, Synapse Analytics, Databricks, PySpark
- ETL/ELT pipeline development and multi-source data integration
- Data warehousing patterns: star schema, Data Mesh, Lakehouse, Data Vault
- Advanced SQL (querying, transformation, performance tuning)
- Metadata and governance integration
- Python / Python ETL tools
- Shell scripting (Bash/Unix/Windows) preferred
Nice-to-Have Skills
- Elasticsearch
- Docker, Kubernetes
- Azure/Databricks certification
- Strong stakeholder communication, mentoring, and delivery tracking
- CS/Data Science academic background