IN_Senior Manager_Data Engineer_D&A_Advisory_Mumbai at pwc

Mumbai, maharashtra, India -

Full Time

Start Date

Immediate

Expiry Date

01 May, 26

Salary

0.0

Posted On

31 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Engineering, Databricks, Data Modelling, Data Management, PySpark, SQL, Delta Lake, ETL, Insurance Domain, Data Quality, Stakeholder Management, Problem Solving, Communication, Collaboration, Data Migration, Data Architecture

Industry

Professional Services

Description

Line of Service Advisory Industry/Sector Not Applicable Specialism Data, Analytics & AI Management Level Managing Director Job Description & Summary 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 optimise business performance and enhance competitive advantage. Why PWC At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us. At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. 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. 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 Migration 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. Mandatory skill sets: Data Engineer/Insurance/Databricks Preferred skill sets: Data Engineer/Insurance/Databricks Years of experience required: 7—12 Years Education qualification: B.E.(B.Tech)/M.E/M.Tech Education (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Bachelor of Engineering, Bachelor of Technology Degrees/Field of Study preferred: Certifications (if blank, certifications not specified) Required Skills Data Engineering Optional Skills Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Applied Macroeconomics, Business Case Development, Business Data Analytics, Business Intelligence and Reporting Tools (BIRT), Business Intelligence Development Studio, Coaching and Feedback, Communication, Competitive Advantage, Continuous Process Improvement, Creativity, Data Analysis and Interpretation, Data Architecture, Database Management System (DBMS), Data Collection, Data Pipeline, Data Quality, Data Science, Data Visualization, Embracing Change, Emotional Regulation, Empathy {+ 37 more} Desired Languages (If blank, desired languages not specified) Travel Requirements Up to 40% Available for Work Visa Sponsorship? No Government Clearance Required? No Job Posting End Date Are you ready to make a difference? Want to unlock new value by applying your unique perspective and talents? You can grow exponentially at PwC. Here, you can uncover hidden talents, build lifelong relationships rooted in trust and empathy and turn challenges into opportunities for innovation. We’ll help you grow your skills through challenging, meaningful work so you can go further.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The Senior Manager will design, build, and optimize data pipelines in Databricks and lead the migration of insurance data from Guidewire. They will also develop robust data models and collaborate with client SMEs to propose design improvements.