Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

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.

*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: A career within PWC

Responsibilities:

Job Description of the Data Modeler Role The Data Modeler will work towards design and implementation of new data structures to support the project teams delivering on ETL, Data warehouse design, managing the enterprise data model, the maintenance of the data, and enterprise data integration approaches. Technical Responsibilities · Build and maintain out of standards data models to report disparate data sets in a reliable, consistent and interpretable manner. · Gather, distil and harmonize data requirements and to design coherent Conceptual, logical and physical data models and associated physical feed formats to support these data flows. · Articulate business requirements and build source-to-target mappings having complex ETL transformation. · Write complex SQL statements and profile source data to validate data transformations. · Contribute to requirement analysis and database design - Transactional and Dimensional data modelling. Normalize/ De-normalize data structures, introduce hierarchies and inheritance wherever required in existing/ new data models. · Develop and implement data warehouse projects independently.

· Work with data consumers and data suppliers to understand detailed requirements, and to propose standardized data models. · Contribute to improving the Data Management data models. · Be an influencer to present and facilitate discussions to understand business requirements and develop dimension data models based on these capabilities and industry best practices. Requirements · Extensive practical experience in Information Technology and software development projects of with at least 5+ years of experience in designing Operational data store & data warehouse. · Extensive experience in any of Data Modelling tools – Erwin/ SAP power designer. · Strong understanding of ETL and data warehouse concepts processes and best practices. · Proficient in Data Modelling including conceptual, logical and physical data modelling for both OLTP and OLAP. · Ability to write complex SQL for data transformations and data profiling in source and target systems · Basic understanding of SQL vs NoSQL databases. · Possess a combination of solid business knowledge and technical expertise with strong communication skills. Demonstrate excellent analytical and logical thinking. · Good verbal & written communication skills and Ability to work independently as well as in a

team environment providing structure in ambiguous situation. Good to have · Understanding of Insurance Domain · Good understanding of Master Data Management, Data Quality and Data Governance. · Basic understanding of data visualization tools like SAS VA, Tableau · Good understanding of implementing & architecting data solutions using the informatica, SQL server/Oracle

Mandatory skill sets:

Data Modelor

Preferred skill sets:

Data Modelor

Years of experience required:

8-14 years

Education qualification:

BE/BTECH, ME/MTECH, MBA, MCA

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

Degrees/Field of Study required: Bachelor of Engineering, Bachelor of Technology, Master of Business Administration

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

AI Programming

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Agile Scalability, Amazon Web Services (AWS), Analytical Thinking, Apache Airflow, Apache Hadoop, Azure Data Factory, Coaching and Feedback, Communication, Creativity, Data Anonymization, Data Architecture, Database Administration, Database Management System (DBMS), Database Optimization, Database Security Best Practices, Databricks Unified Data Analytics Platform, Data Engineering, Data Engineering Platforms, Data Infrastructure, Data Integration, Data Lake, Data Modeling {+ 33 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date

IN-Manager__ BA-Data Modelor-- Data and Analytics_Advisory_Pan India

PWC

Job Description

About Company

Services you might be interested in

File Your ITR Now