Data Architect

Avanciers is seeking a highly skilled: Data Architect to join our team for an exciting long-term contract with one of our esteemed clients, based in Lake Forest, IL.

Job Description:

• We are seeking an expert Data Architect for a contract role based in Lake Forest, IL (onsite once every 2 months) to design a scalable "Single Source of Truth" platform. With 10+ years of CPG/Retail experience, you will 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.
• Academically and practically fluent in enterprise data architectures (Lakehouse, Data Warehouse, Star Schema, Data Vault 2.0), you will define robust data ingestion patterns across APIs, EDI, and SFTP.
• The ideal candidate will utilize Azure-preferred cloud platforms (Data Factory, Databricks, Fabric, Synapse) to architect ETL/ELT pipelines and semantic structures supporting Power BI and Tableau.
• Ultimately, you will leverage deep expertise in key retail metrics (OTIF, Weeks of Supply, POS, Sell-Through), Data Governance/MDM (using Purview, Collibra, or Alation), and AI/ML enablement to translate complex retail business problems into high-performing technology solutions.