Lead Data Architect

Glint Tech Solutions LLC; Chicago (IL); Hybrid; USD 150,000 - 190,000; Full time

Job summary

Glint Tech Solutions LLC in Chicago, IL is modernizing and building an enterprise eCommerce data platform for a leading retail client serving millions of omnichannel customers weekly. The project spans Customer, Loyalty, Search & Browse, Data Integration, and Cart, with brand onboarding, re-architecture, database migrations, and cloud-native consolidation at the core.

The Lead Data Architect will design scalable data architectures, define technical strategy, and oversee data governance while

Qualifications

• 8+ years in data architecture with a lead/architect role
• 3+ years Azure Data Factory & Synapse experience
• Expert in data modeling (conceptual, logical, physical)
• Experience with Azure Data Lake Storage, Synapse, Databricks, PySpark
• Proficient in ETL/ELT pipelines and multi-source data integration
• Knowledge of star schema, Data Mesh, Lakehouse, Data Vault
• Advanced SQL with performance tuning
• Metadata and governance integration
• Python and Python ETL tools
• Shell scripting (Bash/Unix/Windows) preferred

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

Skills

Lead Architect experience

Azure Data Factory

Azure Synapse

Data modeling

Data Lake Storage

Databricks

PySpark

ETL/ELT pipelines

Data warehousing patterns

Advanced SQL

Metadata governance

Python

Shell scripting

Tools

Docker

Kubernetes

Azure Databricks

Job 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