Data Engineer-Manager-Analytics As Service - Manager - Operate

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.

Enhancing your leadership style, you motivate, develop and inspire others to deliver quality. You are responsible for coaching, leveraging team member’s unique strengths, and managing performance to deliver on client expectations. With your growing knowledge of how business works, you play an important role in identifying opportunities that contribute to the success of our Firm. You are expected to lead with integrity and authenticity, articulating our purpose and values in a meaningful way. You embrace technology and innovation to enhance your delivery and encourage others to do the same.

Skills

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

• Analyse and identify the linkages and interactions between the component parts of an entire system.
• Take ownership of projects, ensuring their successful planning, budgeting, execution, and completion.
• Partner with team leadership to ensure collective ownership of quality, timelines, and deliverables.
• Develop skills outside your comfort zone, and encourage others to do the same.
• Effectively mentor others.
• Use the review of work as an opportunity to deepen the expertise of team members.
• Address conflicts or issues, engaging in difficult conversations with clients, team members and other stakeholders, escalating where appropriate.
• Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firms code of conduct, and independence requirements.
  
  

Role: Manager

Tower: Data Analytics & Insights Managed Service

Experience: 8 - 15 years

Key Skills: DBT/ Wherescape/ Informatica and Data Modelling (Data Vault 2.0)

Educational Qualification: Bachelors degree in computer science/IT or relevant field

Work Location: Bangalore, India

Job Description

This role leads the enterprise data engineering and Data Vault 2.0 modeling capability within the Data Analytics & Insights Managed Service, owning architecture, governance, and delivery of data pipelines and models across cloud data warehouses. The manager will oversee the current WhereScape and Informatica estate and drive a strategic migration toward dbt and cloud-native platforms, ensuring reliable, compliant, and scalable data products that serve cross-functional analytics and business stakeholders. This role sits within the Managed Service construct and is accountable for service excellence, stakeholder engagement, and delivery outcomes aligned to enterprise standards, ways of working, and SLAs.

• Own the data engineering and Data Vault 2.0 roadmap, backlog, and delivery plan; define KPIs/SLAs and ensure service excellence across the Managed Service.
• Build, lead, and mentor a high-performing team of data engineers and modelers; drive workforce planning, capability development, and performance management. Mentor and manage a team of Senior Associates and Junior resources, providing guidance, training, and performance feedback.
• Serve as architecture owner: chair design reviews, enforce standards, and align with enterprise data platform and security governance.
• Manage stakeholder relationships (business, analytics, platform, security); translate demand into sequenced delivery; communicate risks, issues, and status clearly.
• Drive collaboration with business stakeholders, data architects, and technical teams for requirements gathering, solution design, and delivery.
• Oversee release/change management, incident/problem management, vendor coordination, and continuous improvement of processes and tooling.
• Establish and maintain policies, playbooks, and documentation for engineering, modeling, testing, and operations.
• Review and approve all technical deliverables to ensure accuracy, completeness, and adherence to standards.
• Lead risk identification, mitigation planning, and escalation management within migration projects.
• Manage project status reporting, resource allocation, and stakeholder communication to ensure transparency and alignment.
• Foster a collaborative team environment and promote knowledge sharing and cross-functional cooperation.
• Ensure compliance with organizational policies, governance, and ethical standards.
  
  

Position Requirements

Required Skills:

Primary Skill: Data Vault 2.0 (Hubs, Links, Satellites, Business Vault); dbt (core/cloud); WhereScape (RED/3D); Informatica (PowerCenter/IDMC); Cloud Data Warehouse (Snowflake/BigQuery/Azure Synapse/Redshift); Advanced SQL; ELT and CDC; Orchestration (Bhoomi); Git and CI/CD for data

Secondary Skill: Teradata, Python, SSIS, ServiceNow, Jira, Healthcare insurance domain knowledge (payer: claims, eligibility, provider, HIPAA)

Required Skills & Experience

• Minimum 8 years in data engineering/data warehousing, with 4+ years leading teams and owning architecture and delivery in enterprise environments.
• Oversight of solutions on WhereScape and Informatica, with leadership of migration paths to dbt and cloud-native ELT.
• Data Vault 2.0 leadership and delivery at scale on cloud data warehouses: standards across Hubs, Links, Satellites, and Business Vault (incl. PIT/Bridge); source-to-vault mapping (business keys, hash keys, record tracking, load dates, multi-active satellites), CDC alignment; Business Vault transformations; modeling reviews, naming conventions, documentation, and change control; ensure compliance while maintaining agility.
• Strong SQL/ELT patterns (CDC, SCD), performance optimization, CI/CD for data pipelines, and automated data testing; implement observability (logging, monitoring, alerting).
• Orchestration and scheduling, dependency management, standardized patterns for batch loads and schema evolution, with robust error handling and recovery.
• Governance and service delivery: define and meet SLAs; incident/change management; risk mitigation; clear stakeholder communication.
• E nd-to-end metadata, lineage, and catalog integration; enforce access controls, data masking, PII governance, and auditability.
• Partner with platform teams to optimize cloud data warehouses (e.g., Snowflake, BigQuery, Azure Synapse, Redshift) for scalability, reliability, and cost.
• Effective leadership: build and mentor teams, set standards, and drive cross-functional alignment and outcomes.
  
  

Nice To Have

• Certifications: Data Vault 2.0, dbt (core/cloud), Informatica, WhereScape, and major cloud providers (AWS/Azure/GCP).
• Experience with dimensional modeling, data products, semantic/consumption layers; collaboration with BI/reporting teams.
• Exposure to streaming (e.g., Kafka), Python, and orchestration frameworks, cost optimization in cloud data platforms.
• DataOps practices, Agile/DevOps delivery, and ITIL-aligned managed service operations.
• Exposure to ITSM tools like ServiceNow.
• Domain experience in healthcare insurance (payer) including claims processing, eligibility/enrollment, provider networks, utilization management, and HIPAA/regulatory compliance is a plus.

---