INSenior AssociateData ModelingData and AnalyticsAdvisoryGurgaon
Share
Job Location:
Monthly Salary:
Posted on:
3 days ago
Vacancies:
1 Vacancy
Job Summary
Line of Service
AdvisoryIndustry/Sector
Not ApplicableSpecialism
Data Analytics & AIManagement Level
Senior AssociateJob 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.
Job Description & Summary:
We are seeking an experienced Data Modeler with strong handson expertise in ERwin Data Modeler and a solid background in the Insurance domain. The role involves designing and maintaining enterpriselevel 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 handson 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 MCA 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 EngineeringDegrees/Field of Study preferred:Certifications (if blank certifications not specified)
Required Skills
Data ModelingOptional 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 moreDesired Languages (If blank desired languages not specified)
Travel Requirements
Available for Work Visa Sponsorship
Government Clearance Required
Job Posting End Date
May 15 2026Required Experience:
Senior IC
About Company
At PwC, our purpose is to build trust in society and solve important problems. We’re a network of firms in 155 countries with over 284,000 people who are committed to delivering quality in assurance, advisory and tax services. Find out more and tell us what matters to you by vis ... View more
