Data Architect

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

• 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

• 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 Direct Query / 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

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,…