PwC
Data Modeler
Skills
Job description
Industry/Sector
Not Applicable
Specialism
Platform Engineering & Architecture
Management Level
Manager
Job Description & Summary
At PwC, our people in data and analytics engineering focus on leveraging advanced technologies and techniques to design and develop robust data solutions for clients. They play a crucial role in transforming raw data into actionable insights, enabling informed decision-making and driving business growth.
In data engineering at PwC, you will focus on designing and building data infrastructure and systems to enable efficient data processing and analysis. You will be responsible for developing and implementing data pipelines, data integration, and data transformation solutions.
A career in our Advisory Acceleration Centre is the natural extension of PwC’s leading class global delivery capabilities. We provide premium, cost-effective, high-quality services that support process quality and delivery capability in support for client engagements.
Years of Experience
Candidates with 10-12 years of hands-on experience
Position Requirements:
Must Have
6+ years of experience in Data Modeling and responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
Deep understanding of Insurance domain knowledge.
Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization).
Lead the design, development, and implementation of insurance data models supporting interoperability and analytics
across Policy center, Billing Center and Claim Center.
Advise and collaborate closely with engineering, product, and clinical teams to ensure technical solutions meet regulatory, operational, and user requirements.
Understand and translate business needs into data models supporting long-term solutions.
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
Perform reverse engineering of physical data models from databases and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies.
Validate business data objects for accuracy and completeness.
Analyze data-related system integration challenges and propose appropriate solutions.
Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
Work with business and solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
Well versed in Data Modeling tools like ER/Studio, Erwin Data Modeler, Data Vault, Toad Data Modeler etc.,
Hands on experience of working in the Cloud technologies – AWS/Azure/GCP
End to end data and analytics solutions design experience using cloud technologies
AWS S3, Spark, EMR, Data bricks, MPP databases, Redshift/Snowflake right from Ingestion to Transformation to Consumption using various methods including API delivery or similar knowledge in alternate cloud services
Strong skills in SQL, SQL Procedure builds
Strong skills in analyzing Data Warehouse performance issues and resolutions using various methods/ techniques
Strong analytical skills and troubleshooting skills
Excellent communication skills
Desired Knowledge / Skills:
Well versed in Data Modeling tools like ER/Studio, Erwin Data Modeler, Data Vault, Toad Data Modeler etc.
Hands on experience of working in the Cloud technologies – AWS/Azure/GCP
End to end data and analytics solutions design experience using cloud technologies
AWS S3, Spark, EMR, Data bricks, MPP databases, Snowflake right from Ingestion to Transformation to Consumption using various methods including API delivery or similar knowledge in alternate cloud services
Strong skills in SQL, SQL Procedure builds
Strong skills in analyzing Data Warehouse performance issues and resolutions using various methods/ techniques
Strong analytical skills and troubleshooting skills
Professional and Educational Background:
BE / B.Tech / MCA / M.Sc / M.E / M.Tech / MBA
Additional Information:
Line of Service:
Advisory
Horizontal:
Technology Consulting
Designation:
Manager
Location:
Bangalore, India .
The Opportunity
When you join PwC Acceleration Centers (ACs), you step into a pivotal role focused on actively supporting various Acceleration Center services, from Advisory to Assurance, Tax and Business Services. In our innovative hubs, you’ll engage in challenging projects and provide distinctive services to support client engagements through enhanced quality and innovation. You’ll also participate in dynamic and digitally enabled training that is designed to grow your technical and professional skills.
As part of the Data and Analytics Engineering team you lead the design and implementation of innovative data models that drive business insights. As a Manager you motivate and inspire your team to deliver exceptional quality while managing client accounts and fostering meaningful relationships. This role offers the chance to work with cutting-edge technologies in a dynamic environment, where your leadership and strategic planning skills can shine.
Responsibilities
Design and implement data models to support business objectives
Collaborate with cross-functional teams to gather requirements and deliver solutions
Analyze and interpret data to identify trends and insights
Manage project timelines and deliverables to meet client expectations
Mentor junior team members and promote skill development
Utilize advanced analytics tools to enhance data processing capabilities
Maintain data integrity and quality throughout the modeling process
Drive innovation by exploring new technologies and methodologies
What You Must Have
Bachelor's Degree
6 years of experience
Oral and written proficiency in English required
What Sets You Apart
Bachelor's Degree in Engineering, Technology, or related field preferred
6 years of experience in Data Modeling
Hands-on experience with Cloud technologies like AWS, Azure, GCP
Skilled in Data Modeling tools like ER/Studio, Erwin
Excelling in SQL and SQL Procedure builds
Analyzing Data Warehouse performance issues
Demonstrating analytical and troubleshooting skills
Understanding of Insurance domain knowledge
Travel Requirements
Not Specified
Job Posting End Date