Data Engineer- Senior Associate

PwC Acceleration Center India; Hyderabad; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

PwC Acceleration Center India is seeking a Data Engineer- Senior Associate to design and build scalable data infrastructure for diverse client needs. You will develop ETL/ELT pipelines, integrate data from Oracle, MongoDB, and lakehouse platforms, and transform raw data into actionable insights.

The role emphasizes collaboration with internal teams, applying AI-ready data pipelines, and mentoring junior engineers while advancing technical skills in a dynamic, globally connected environment.

Qualifications

• Bachelor degree required.
• 4-9 years of experience preferred.
• Proficient English communication (oral & written).

Responsibilities

• Designing and building data infrastructure for processing and analysis.
• Implementing data pipelines, integration, and transformation solutions.
• Developing data models across multiple databases and lakehouse platforms.
• Collaborating with stakeholders to align data solutions with business goals.
• Mentoring junior team members and contributing to best practices.

Skills

Oracle SQL

MongoDB

Databricks

Apache Spark

PySpark

Python

Data pipelines

Data modeling

Education

Bachelor degree

Tools

Databricks

Delta Lake

Spark SQL

Oracle Database

Job description

Job Description:

The Opportunity

Join our Acceleration Center India and help shape the future of business for our diverse client portfolio across geographies and jurisdictions. You’ll work at the heart of global teams across Advisory, Assurance, Tax and Business Services - solving real client challenges through connected collaboration. We’ll help you grow your skills so you can go further. With hands-on learning, cutting-edge tools and an inclusive culture, this is your opportunity to do inspiring work that makes a difference - every day.

As a Data Engineer- Senior Associate, you will focus on designing and building data infrastructure and systems to enable efficient data processing and analysis. Within our Internal Firm Services practice, you will transform raw data into actionable insights, enabling informed decision-making and driving business growth. As a Senior Associate, you will build meaningful client connections and learn how to manage and inspire others. You will navigate increasingly complex situations, growing your personal brand and technical skills. You are expected to anticipate the needs of your teams and clients, delivering quality work. Embracing increased ambiguity, you will be comfortable when the path forward isn’t clear, using these moments as opportunities to grow.

In this role at PwC Acceleration Center India, you will develop and implement data pipelines, data integration, and data transformation solutions. You will use a broad range of tools and methodologies to generate new ideas and solve problems. By interpreting data, you will inform insights and recommendations, upholding professional and technical standards. This position offers a chance to deepen your understanding of the business context and how it is evolving, while building relationships and enhancing your skills.

Responsibilities

• Designing and developing data infrastructure and systems to facilitate efficient data processing and analysis
• Implementing data pipelines, integration, and transformation solutions to support client needs
• Leveraging advanced technologies and techniques to convert raw data into actionable insights
• Collaborating with internal stakeholders to understand project objectives and align data solutions with business strategies

Design and develop reliable ETL/ELT pipelines using SQL, Python, PySpark, and Databricks.

• Build and maintain data models across Oracle, relational databases, MongoDB, and lakehouse platforms.
• Develop and optimize complex SQL queries, stored procedures, views, indexes, and database objects.
• Administer databases, including user access, security, backup and recovery, monitoring, patching, and performance tuning.
• Build Databricks workflows using Spark SQL, Delta Lake, and medallion data layers.
• Prepare structured and unstructured data for analytics, machine learning, and Generative AI applications.
• Support AI use cases involving embeddings, vectorization, semantic search, vector databases, and Retrieval-Augmented Generation (RAG).
• Implement data-quality checks, metadata management, security controls, and data-governance standards.
• Troubleshoot production database and data-pipeline issues and perform root-cause analysis.
• Collaborate with data architects, application teams, analysts, data scientists, and AI engineers.
• Mentor junior team members and contribute to data engineering and database best practices.

What You Must Have

• Minimum bachelor degree
• At least 4-9 years of experience
• Oral and written proficiency in English required

What Sets You Apart

• Strong hands-on experience with Oracle Database, SQL, and PL/SQL.
• Experience with relational database design, query optimization, indexing, partitioning, and performance tuning.
• Working knowledge of MongoDB, including document modeling, aggregation, indexing, and administration.
• Experience with Databricks, Apache Spark, Spark SQL, PySpark, and Delta Lake concepts.
• Experience building batch or near-real-time data pipelines.
• Knowledge of database administration, including backup, recovery, security, monitoring, migration, and high availability.
• Understanding of AI-ready data pipelines, embeddings, vector search, similarity matching, and vector databases.
• Proficiency in Python or another data-engineering scripting language.
• Strong analytical, troubleshooting, communication, and documentation skills.

Strong hands-on experience with Oracle Database, SQL, and PL/SQL.

• Experience with relational database design, query optimization, indexing, partitioning, and performance tuning.
• Working knowledge of MongoDB, including document modeling, aggregation, indexing, and administration.
• Experience with Databricks, Apache Spark, Spark SQL, PySpark, and Delta Lake concepts.
• Experience building batch or near-real-time data pipelines.
• Knowledge of database administration, including backup, recovery, security, monitoring, migration, and high availability.
• Understanding of AI-ready data pipelines, embeddings, vector search, similarity matching, and vector databases.
• Proficiency in Python or another data-engineering scripting language.
• Strong analytical, troubleshooting, communication, and documentation skills.