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

📌 Azure Data Architect (Kolkata)
🏢 Exavalu
📍 Kolkata