Data Architect

About the role

Sonata Software, with over $1.2 Billion Revenue, is a leading AI-first Modernization Engineering company, powered by our unique PlatformationTM framework. Our 6400+ AI Engineers are helping enterprises transform from systems to intelligent business platforms leveraging partner ecosystem to drive speed, efficiency and growth. Our bouquet of Modernization Engineering Services with AI-first approach cuts across Cloud, Data, AI, Dynamics, Test Automation, and Managed Services. Sonata’s AI-led modernization is enabled by a powerful suite of proprietary tools and assets. At the core is the Harmoni.AI Enterprise Platform, which includes AgentBridge-a governance and observability framework; Agent Builder-a development toolkit for fungible agents integrated into enterprise systems; and the Agent Marketplace-an internal ecosystem for modular, reusable agents. Headquartered in Bengaluru, India, Sonata Software has a strong global presence, including key regions US, UK, India, Malaysia, Mexico, Australia, DACH (Germany/Switzerland) & Nordics (Finland). We are a trusted partner of Fortune 500 companies in Banking, Financial Services and Insurance; Healthcare and Lifesciences; Telecom, Media, and Technology; and Retail, Manufacturing and Distribution space. Deep collaborations with partners like Microsoft, AWS, Salesforce, and Snowflake strengthen our ability to deliver cutting-edge AI solutions. Our 30+years of partnership with Microsoft, and being part of the elite Microsoft Inner Circle, places us among the top 1% of global Microsoft partners. Sonata is now among the first companies to earn the Microsoft Frontier Partner Badge Also; Sonata Software is proud to achieve AWS Premier Tier Status in the AWS Partner Network.

Job Title

Data Architect

Location

Lake Forest, IL (Onsite once every 2 months)

Duration

6 Months

Contract

Full-time

Key Responsibilities

• Retail Data Strategy & Architecture
  • Assess retailer data sources and current-state architecture.
    • Define a target-state enterprise retail data architecture.
    • Create a common retail data model (Canonical Data Model).
    • Establish a scalable "Single Source of Truth" framework.
    • Create data integration standards across retailer ecosystems.
  • Retail Data Integration
    • Lead integration of retailer data feeds including: Walmart Scintilla/Luminate, Target RBD/VIQ, Kroger 84.51 / Stratum, Sam's Club MAP, additional retailer data sources.
    • Design ingestion patterns for: APIs, flat files, EDI feeds, SFTP integrations, data subscriptions, data pipelines.
  • Data Modeling
    • Design enterprise-wide: Product hierarchy models, inventory models, customer/retailer models, store hierarchy models, supply chain models, sales and demand models.
    • Create canonical definitions for: sell-through, on-hand inventory, in-transit inventory, weeks of supply, fill rate, OTIF, forecast accuracy.
  • Data Governance
    • Define data quality framework.
    • Establish KPI governance.
    • Design metadata management processes.
    • Create business glossary and data catalog structures.
    • Support Master Data Management (MDM) strategy.
  • Analytics Enablement
    • Arcitect data structures supporting: Power BI, Tableau executive dashboards, commercial analytics, supply chain analytics, AI/ML use cases.

  Must-Have Retail Experience

  • Mandatory Retail / CPG Experience
    • 10+ years working in: Consumer Packaged Goods (CPG) Retail Analytics, Retail Supply Chain, Retail Data Platforms.

  Must-Have Technical Capabilities

  • Data Architecture Expert Level
    • Enterprise Data Architecture
    • Data Lake Architecture
    • Data Warehouse Architecture
    • Canonical Data Modeling
    • Data Vault 2.0 (preferred)
  • Cloud Data Platforms
    • Must Have Experience With At Least One Microsoft Azure (Preferred)
    • AWS
    • Google Cloud
  • Data Engineering & Integration
    • ETL / ELT Architecture
    • API Integration
    • Event-driven Architecture
    • Batch Processing
    • Data Pipeline Design
    • Tools: Azure Data Factory, Databricks, Informatica, Talend, SSIS, Kafka (preferred)
  • Retail Data Modeling Expertise
    • Candidate Must Understand Inventory Metrics: On-Hand Inventory, Available Inventory, Safety Stock, In-Transit Inventory, Weeks of Supply, Sales Metrics, POS Sales, Sell-In, Sell-Through, Unit Velocity, Supply Chain Metrics, OTIF, Fill Rate, Forecast Accuracy, Replenishment Metrics.
  • Data Governance & MDM
    • Must Have Data Quality Frameworks
    • Data Lineage
    • Metadata Management
    • Master Data Management
    • Data Catalog Implementation
    • Tools: Preferred Microsoft Purview, Collibra, Alation
  • Analytics & Reporting
    • Must Have Understanding Of Power BI, Tableau, Semantic Models, KPI Framework Design, Executive Dashboards
    • Preferred Technologies: Azure AI Services, Azure Machine Learning, Databricks ML

  Soft Skills / Consulting Skills

  • Executive stakeholder management
  • Cto/Cio level communication
  • Retail business process understanding
  • Workshop facilitation
  • Architecture governance
  • Vendor management
  • Ability To Translate Retail Business Problem → Data Architecture → Technology Solution → Business Outcome

  One-Line Requirement

  We need a Data Architect who has previously built a unified retail data platform across multiple retailer ecosystems and can rapidly design a scalable Single Source of Truth architecture for commercial, inventory, and supply chain analytics.

  Why join Sonata Software?

  • Outstanding opportunity to use skills and imagination to push boundaries and solve complex problems.
  • Challenging work in a diverse team environment.
  • Opportunity to build innovative solutions for Fortune 500 companies.
  • Collaborative culture with deep partnerships and a commitment to excellence.
  • Equal Opportunity Employer encouraging diversity.

  What Success Looks Like in the First 90 Days

  • Assess all retailer data sources and current architecture.
  • Define a Retail Canonical Data Model.
  • Produce target-state architecture and roadmap.
  • Create retailer-to-canonical mapping framework.
  • Define enterprise KPI definitions.
  • Deliver MVP architecture for Walmart and Target integration.
  • Establish foundation for a Retail Single Source of Truth platform.

  One-Line Requirement

  We need a Data Architect who has previously built a unified retail data platform across multiple retailer ecosystems and can rapidly design a scalable Single Source of Truth architecture for commercial, inventory, and supply chain analytics.