Data Architect San Antonio, Texas, United States 12
- 15 Years Permanent Apply Now Job Description
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 1. 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 2. 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 3. 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) 4. 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 5. Data Governance & MDM Must Have Data Quality Frameworks Data Lineage Metadata Management Master Data Management Data Catalog Implementation Tools preferred: Microsoft Purview Collibra Alation 6.
Analytics & Reporting Must Have Understanding of:
Power BI Tableau Semantic Models KPI Framework Design Executive Dashboards 7. 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. Job Snapshot Updated Date 18-06-2026 Job
ID SSNA-26-27-100
Department Data & Analytics MS Location San Antonio, Texas, United States Experience 12
- 15 Years Employee Type Permanent Job Description
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 1. 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 2. 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 3. 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) 4. 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 5. Data Governance & MDM Must Have Data Quality Frameworks Data Lineage Metadata Management Master Data Management Data Catalog Implementation Tools preferred: Microsoft Purview Collibra Alation 6.
Analytics & Reporting Must Have Understanding of:
Power BI Tableau Semantic Models KPI Framework Design Executive Dashboards 7. 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. Share the opportunity View Similar Jobs Powered by: darwinbox | Privacy Policy
