Data Architect

Sonata Software (SonataOne); Brentford, Manchester; Hybrid; GBP 90,000 - 140,000; Full time

Job summary

Sonata Software is seeking a Data Architect for a permanent hybrid role in the UK. The candidate will lead data architecture with extensive Azure Databricks experience, including Delta Lake medallion patterns and Unity Catalog governance.

You will collaborate with senior stakeholders and ensure secure data lake implementations in a Microsoft-centric environment. The position requires 12–15+ years of experience, immediate joining, and office-based work three days per week.

Qualifications

• 8+ years of data architecture experience 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 — Mirrored Azure Databricks Unity Catalog and Power BI connectivity to Databricks SQL Warehouses.
• Experience with MS SQL Server 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.

Skills

Azure Databricks

Medallion Architecture

Unity Catalog governance

Azure Data Lake Storage Gen2

Microsoft Fabric

MS SQL Server / Oracle ingestion

Apache Spark (PySpark/Scala)

Stakeholder engagement

Data governance & security

Vendor transition experience

Tools

Azure Databricks

Delta Lake

Power BI

Azure Data Factory

Job description

Permanent

Job Description

Role: Data Architect

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
• 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

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.

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

09-10-2026

Job ID

Department

Data & Analytics OS

Location