Data Engineer-aas-Senior Associate

At PwC, our people in managed services focus on a variety of outsourced solutions and support clients across numerous functions. These individuals help organisations streamline their operations, reduce costs, and improve efficiency by managing key processes and functions on their behalf. They are skilled in project management, technology, and process optimization to deliver high-quality services to clients. Those in managed service management and strategy at PwC will focus on transitioning and running services, along with managing delivery teams, programmes, commercials, performance and delivery risk. Your work will involve the process of continuous improvement and optimising of the managed services process, tools and services.

Focused on relationships, you are building meaningful client connections, and learning how to manage and inspire others. Navigating increasingly complex situations, you are growing your personal brand, deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients, and to deliver quality. Embracing increased ambiguity, you are comfortable when the path forward isn’t clear, you ask questions, and you use these moments as opportunities to grow.

Skills

Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:

• Respond effectively to the diverse perspectives, needs, and feelings of others.
• Use a broad range of tools, methodologies and techniques to generate new ideas and solve problems.
• Use critical thinking to break down complex concepts.
• Understand the broader objectives of your project or role and how your work fits into the overall strategy.
• Develop a deeper understanding of the business context and how it is changing.
• Use reflection to develop self awareness, enhance strengths and address development areas.
• Interpret data to inform insights and recommendations.
• Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firm's code of conduct, and independence requirements.
  
  

Role: Senior Associate – Data Engineer

Tower: Data Analytics & Insights Managed Service

Experience: 6 - 10 years

Key Skills: Data Engineering

Educational Qualification: Bachelor's degree in computer science/IT or relevant field

Work Location: Bangalore AC

Job Description

As a Managed Services - Data Engineer Senior Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution by using Data, Analytics & Insights Skills. PwC Professional skills and responsibilities for this management level include but are not limited to:

• Use feedback and reflection to develop self-awareness, personal strengths, and address development areas.
• Proven track record as an SME in chosen domain.
• Mentor Junior resources within the team, conduct KSS and lessons learnt.
• Flexible to work in stretch opportunities/assignments.
• Demonstrate critical thinking and the ability to bring order to unstructured problems.
• Ticket Quality and deliverables review.
• Status Reporting for the project.
• Adherence to SLAs, experience in incident management, change management and problem management.
• Review your work and that of others for quality, accuracy, and relevance.
• Know how and when to use tools available for a given situation and can explain the reasons for this choice.
• Seek and embrace opportunities which give exposure to different situations, environments, and perspectives.
• Use straightforward communication, in a structured way, when influencing and connecting with others.
• Able to read situations and modify behavior to build quality relationships.
• Uphold the firm's code of ethics and business conduct.
• Demonstrate leadership capabilities by working with clients directly and leading the engagement.
• Work in a team environment that includes client interactions, workstream management, and cross-team collaboration.
• Good Team player. Take up cross competency work and contribute to COE activities.
• Escalation/Risk management.
  
  

Position Requirements

Required Skills:

Primary Skill: ETL/ELT, SQL, SSIS, SSMS, Informatica, Python

Secondary Skill: Azure/AWS/GCP (preferrable anyone), Power BI, Advance Excel, Excel Macro

Data Ingestion Senior Associate

• Should have extensive experience in developing scalable, repeatable, and secure data structures and pipelines to ingest, store, collect, standardize, and integrate data that for downstream consumption like Business Intelligence systems, Analytics modelling, Data scientists etc.
• Designing and implementing data pipelines to extract, transform, and load (ETL) data from various sources into data storage systems, such as data warehouses or data lakes.
• Should have experience in building efficient, ETL/ELT processes using industry leading tools like Informatica, SSIS, SSMS, AWS, Azure, ADF, GCP, Snowflake, Spark, SQL, Python etc.
• Should have Hands-on experience with Data analytics tools like Informatica, Hadoop, Spark etc.
• Monitoring and troubleshooting data pipelines and resolving issues related to data processing, transformation, or storage.
• Implementing and maintaining data security and privacy measures, including access controls and encryption, to protect sensitive data.
• Should have experience in creating visually impactful dashboards in Tableau for data reporting. Extract, interpret and analyze data to identify key metrics and transform raw data into meaningful, actionable information.
• Good understanding of formulas / DAX, Measures, Establishing hierarchies, Data refresh, Row/column/report level security, Report governance, complex visualizations, level of detail (LOD) expressions etc.
• Ability to create and replicate functionalities like parameters (for top fields, sheet switching), interactive buttons to switch between dashboards, burger menus etc.
• Participate in requirement gathering with business and evaluate the data as per the requirement. Coordinate and manage data analytics & Reporting activities with stakeholders.
• Expertise in writing and analyzing complex SQL queries. Excellent problem solving, design, debugging, and testing skills, Competency in Excel (macros, pivot tables, etc.)
• Good to have minimum 5 years’ hands on Experience of delivering Managed Data and Analytics programs (Managed services and Managed assets)
• Should have Strong communication, problem solving, quantitative and analytical abilities.
• Effectively communicate with project team members and sponsors throughout the project lifecycle (status updates, gaps/risks, roadblocks, testing outcomes)
  
  

Nice To Have

• Certification in any cloud platform
• Experience in Data ingestion technology by using any of the industry tools like Informatica, Talend, DataStage, etc.
  
  

Managed Services- Data, Analytics & Insights

At PwC we relentlessly focus on working with our clients to bring the power of technology and humans together and create simple, yet powerful solutions. We imagine a day when our clients can simply focus on their business knowing that they have a trusted partner for their IT needs. Every day we are motivated and passionate about making our clients’ better.

Within our Managed Services platform, PwC delivers integrated services and solutions that are grounded in deep industry experience and powered by the talent that you would expect from the PwC brand. The PwC Managed Services platform delivers scalable solutions that add greater value to our client’s enterprise through technology and human-enabled experiences. Our team of highly skilled and trained global professionals, combined with the use of the latest advancements in technology and process, allows us to provide effective and efficient outcomes. With PwC’s Managed Services our clients are able to focus on accelerating their priorities, including optimizing operations and accelerating outcomes. PwC brings a consultative first approach to operations, leveraging our deep industry insights combined with world class talent and assets to enable transformational journeys that drive sustained client outcomes. Our clients need flexible access to world class business and technology capabilities that keep pace with today’s dynamic business environment.

Within our global, Managed Services platform, we provide Data, Analytics & Insights Managed Service where we focus more so on the evolution of our clients’ Data, Analytics, Insights and cloud portfolio. Our focus is to empower our clients to navigate and capture the value of their application portfolio while cost-effectively operating and protecting their solutions. We do this so that our clients can focus on what matters most to your business: accelerating growth that is dynamic, efficient and cost-effective.

As a member of our Data, Analytics & Insights Managed Service team, we are looking for candidates who thrive working in a high-paced work environment capable of working on a mix of critical Application Evolution Service offerings and engagement including help desk support, enhancement and optimization work, as well as strategic roadmap and advisory level work. It will also be key to lend experience and effort in helping win and support customer engagements from not only a technical perspective, but also a relationship perspective.