Azure Data Architect

Exavalu; Kolkata District; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Exavalu in Kolkata, India, is seeking an experienced Azure Data Architect to design and deliver consumption-ready Gold layer datasets on Databricks. You will transform refined data into analytics-ready datasets supporting policy lifecycle reporting and underwriting insights.

The role demands deep expertise in Azure Data Platform, Databricks, Delta Lake, and data modelling, with strong collaboration across business and engineering teams.

Qualifications

• 15+ years of experience in Data Engineering / Data Architecture with Azure focus.
• Experience designing Databricks lakehouse and Gold layer models.
• Hands-on with Azure Databricks, ADLS, Data Factory, Delta Lake.
• Dimensional modelling experience (star/snowflake) and analytics design.
• Insurance/Policy domain experience preferred; strong governance knowledge.
• Relevant certifications (Azure Data Engineer, Databricks) preferred.

Responsibilities

• Assess and optimize Silver layer data structures; identify gaps.
• Collaborate with stakeholders on analytics use cases (policy lifecycle, claims, underwriting).
• Design scalable Gold layer models and standardize data across systems.
• Develop transformation logic, KPIs, and derived metrics.
• Build and manage Delta Lake tables in Databricks for Gold layer use.
• Tune performance with partitioning, indexing, and caching.
• Enable data consumption for Power BI and downstream products.
• Ensure data validation and governance with stakeholders.
• Drive best practices in data architecture and modelling.

Skills

Stakeholder management

Analytical thinking

Communication

Ownership mindset

Problem-solving

Education

Bachelor's or Master's in CS/IS/Data Eng

Tools

Azure Databricks

Delta Lake

ADLS

Azure Data Factory

Databricks SQL

Power BI

Job description

Role & responsibilities

• Assess and analyse existing Silver layer data structures to identify gaps and optimization opportunities
• Collaborate with business stakeholders to understand analytics and reporting use cases (policy lifecycle, Claims, underwriting, renewals, exposure, premium)
• Design scalable Gold layer data models (star schema, snowflake, or wide tables) aligned to business needs
• Standardize and harmonize data across multiple policy & Claims systems
• Develop and implement business transformation logic including KPIs, derived metrics, and aggregations
• Build and manage Delta Lake tables in Databricks for Gold layer consumption
• Optimize data pipelines and storage for performance using partitioning, indexing, caching, and query tuning
• Enable seamless data consumption for Power BI and downstream data products
• Perform data validation and reconciliation with business stakeholders to ensure accuracy and usability
• Drive best practices in data architecture, modelling, and governance

Required Skills & Competencies:

• Strong experience in Azure Data Platform (Azure Databricks, ADLS, Azure Data Factory)
• Deep expertise in Databricks (PySpark / SQL) and Delta Lake
• Proven experience in data modelling (dimensional modelling, star/snowflake schemas)
• Experience working with insurance/policy systems (Duck Creek, Guidewire, or similar) preferred
• Strong understanding of Medallion Architecture and modern Data Lakehouse design
• Hands-on experience in performance tuning and optimization in big data environments
• Experience enabling BI tools such as Power BI
• Strong stakeholder management and communication skills
• Strong problem-solving and analytical thinking
• Ability to translate business requirements into technical solutions
• Effective collaboration with business and engineering teams
• Ownership mindset with focus on delivering high-quality data products

Nice to have:

• Experience with data governance tools (e.g., Microsoft Purview)
• Knowledge of data quality frameworks and reconciliation techniques
• Exposure to domain-driven design in data platforms

Qualifications:

• 15+ years of experience in Data Engineering / Data Architecture roles, with strong focus on Azure Data Platform
• Proven experience in designing and implementing Databricks-based lakehouse architectures and Gold layer data models
• Hands-on expertise in Azure Databricks, ADLS, Azure Data Factory, and Delta Lake
• Strong background in dimensional data modeling (star schema, snowflake, wide tables) and analytics data design
• Experience working on enterprise-scale data platforms, preferably in Insurance/Policy domains
• Bachelors or Master’s degree in Computer Science, Information Systems, Data Engineering, or related field
• Relevant certifications such as Microsoft Certified: Azure Data Engineer Associate, Azure Solutions Architect Expert, or Databricks certifications are preferred

Preferred candidate profile

We are looking for an experienced Azure Data Architect to design and deliver consumption-ready, business-aligned Gold layer datasets on Databricks. The role focuses on transforming refined data into high-quality, analytics-ready datasets that support policy lifecycle reporting, underwriting insights, and downstream data products across multiple policy administration systems