Job Title

Line of Service - AdvisorySpecialization - Data, Analytics & AIManagement Level - Senior Associate Role - AWS, Python, Pyspark, SQL, Snowflake / RedshiftLocation - BengaluruJob Description & Summary:A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.Why PWCAt 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. 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.About the RoleWe are looking for a highly skilled and hands-on Senior Associate – Data Engineering to design, build, and optimize scalable data solutions across cloud-based data platforms. The ideal candidate is passionate about clean code, performance optimization, and solving complex data problems using modern cloud and big data technologies.Key ResponsibilitiesDesign, develop, and maintain scalable data pipelines for batch and near real-time processing in cloud environmentsBuild and optimize ETL/ELT workflows using Python and PySpark for large-scale data processingWrite and optimize complex SQL queries for data transformation, validation, and analytical use casesDesign, implement, and maintain data models using dimensional modeling techniques (star/snowflake schemas)Work extensively with cloud data warehouses such as Snowflake and Amazon RedshiftEnsure data quality, consistency, reliability, and performance across data platformsOptimize data pipelines and queries for high-volume datasets (TB-scale) with a focus on cost and performanceImplement data governance, security, and best practices in cloud-based systemsCollaborate with business stakeholders, analysts, and platform teams to translate requirements into technical solutionsSupport and maintain production data systems, ensuring high availability and reliabilityMandatory Skillsets 5+ years of hands-on experience in Data EngineeringStrong expertise in SQL, Python, and PySparkExtensive experience with AWS cloud services for data engineering (e.g., S3, Glue, EMR, Redshift, Lambda)Proven experience with Snowflake and/or Amazon RedshiftSolid understanding of data warehousing concepts and cloud-based implementationsStrong knowledge of ETL/ELT architectures and best practicesExpertise in dimensional modeling, star schemas, and data mart designExperience handling large-scale datasets with performance optimization techniquesStrong analytical thinking and problem-solving skillsPreferred Skillsets Experience with Databricks and Delta Lake architectureFamiliarity with data lake and lakehouse architecturesKnowledge of data warehouse migration strategies from on-prem to cloudExposure to real-time or streaming technologies (Apache Kafka, AWS Kinesis, Azure Event Hubs)Experience with workflow orchestration tools such as Apache AirflowUnderstanding of data quality frameworks and data governance toolsFamiliarity with federated querying and data virtualization conceptsCloud certifications (AWS / Azure / Databricks) are a plusQualificationsBachelor’s or Master’s degree in Computer Science, Engineering, or a related fieldStrong communication skills and the ability to work cross-functionally in agile teams