Architect / Data Modeler- Senior Manager

PwC; Bengaluru; On-site; INR 4,000,000 - 7,500,000; Full time

Job summary

PwC Acceleration Centers in Bengaluru seeks a Senior Manager in Data Engineering to lead data infrastructure projects, design scalable pipelines, and drive data-driven decision making. You will shape architecture, mentor a delivery team, and ensure cloud-enabled data solutions meet client needs while maintaining PwC’s standards of quality and security.

The role emphasizes data modeling, SQL proficiency, and collaboration with business and tech teams to deliver high-impact data products.

Qualifications

• Bachelor’s degree in Engineering or related field with extensive data engineering experience.
• Demonstrated leadership of technical teams and data modeling initiatives.
• Hands-on experience with cloud data platforms and SQL tuning.

Responsibilities

• Lead development and execution of data engineering strategies.
• Ensure customer-centric data solutions aligned with PwC vision.
• Utilize data modeling and cloud tech to drive project success.
• Maintain operational excellence through innovative processes.
• Guide and mentor team members to achieve goals.
• Foster client relationships through strategic interactions.
• Identify opportunities for process improvements and implement changes.
• Communicate complex technical concepts to diverse stakeholders.

Skills

Team leadership

Data Modeling

Cloud technologies

SQL

Data Warehouses

ETL pipelines

Big Data tools

Communication

Education

Bachelor’s Degree in Engineering

Master’s Degree preferred

Tools

ER/Studio

Erwin Data Modeler

Oracle SQL Developer

Job description

Industry/Sector

Not Applicable

Specialism

Product Innovation

Management Level

Senior 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.

Preferred Knowledge/Skills :

• Demonstrates intimate abilities and/or a proven record of success as a team leader:
• Experience in Data Modeling and responsible for the development of the conceptual, logical, and physical data mode the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platform (SQL/NoSQL);- Implement business and IT data requirements through new data strategies and designs across all data platform (relational, dimensional, and NoSQL) and data tools (reporting, visualization);- 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 brick 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;- Ability to adapt quickly to an existing, complex environment and learn new concepts and software;- Self-motivated, independent, detail oriented, responsible team player and exhibit exceptional relationship management skills;- Business / domain knowledge in one of the domains -Financial Services/ Healthcare/ Consumer Market/Industrial Products/ Telecommunication,Media and Technology /Deal advisory along with technical expertise;- Experience in leading technical teams, guiding and mentoring team members;- Good analytical & problem-solving skills;- Strong Data modeling skills utilizing one of the industry leading tools like ER/Studio, Erwin Data Modeler, Oracle SQ Developer etc.;- Strong knowledge and experience in SQL and SQL procedures for data analysis, extraction and manipulation;- Strong experience in Database SQL tuning and performance improvement;- Experience with multiple relational databases platforms like Ora

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 Engineering team you are expected to lead the creation and implementation of impactful data solutions. As a Senior Manager you are expected to guide the execution of our Data Engineering Strategy, maintaining a customer-centric approach that supports PwC’s goals and vision. You are expected to leverage your proficiency in Data Modeling and cloud technologies to drive project success and maintain operational excellence.Responsibilities

Lead the development and execution of data engineering strategies

Assure customer-centric data solutions align with PwC’s vision

Utilize proficiency in data modeling and cloud technologies to drive success

Maintain operational excellence through innovative processes

Guide and mentor team members to achieve project goals

Foster client relationships through strategic interactions

Identify opportunities for process improvements and implement changes

Communicate complex technical concepts to diverse stakeholdersWhat You Must Have

Bachelor’s Degree in Engineering, Technology- 12 years of experience with 12-16 years of experience preferred

Oral and written proficiency in English necessaryWhat Sets You Apart

Master’s Degree preferred

Experience in Data Modeling and development of data models

Implementing business and IT data requirements

Advanced skills in SQL and SQL Procedure builds

Experience in Cloud technologies

Advanced analytical and troubleshooting skills

Exceptional communication skills

Business/domain knowledge in various domains

Travel Requirements

Not Specified

Job Posting End Date