IN-Senior Associate-AWS/ETL D&A Advisory Gurgaon

Line of Service

Advisory

Industry/Sector

FS X-Sector

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals.

In business intelligence at PwC, you will focus on leveraging data and analytics to provide strategic insights and drive informed decision-making for clients. You will develop and implement innovative solutions to optimise business performance and enhance competitive advantage.

*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 – Senior Associate - Data and Analytics Consulting 

 

Responsibilities: 

 

Role : Sr. Associate  

Exp : 2-5 years 

 

PwC India is seeking a talented AWS Data Engineer to join our team in Mumbai or Gurgaon. The ideal candidate will have 2-5 years of experience with a strong focus on AWS services, data engineering, and analytics. This role offers an exciting opportunity to work on cutting-edge projects for global clients while leveraging your expertise in cloud technologies and data management. 

 

Key Responsibilities: 

1. AWS Service Implementation: 

· Design, develop, and maintain data solutions using AWS services, with a particular focus on S3, Athena, Glue, EMR, and Redshift. 

· Implement and optimize data lakes and data warehouses on AWS platforms. 

2. Data Pipeline Development: 

· Create and maintain efficient ETL processes using PySpark and other relevant tools. 

· Develop scalable and performant data pipelines to process large volumes of data. 

· Implement data quality checks and monitoring systems to ensure data integrity. 

3. Database Management: 

· Proficient with SQL and NoSQL databases, optimizing queries and database structures for performance. 

· Design and implement database schemas that align with business requirements and data models. 

4. Performance Optimization: 

· Continuously monitor and optimize the performance of data processing jobs and queries. 

· Implement best practices for cost optimization in AWS environments. 

· Troubleshoot and resolve performance bottlenecks in data pipelines and analytics processes. 

5. Collaboration and Documentation: 

· Work closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions. 

· Develop and maintain comprehensive documentation for data architectures, processes, and best practices. 

· Participate in code reviews and contribute to the team's knowledge base. 

 

Required Qualifications: 

· Bachelor's or Master's degree in Computer Science, Information Technology, or a related field. 

· 2-5 years of experience in data engineering, with a focus on AWS technologies. 

· Strong hands-on experience with AWS services, particularly S3, Athena, Glue, EMR, and Redshift. 

· Proficiency in Python and PySpark for data processing and analysis. 

· Extremely good with SQL/PL SQL 

· Demonstrated ability to optimize data pipelines and queries for performance. 

· Strong problem-solving skills and attention to detail. 

 

Preferred Skills: 

· AWS certifications (e.g., AWS Certified Data Analytics - Specialty, AWS Certified Solutions Architect). 

· Familiarity with data visualization tools (e.g., Tableau, Power BI). 

· Experience with data modeling and data warehouse concepts. 

· Innovation thinking and creativity in solution delivery 

 

 

Mandatory skill sets: 

 

- AWS/ETL 

 

Preferred skill sets: 

 

- AWS/ETL 

 

 

Years of experience required: 

 

2-5 years 

Education qualification: 

 

BE/BTech/MBA/MCA 

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

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

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Extract Transform Load (ETL)

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Business Case Development, Business Data Analytics, Business Intelligence and Reporting Tools (BIRT), Business Intelligence Development Studio, Communication, Competitive Advantage, Continuous Process Improvement, Creativity, Data Analysis and Interpretation, Data Architecture, Database Management System (DBMS), Data Collection, Data Pipeline, Data Quality, Data Science, Data Visualization, Embracing Change, Emotional Regulation, Empathy, Inclusion, Industry Trend Analysis {+ 12 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date