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 Platformation TM 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 Agent Bridge-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.

Role: Data Architect Location: Onsite (Exeter, Devon EX2 7HR - UK) Mode of hire: work from office 3 days in a week Engagement: Permanent Experience: 12–15+ years Joining: Immediate Required Skills & Experience Must Have

• 8+ years of data architecture experience with at least 3 years hands-on with Azure Databricks in production environments
• Proven experience designing and implementing medallion architecture (Bronze / Silver / Gold) using Delta Lake on Azure Databricks
• Strong hands-on experience with Unity Catalog — metastore setup, catalog and schema design, access controls, and governance policies
• Experience configuring Azure Data Lake Storage Gen2 — containers, access control lists, lifecycle policies, and integration with Databricks
• Hands-on experience with Microsoft Fabric — specifically Mirrored Azure Databricks Unity Catalog and Power BI connectivity to Databricks SQL Warehouses
• Experience with enterprise data source integration — MS SQL Server (on-premises and Azure SQL) and Oracle Database ingestion into Azure landing zones
• Strong Apache Spark skills — PySpark or Scala, optimisation, partitioning, and job scheduling in Databricks
• Experience assessing and remediating partially built or vendor-abandoned data platform implementations
• Proven ability to engage senior stakeholders — Architecture Council, CIO, CDO level — presenting technical findings in clear business language Highly Desirable
• Experience in the utilities, water, or regulated infrastructure sector — understanding of operational data, compliance requirements, and safety-critical system considerations
• Familiarity with Lakehouse Federation in Azure Databricks — federating queries across external data sources without full ingestion
• Experience with Azure Data Factory or equivalent ETL/ELT tooling for enterprise source ingestion pipelines
• Exposure to Delta Live Tables (DLT) for declarative pipeline management
• Experience with Power BI data modelling and DirectQuery / Import mode considerations for Databricks SQL Warehouse connectivity
• Familiarity with Azure Key Vault for secrets management and secure credential handling in Databricks
• Prior experience in a vendor transition or rescue engagement — inheriting and assessing another vendor's technical work
• Knowledge of Databricks Asset Bundles or Databricks Workflows for job orchestration
• TOGAF or equivalent enterprise architecture certification 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.