Data Architect

Sonata Software North America Inc.; Brentford; On-site; GBP 90,000 - 140,000; Full time

Job summary

Sonata Software North America Inc. is seeking a seasoned Data Architect to lead enterprise data architecture in a complex Microsoft Azure environment from Exeter, UK. The role demands hands-on expertise with Databricks, Delta Lake, and Power BI connectivity to Databricks SQL Warehouses.

Immediate joining and permanent employment offered. You will engage senior stakeholders and shape governance, security, and data strategy across on‑prem and cloud data sources using Azure Gen2, Unity Catalog, and

Qualifications

• 8+ years data architecture experience with Azure Databricks in production.
• Experience designing medallion architecture (Bronze/Silver/Gold) with Delta Lake on Databricks.
• Strong hands-on experience with Unity Catalog — metastore setup, catalog and schema design, access controls, governance.

Responsibilities

• Engage Architecture Council, CIO, CDO level and present technical findings in business terms.
• Lead governance and design reviews with senior stakeholders to ensure alignment with business objectives.

Skills

Azure Databricks

Delta Lake

Unity Catalog

Azure Data Lake Gen2

Power BI connectivity

MS SQL Server

Oracle Database

Apache Spark

PySpark

Scala

Databricks Unity Catalog

Databricks Workflows

Databricks Asset Bundles

Delta Live Tables

Azure Data Factory

TOGAF

Tools

Azure Data Factory

Delta Live Tables

Databricks Workflows

Databricks Asset Bundles

Job description

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

• 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

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.