Data Architect
Avanciers Inc. · Lake Forest, IL · 1 wk ago
On-siteEngineeringContract
About the role
We are seeking an expert Data Architect for a contract role based in Lake Forest, IL (onsite once every 2 months).
Responsibilities
- Design a scalable "Single Source of Truth" platform
- Lead the architecture of an enterprise-wide Canonical Data Model, integrating major retailer feeds like Walmart Luminate, Target RBD, Kroger Stratum, and Sam's Club MAP
- Define robust data ingestion patterns across APIs, EDI, and SFTP
- Utilize Azure-preferred cloud platforms (Data Factory, Databricks, Fabric, Synapse) to architect ETL/ELT pipelines and semantic structures supporting Power BI and Tableau
- Leverage deep expertise in key retail metrics (OTIF, Weeks of Supply, POS, Sell-Through)
- Implement Data Governance/MDM (using Purview, Collibra, or Alation)
- Enable AI/ML solutions to translate complex retail business problems into high-performing technology solutions
Requirements
- 10+ years of CPG/Retail experience
- Academically and practically fluent in enterprise data architectures (Lakehouse, Data Warehouse, Star Schema, Data Vault 2.0)
Qualifications
- Expertise in key retail metrics (OTIF, Weeks of Supply, POS, Sell-Through)
- Experience with Data Governance/MDM tools (Purview, Collibra, or Alation)
- Knowledge of AI/ML enablement
Skills
- Azure-preferred cloud platforms (Data Factory, Databricks, Fabric, Synapse)
- ETL/ELT pipelines
- Semantic structures supporting Power BI and Tableau
- Data Governance/MDM tools (Purview, Collibra, or Alation)
- AI/ML enablement
Benefits
N/A
Pay
N/A
Schedule
Onsite once every 2 months