18h ago
New

Data Architect – Retail & CPG

United StatesUnited States·Chicagomid
Data ArchitectData & AI
2 views0 saves0 applied

Quick Summary

Key Responsibilities

CI/CD, infrastructure as code, testing, observability and cost optimization. Conduct design and code reviews, and resolve performance, reliability and data integrity issues.

Requirements Summary

Delta Lake, Unity Catalog,

Technical Tools
Data ArchitectData & AI

Confiz is looking for a hands-on Data Architect to lead data strategy and architecture for one of our largest global clients, a leading consumer goods company. You will shape the client's enterprise data strategy and help build a modern, AI-ready data platform that serves the business at scale.

This is not a diagram-only architect role. You will design the target architecture and also build alongside the engineering team on Azure, GCP and Databricks. You will work directly with client business and technology stakeholders, so strong retail and consumer goods knowledge and the confidence to lead client conversations are as important as technical depth.

Two priorities will define the first year in this role:

  • Holistic enterprise data strategy – defining a unified, governed data foundation and roadmap that aligns data platforms, models and pipelines with business priorities.
  • AI-enabled self-serve BI – giving business users fast, trusted answers through semantic models, governed data products and AI/natural-language analytics, reducing reliance on custom dashboards and ad-hoc reporting.

Responsibilities

~1 min read
  • Define and own the target-state data architecture and roadmap, aligned with business goals and spanning data platforms, sources and models.
  • Assess current-state platforms across Azure, GCP and Databricks; recommend consolidation, migration and rationalization paths with clear business cases.
  • Design scalable, secure lakehouse architectures for both batch and real-time data, using medallion patterns and reusable data products.
  • Build enterprise and domain data models (sales, supply chain, customer/retailer, product, marketing, finance) aligned to how the business actually runs.
  • Define master and reference data approaches for harmonizing products, customers, retailers and hierarchies across business units, regions and systems.
  • Architect a governed semantic layer and certified datasets that business users can trust and explore on their own.
  • Design and deliver AI-enabled analytics experiences such as natural-language querying, conversational BI and AI-assisted insights (e.g., Databricks AI/BI Genie, Power BI Copilot, Fabric, or LLM/RAG-based solutions).
  • Lead the consolidation of overlapping dashboards and reports into a smaller set of reusable, well-governed data products.
  • Ensure data quality, lineage and metadata are in place so AI-generated answers are accurate and explainable.
  • Build and review data pipelines, models and frameworks in PySpark, SQL and Python; lead by example in code.
  • Establish engineering standards: CI/CD, infrastructure as code, testing, observability and cost optimization.
  • Conduct design and code reviews, and resolve performance, reliability and data integrity issues.
  • Produce clear architecture documentation, decision records and reference designs.
  • Act as the trusted data advisor to client stakeholders, from business leaders to platform and engineering teams.
  • Translate business questions (e.g., promotion effectiveness, retailer sell-through, forecast accuracy, on-shelf availability) into data and architecture solutions.
  • Facilitate workshops, present architecture options and trade-offs, and build alignment on decisions.
  • Identify new opportunities where data and AI can create value for the client, and help shape proposals and estimates with Confiz leadership.
  • Define and enforce data governance, security, privacy and access policies
  • Mentor and coach data engineers and analysts; drive knowledge sharing and enablement programs.

Requirements

~1 min read
  • Bachelor's degree or equivalent in Computer Science, Information Technology or a related field.
  • 10+ years in data engineering and analytics, with 3+ years in a Data Architect or Lead Architect role designing enterprise-scale data platforms.
  • Hands-on experience across both Azure (ADLS, ADF, Synapse/Fabric) and GCP (BigQuery, Dataflow, Cloud Storage), and the ability to design across multi-cloud environments.
  • Deep, hands-on Databricks experience: Delta Lake, Unity Catalog, workflows, and performance tuning.
  • Strong proficiency in Python, PySpark and SQL
  • Proven experience with dimensional and tabular data models and semantic layers for BI at scale (Power BI, Tableau or Looker).
  • Experience delivering platform consolidation or migration programs, including integrating data across multiple business units or systems.
  • Solid business knowledge of retail and consumer packaged goods: sales and distribution, trade promotion, demand planning, supply chain, pricing and revenue growth management.
  • Ability to connect data architecture decisions to commercial outcomes and speak the language of business stakeholders.
  • Practical experience enabling self-serve BI and governed data products for business users.
  • Working knowledge of GenAI for analytics: natural-language-to-SQL, conversational BI, RAG, vector search and LLM integration with enterprise data.
  • Strong grounding in data governance, data quality, metadata management and data security/privacy.
  • Comfortable in a client-facing role: running workshops, presenting to senior stakeholders and handling ambiguity.
  • Clear communicator who can explain architectural decisions to both technical and business audiences.

We have a global team of amazing individuals working on highly innovative enterprise projects & products. Our customer base includes Fortune 100 retail and CPG companies, leading store chains, fast growth fintech, and multiple Silicon Valley startups.

What makes Confiz stand out is our focus on processes and culture. Confiz is ISO 9001:2015 (QMS), ISO 27001:2022 (ISMS), ISO 20000-1:2018 (ITSM) and ISO 14001:2015 (EMS) Certified. We have a vibrant culture of learning via collaboration and making workplace fun.

People who work with us work with cutting-edge technologies while contributing success to the company as well as to themselves. 

To know more about Confiz Limited, visit https://www.linkedin.com/company/confiz/

Location & Eligibility

Where is the job
Chicago, United States
On-site at the office
Who can apply
US

About this job

Who can apply
United States
Posted
Today
Employer
has 47 open jobs on Jobera in 3 countries.

Listing Details

Posted
November 20, 2026
First seen
November 20, 2026
Last seen
November 20, 2026

Posting Health

Days active
0
Repost count
0
Trust Level
56%
Scored at
November 20, 2026

Signal breakdown

freshnesssource trustcontent trustemployer trust
Newsletter

Stay ahead of the market

Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.

A
B
C
D
Join 12,000+ marketers

No spam. Unsubscribe at any time.

Data Architect – Retail & CPG