Data Architect – Retail & CPG

Confiz•Chicago, IL

About The Position

Confiz is seeking a hands-on Data Architect to lead data strategy and architecture for a major global consumer goods client. The role will shape enterprise data strategy and help build a modern, AI-ready data platform, combining target-architecture design with practical implementation alongside engineering teams using Azure, GCP and Databricks. Strong retail and consumer goods expertise and the ability to lead client conversations are central to the position. The first-year priorities are to define a holistic enterprise data strategy—a unified, governed data foundation and roadmap aligned with business priorities—and to enable AI-supported self-service BI. This includes semantic models, governed data products and natural-language analytics that help business users get trusted answers with less reliance on custom dashboards and ad hoc reporting. The architect will define and deliver target-state architecture, assess and rationalize cloud platforms, design scalable lakehouse architectures and enterprise data models, and establish master and reference data approaches. The role also covers governed semantic layers, AI-enabled analytics, pipeline and framework development, engineering standards, data quality and governance, and client and team leadership. Confiz describes its work as supporting innovative enterprise projects and products for customers that include Fortune 100 retail and CPG companies, store chains, fintech firms and startups.

Requirements

  • Bachelor's degree or equivalent in Computer Science, Information Technology or a related field.
  • 10+ years of experience in data engineering and analytics, including 3+ years in a Data Architect or Lead Architect role designing enterprise-scale data platforms.
  • Hands-on experience across Azure (ADLS, ADF, Synapse/Fabric) and GCP (BigQuery, Dataflow, Cloud Storage), with the ability to design across multi-cloud environments.
  • Deep hands-on Databricks experience, including 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, using Power BI, Tableau or Looker.
  • Experience delivering platform consolidation or migration programs, including integrating data across multiple business units or systems.
  • Business knowledge of retail and consumer packaged goods, including sales and distribution, trade promotion, demand planning, supply chain, pricing and revenue growth management.
  • Ability to connect data architecture decisions to commercial outcomes and communicate with business stakeholders.
  • Practical experience enabling self-service BI and governed data products for business users.
  • Working knowledge of GenAI for analytics, including 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 and privacy.
  • Comfort working in a client-facing role, running workshops, presenting to senior stakeholders and handling ambiguity.
  • Ability to explain architectural decisions clearly to technical and business audiences.

Responsibilities

  • Define and own the target-state data architecture and roadmap in alignment with business goals, spanning data platforms, sources and models.
  • Assess current-state Azure, GCP and Databricks platforms and recommend consolidation, migration and rationalization plans with business cases.
  • Design scalable, secure lakehouse architectures for batch and real-time data using medallion patterns and reusable data products.
  • Build enterprise and domain data models for sales, supply chain, customer/retailer, product, marketing and finance.
  • Define master and reference data approaches to harmonize products, customers, retailers and hierarchies across business units, regions and systems.
  • Architect a governed semantic layer and certified datasets for trusted self-service analytics.
  • Design and deliver AI-enabled analytics such as natural-language querying, conversational BI and AI-assisted insights.
  • Lead consolidation of overlapping dashboards and reports into reusable, governed data products.
  • Ensure data quality, lineage and metadata support accurate and explainable AI-generated answers.
  • Build and review data pipelines, models and frameworks in PySpark, SQL and Python, leading by example in code.
  • Establish engineering standards for CI/CD, infrastructure as code, testing, observability and cost optimization.
  • Conduct design and code reviews and resolve performance, reliability and data integrity issues.
  • Produce architecture documentation, decision records and reference designs.
  • Advise client business and technology stakeholders on data strategy and architecture.
  • Translate business questions into data and architecture solutions.
  • Facilitate workshops, present architecture options and trade-offs, and build agreement on decisions.
  • Identify opportunities for data and AI to create client value 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 and drive knowledge sharing and enablement.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service