Data Modeler

Industry/Sector

Specialism

Management Level

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

Job Posting End Date