Senior Associate - Redshift + AI Assistant & Vector + Agentcore Runtime + MCP

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

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 AWS(Redshift + AI Assistant &Vector +Agentcore Runtime+MCP) - Senior Associate you will support data engineering work that helps turn data into usable insights through cloud-based data pipelines, integration, and transformation solutions. As a Senior Associate you will analyze complex problems, manage assigned workstreams, and build client connections while deepening your technical skills in data, analytics, and AI within our Advisory practice. In this role at PwC, you will contribute to data infrastructure and system design, apply critical thinking to address complex needs, and mentor junior team members while adapting to changing client priorities and delivery needs.

Responsibilities

- Designing and building AWS-based data pipelines and data transformation workflows for modernization programs
- Developing Redshift, Snowflake, and Databricks solutions that support analytics, reporting, and AI-enabled use cases
- Integrating data sources through ETL processes, API connections, and orchestration tools such as Apache Airflow and AWS services
- Tuning warehouse performance, optimizing queries, and improving data models for scalability and efficiency
- Applying data architecture, data quality, and data validation methods across cloud data platforms
- Implementing vector search, agent runtime, and MCP capabilities to support AI assistant solutions
- Collaborating on data engineering workstreams, translating requirements into technical deliverables, and resolving implementation issues
- Reviewing technical work, mentoring junior team members, and applying professional judgment across client delivery activities

What You Must Have

- At least a Bachelor's degree
- At least 5+ years of experience
- Oral and written proficiency in English required

What Sets You Apart

- Preference for at least one of the following fields of study: Management Information Systems, Computer and Information Science, Systems Engineering, Electrical Engineering, Chemical Engineering, Industrial Engineering, Mathematics, Statistics, Mathematical Statistics
- Demonstrating experience with AWS Redshift, vector databases, or Agentcore Runtime
- Applying AI assistant and MCP concepts in data engineering delivery
- Translating complex data requirements into practical technical solutions
- Interpreting data patterns to inform recommendations and delivery priorities
- Mentoring junior team members while navigating ambiguous workstreams

Travel Requirements

Not Specified

Job Posting End Date