IN_Manager_Data Engineer(Databricks+Guidewire)_D&A_Advisory_Pune

At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals. In business intelligence at PwC, you will focus on leveraging data and analytics to provide strategic insights and drive informed decision-making for clients. You will develop and implement innovative solutions to optimize business performance and enhance competitive advantage. Job Position Title: IN_Manager_Data Engineer(Databricks+Guidewire)_D&A_Advisory_Pune Responsibilities: Senior Data Engineer (Databricks | Insurance | Data Migration) Experience: 7–12 years Start: Immediate Joiner Preferred Role Overview We are looking for a highly skilled Senior Manager / 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. Mandatory skill sets: Databricks+Guidewire Preferred skill sets: Databricks+Guidewire Years of experience required: 7—10Years Education qualification: B.E/B.Tech/MBA/M.E/M.Tech