Architect / Data Modeler- Senior Manager

PwC Acceleration Center India; Bengaluru; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

PwC Acceleration Center India is seeking a Senior Manager in Data Engineering to lead the development and execution of data strategies. The role focuses on creating customer-centric data solutions and mentoring team members to achieve project goals.

Ideal candidates must have a Bachelor’s degree in Engineering or Technology and 12-16 years of relevant experience. Proficiency in data modeling, cloud technologies, and strong SQL skills are essential.

Qualifications

• 12-16 years of experience in data engineering and modeling.
• Proficiency in cloud technologies.
• Strong skills in SQL and SQL procedures.

Responsibilities

• Lead the development and execution of data engineering strategies.
• Foster client relationships through strategic interactions.
• Guide and mentor team members to achieve project goals.

Skills

Data Modeling

SQL

Cloud technologies (AWS/Azure/GCP)

Data analysis and troubleshooting

Analytical skills

Communication skills

Education

Bachelor's Degree in Engineering or Technology

Tools

ER/Studio

Erwin Data Modeler

Oracle SQL Developer

Job description

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 model 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 SQL 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 Oracle

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 stakeholders

What You Must Have

• Bachelor's Degree in Engineering or Technology with 12‑16 years of experience
• Oral and written proficiency in English necessary

What 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