Data Architect

About Sonata Software

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

Data Architect – Retail Data Integration & Single Source of Truth

This role requires a unique combination of retail domain knowledge, data architecture expertise, cloud data platform experience, and stakeholder management capabilities.

Key Responsibilities

Retail Data Strategy & Architecture

• Assess retailer data sources and current-state architecture.
• Define a target-state enterprise retail data architecture.
• Design 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 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

• Architect 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
• Lakehouse Architecture
• Data Warehouse Architecture
• Canonical Data Modeling
• Dimensional Modeling (Star Schema)
• Data Vault 2.0 (preferred)
  
  

Deliverables Expected

• Conceptual Data Model
• Logical Data Model
• Physical Data Model
• Enterprise Data Flow Architecture
• Cloud Data Platforms
  
  

Must Have

Experience With At Least One

• Microsoft Azure (Preferred)
• AWS
• Google Cloud
  
  

Strong Preference

Azure Stack

• Azure Data Factory
• Azure Synapse
• Azure Data Lake Gen2
• Microsoft Fabric
• Azure Databricks
• Azure SQL
• Data Engineering & Integration
  
  

Must Have

• 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
• AI & Advanced Analytics (Preferred)
  
  

Experience Enabling

• Demand Forecasting
• Inventory Optimization
• Predictive Analytics
• Machine Learning Data Platforms
• GenAI-enabled Insights
  
  

Preferred Technologies

• Azure AI Services
• Azure Machine Learning
• Databricks ML
  
  

Soft Skills / Consulting Skills

Must Have

• 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

Ideal Candidate Profile

Experience

• 12-15 years overall experience
• 5 years as Lead Data Architect
• Retail/CPG domain experience
• Large-scale enterprise data platform implementations
  
  

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."

Why join Sonata Software?

At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.

Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.