PHI - Lead- Data Modeler

Prudential Health India; Mumbai; On-site; INR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Equal opportunity employer

Support for individual health requirements

Job summary

Prudential Health India is seeking a Lead / Data Modeler with 7-15 years of experience to join their team in Mumbai. This role involves developing data models for mobile apps and ensuring integration across ecosystem partners. The ideal candidate will possess strong expertise in data modeling principles and tools, as well as robust SQL skills. You will work closely with diverse teams to deliver high-quality data solutions and document all processes thoroughly. Fluent English is required, and the position is office-based only.

Qualifications

• 7 - 15 years of experience in data modeling.
• Proven hands-on experience in data modeling and transformation.
• Fluent written and spoken English.

Responsibilities

• Develop and implement data models for various applications.
• Collaborate with cross-functional teams to achieve business outcomes.
• Ensure adherence to data modeling standards and best practices.

Skills

Data modeling principles and methodologies

Data and SQL skills

Data modeling tools (ER/Studio, ERwin)

Cloud technologies (GCP)

Education

Bachelor's in computer science or equivalent

Job description

Prudential’s purpose is to be partners for every life and protectors for every future. Our purpose encourages everything we do by creating a culture in which diversity is celebrated and inclusion assured, for our people, customers, and partners. We provide a platform for our people to do their best work and make an impact to the business, and we support our people’s career ambitions. We pledge to make Prudential a place where you can Connect, Grow, and Succeed.

Lead / Data Modeler

Note: The title will depend on Experience, Expertise and Performance. So the title could be:

• (Senior Manager) Lead Data Modeler
• (Manager) Data Modeler

Deep technology role

Experience: 7 - 15 years.

Location: Mumbai and/or Bangalore.

Work from office only.

Job Profile Summary

PHI intends to build a cloud-native, microservices-oriented, loosely coupled & open technology platform, tightly aligned to the health‑insurance domain and built for reusable, change‑ready components.

The PHI platform will comprise multiple applications supporting various business functions, well‑integrated and orchestrated. Applications may be COTS vendor software, Prudential Group capabilities, or software built by the in‑house PHI engineering team.

All applications must adopt common services, platforms, architectural principles, and design patterns.

The right candidate will be accountable to deliver technology artefacts to business stakeholders in the fastest time possible, with least gaps, best quality, and clarity on how the technology and business requirements can be delivered and tested at pace, with minimal gaps, and best quality.

Requirement gaps, change requests, non‑integrated journeys, bugs in UAT, NFR failures – all these would signal poor quality deliverables by this candidate.

Responsibilities

• Deeply understand the long‑term architectural direction, emphasizing reusable components and interactions between applications.
• Work closely with data engineers, software engineers, data architects, solution designers, R&D, analysts, product managers, and other teams to achieve desired outcomes for the company considering functionality, interoperability, performance, scalability, reliability & availability.
• Design, develop, test, and implement data models supporting mobile apps, SDKs, micro‑frontends, WhatsApp, and ecosystem partners; establish standards for platform development.
• Align data modeling and open APIs to enable seamless integration across ecosystem partners.
• Use data‑driven insights to guide the development of programs and apps that meet user needs.
• Contribute to defining and ensuring adherence to architecture and coding standards.
• Keep up with innovation to build world‑class propositions using bleeding‑edge technologies, frameworks, and best practices.
• Establish and enforce data modeling standards and best practices to ensure consistency, quality, and integrity of data models.
• Continuously evolve and refine data models to adapt to new business requirements, technological advancements, and data sources.
• Create and maintain comprehensive documentation for data models, including data dictionaries, entity‑relationship diagrams, and metadata.
• Optimize data models for performance, scalability, and reliability to ensure efficient data processing and retrieval.
• Ensure seamless integration of data models with existing data systems, databases, and data warehouses.
• Conduct thorough testing and validation of data models to ensure accuracy and consistency of data.
• Provide training and support to data users and stakeholders on data modeling concepts, tools, and best practices.

Technical Skills & Work Experience

• Proven hands‑on experience in data modeling, with a strong understanding of data modeling principles, methodologies, and tools.
• Demonstrated ability to understand technology and architectural strategy & processes and translate them into engineering solutions.
• Deep expertise in data modeling tools such as ER/Studio, ERwin, or similar; strong data and SQL skills and experience with database management systems (SQL and No‑SQL).
• Experience in large‑scale data engineering/transformation, successfully implementing data warehouses, lakes, or lake houses using cloud technologies like GCP.

Personal Traits

• Exceptional engineering skills.
• Highest standards of collaboration & teamwork.
• Strong communication skills and ability to engage senior management on strategic plans.
• Excellent problem analysis skills; innovative and creative in developing solutions.
• Hands‑on willingness; strong attention to detail.
• Ability to work independently and handle multiple concurrent initiatives.
• Excellent organizational, vendor management, negotiation, and prioritization skills.

Education

Bachelor’s in computer science, Computer Engineering or equivalent; suitable certifications for key skills.

Language

Fluent written and spoken English.

Prudential is an equal opportunity employer. We provide equality of opportunity and benefits to all who apply and who perform work for our organisation, irrespective of sex, race, age, ethnic origin, educational, social and cultural background, marital status, pregnancy and maternity, religion or belief, disability or part‑time/fixed‑term work, or any other status protected by applicable law. We encourage the same standards from our recruitment and third‑party suppliers, taking into account the context of grade, job, and location. We also allow for reasonable adjustments to support people with individual physical or mental health requirements.