Skip to main content
Tallo logoTallo logo
Apply for this opportunity

This job application is on an outside website. Be sure to review the job posting there to verify it's the same.

Apply Offsite

Data Architect

Job

Avanciers LLC

Mettawa, IL (In Person)

Full-Time

Posted 3 days ago (Updated 15 hours ago) • Actively hiring

Expires 7/20/2026

Review key factors to help you decide if the role fits your goals.
How is this calculated?
Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
75
out of 100
Average of individual scores

Were these scores useful?

Skill Insights

Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.

Job Description

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.