Manager

Job Role: Senior Data Engineer (Databricks | Insurance | Data Lakehouse)

Location: Mumbai (Preferred) / Bangalore

Experience: 7–12 years

Start: Immediate Joiner Preferred

Role Overview

We are looking for a highly skilled Manager /Senior Data Engineer with deep expertise in Databricks data management, logical & physical data modelling, and insurance domain data workflows. The candidate will work on a strategic data migration initiative for a leading UK-based insurance company, moving data from Guidewire into Databricks Silver and Gold layers with strong governance, lineage, and scalability standards.

Key Responsibilities

Databricks Data Engineering & Management

• Design, build, and optimize Silver and Gold layer data pipelines in Databricks using PySpark, SQL, Delta Lake, and Workflow orchestration.
• Implement data quality, lineage, schema evolution, and governance controls across curated layers.
• Optimize Databricks jobs for performance, scalability, and cost efficiency.

Guidewire Databricks Migration

• Lead the end-to-end migration of large-scale insurance data from Guidewire PolicyCenter/ClaimCenter/BillingCenter into Databricks.
• Map and transform complex Guidewire entity structures into normalized and star-schema models.

Data Modelling & Architecture

• Develop robust logical and physical data models aligned to insurance business processes.
• Build high-quality curated data marts (Gold) for analytics, reporting, pricing, underwriting, and claims.
• Define standards for metadata, naming conventions, partitioning, and model documentation.

Insurance Domain Expertise

• Understand core insurance data entities such as policy, claims, billing, customer, underwriting, rating, and product hierarchies.
• Apply domain knowledge to rationalize Guidewire data structures and create business-ready datasets.

Solutioning & Ideation

• Collaborate with client SMEs, architects, and business analysts to shape data solutions and propose design improvements.
• Ability to ** ideate, simplify complex data flows**, and contribute to overall solution architecture.

Required Skills & Experience

Technical

• 7–12 years of experience in data engineering, data modelling, and data management.
• Strong hands-on experience in Databricks, Delta Lake, PySpark, Spark SQL, and ETL/ELT pipelines.
• Expertise in logical & physical data modelling (3NF, Star Schema, Data Vault preferred).
• Practical knowledge of Guidewire data model and prior migration experience (mandatory).
• Experience working with large-scale insurance datasets
• Strong understanding of data quality frameworks, lineage, cataloging, and governance.

Soft Skills

• Strong problem-solving and conceptualization / ideation capability.
• Excellent communication and stakeholder-management for UK client environment.
• Ability to work in fast-paced delivery tracks with cross-functional global teams.

Preferred Qualifications

• Certifications in Databricks, Azure/AWS, and Data Warehousing are added advantages.
• Experience delivering enterprise-grade data lakes or lakehouse architectures.

Why Join This Role

• Work on a flagship insurance data modernisation project for a top UK carrier.
• Opportunity to shape enterprise-scale data models on the Databricks Lakehouse.
• High-visibility role with strong career growth in insurance data engineering.