IN_Senior Associate_Data Modeling_Data and Analytics_Advisory_Gurgaon at pwc

Gurugram, haryana, India -

Full Time

Start Date

Immediate

Expiry Date

30 Jun, 26

Salary

0.0

Posted On

01 Apr, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Modeling, SQL, Data Warehousing, Dimensional Modeling, Data Integration, Insurance Domain Knowledge, ERwin Data Modeler, Data Analysis, Data Governance, Data Lakes, PostgreSQL, Redshift, Oracle, SQL Server, ETL Processes, Data Integrity

Industry

Professional Services

Description

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 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. " 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: MBA (Master of Business Administration), Master of Engineering, Bachelor of Engineering Degrees/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 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 role involves designing and maintaining enterprise-level data models that support data warehousing, reporting, analytics, and regulatory needs within insurance business functions. The candidate will work closely with business stakeholders, data engineers, and architects to ensure data models accurately reflect insurance processes.