Senior Data Modeling Associate

IN_Senior Associate_Data Modeling_Data and Analytics_Advisory_Gurgaon

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

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 data analysis at PwC, you will focus on utilising advanced analytical techniques to extract insights from large datasets and drive data-driven decision-making. You will leverage skills in data manipulation, visualisation, and statistical modelling to support clients in solving complex business problems.*Why PWCAt 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. "

Job Description & Summary:

We are seeking an experienced Data Modeler with strong hands‑on expertise in ERwin Data Modeler and a solid background in the Insurance domain. The role involves designing and maintaining enterprise‑level data models that support data warehousing, reporting, analytics, and regulatory needs within insurance business functions.

The ideal candidate will work closely with business stakeholders, data engineers, and architects to ensure data models accurately reflect insurance processes and are aligned with enterprise data standards.

Responsibilities

Data Modeling & Design

• Design and maintain conceptual, logical, and physical data models using ERwin Data Modeler
• Translate insurance business requirements into scalable and compliant data models
• Define entities, attributes, relationships, constraints, and naming conventions
• Support enterprise reporting and analytics use cases

Insurance Domain Modeling

• Develop data models for insurance domains such as Policy, Claims, Underwriting, Billing, Reinsurance, Customer, and Products
• Understand and model insurance data flows across upstream and downstream systems
• Support regulatory and compliance-driven data requirements
• Perform impact analysis for changes across insurance data structures

Data Warehouse & Database Support

• Create and maintain data models for Data Warehouse / Data Lake environments
• Support dimensional modeling (fact and dimension tables) for analytics
• Optimize models for performance, scalability, and data integrity
• Work with databases such as PostgreSQL, Redshift, Oracle, SQL Server, or similar

Governance & Collaboration

• Collaborate with business, data engineering, and architecture teams
• Ensure adherence to enterprise data governance and modeling standards
• Maintain data dictionaries, metadata, and ERwin model documentation
• Support schema versioning and lifecycle management

Required Skills & Qualifications

Technical Skills

• Strong hands‑on experience with ERwin Data Modeler (mandatory)
• Excellent understanding of data modeling concepts (conceptual, logical, physical)
• Experience with data warehousing and dimensional modeling
• Proficiency in SQL
• Experience with relational databases (Postgres, Redshift, Oracle, SQL Server, etc.)
• Understanding of ETL processes and data integration

Domain Experience

• Mandatory experience in the Insurance domain
• Strong understanding of insurance business processes and data structures
• Experience working with policy, claims, underwriting, or related insurance datasets

Mandatory Skill sets:

Data Modeling

Preferred Skill sets:

Data Modeling

Years of Experience Required:

4-7 years

Education Qualification:

BE, B.Tech, MCA, M.Tech, MBA

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required: Bachelor of Engineering, MBA (Master of Business Administration), Master of EngineeringDegrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Data Modeling

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Algorithm Development, Alteryx (Automation Platform), Analytical Thinking, Analytic Research, Big Data, Business Data Analytics, Communication, Complex Data Analysis, Conducting Research, Creativity, Customer Analysis, Customer Needs Analysis, Dashboard Creation, Data Analysis, Data Analysis Software, Data Collection, Data-Driven Insights, Data Integration, Data Integrity, Data Mining, Data Modeling, Data Pipeline {+ 38 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date

May 15, 2026

Experience Level

Senior Level