Audit And Assurance - Data Analytics And Technology Solutions - Senior Associate

At PwC, our people in audit and assurance focus on providing independent and objective assessments of financial statements, internal controls, and other assurable information enhancing the credibility and reliability of this information with a variety of stakeholders. They evaluate compliance with regulations including assessing governance and risk management processes and related controls. Those in data, analytics and technology solutions at PwC will assist clients in developing solutions that help build trust, drive improvement, and detect, monitor, and predict risk. Your work will involve using advanced analytics, data wrangling technology, and automation tools to leverage data and focus on establishing the right processes and structures to enable our clients to make efficient and effective decisions based on accurate information that is complete and trustworthy.

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 Firms code of conduct, and independence requirements.
  
  

• PricewaterhouseCoopers Service Delivery Centre (Kolkata) Private Limited is a joint venture in India among members of the PricewaterhouseCoopers Network that will leverage the scale and capabilities of its network. It is a member firm of PricewaterhouseCoopers International Limited and has its registered office in Kolkata, India
• The Delivery Centre will provide a professional with an opportunity to work in a dynamic environment where you will have the ability to develop process and quality-based skills.
  
  

• Extract financial and operational data from SAP/Oracle/D365 backend tables (e.g., GL and subledgers) and validate mappings with SMEs.
• Design performance-aware extract logic, including incremental loads and Change Data Capture (CDC).
• Optimise joins, keys and filters to minimise ERP load and support reliable refresh cycles.
  
  

• Build, standardise and automate end-to-end pipelines using SQL, Python and Databricks (PySpark), with Alteryx where appropriate.
• Implement schema evolution handling, robust error/retry logic, and completeness/reconciliation checks.
• Orchestrate workloads with Azure Data Factory (pipelines, triggers, dependencies).
  
  

• Land raw and curated data in Azure Data Lake Storage (ADLS) with clear folder structures and access controls.
• Create Delta Lake tables with ACID guarantees, versioning and auditability; apply cost-efficient design patterns in Azure.
  
  

• Define control totals, referential integrity and anomaly checks; implement automated data quality tests.
• Write unit/integration tests for ETL; configure logging, monitoring and alerting with clear SLAs/SLOs.
• Maintain data lineage and metadata to support audit traceability.
  
  

• Consume REST APIs (Workday, D365, SAP, Oracle) using Python/ADF connectors with secure OAuth/bearer token flows.
  
  

• Use Azure DevOps (Git) for branching, reviews and release automation; build CI/CD for notebooks, ADF and Python packages.
• Containerise components where appropriate (Docker) and manage dependencies via environments.
  
  

• Produce pipeline specs, ERD mappings, runbooks and data dictionaries; contribute to reusable components and best practices.
• Partner with audit teams and global delivery centres to meet quality, timeliness and compliance expectations
  
  

• Perform data extraction and cleansing to ensure accuracy and reliability.
• Build, standardise, and automate data pipelines to support analytics teams in delivering data-enabled audits.
• Enhance and maintain strong relationships with engagement teams and clients.
• The role provides an opportunity for the individual to interact with Data Acquisition teams globally and share best practices.
  
  

• B.Tech/BE/M.Tech/ME (preferably computer science), Bachelors or Master’s Degree in Computer Science, or working in Accounting/Commerce industry with 4+ year of relevant experience.
  
  

• Strong SQL and Python; hands-on PySpark/Databricks.
• ETL/ELT development and workflow orchestration (Azure Data Factory).
• Knowledge of data management, cleansing and transformation processes.
• Exposure to ERP systems (SAP, Oracle, D365) with understanding of key backend tables.
• Experience with financial/general ledger data models and reconciliations.
• CI/CD with Azure DevOps (Git); code reviews and automated deployments.
• Data quality frameworks and automated testing (unit/integration).
• Logging/monitoring/alerting; defining SLAs/SLOs; documenting lineage and metadata.
• API extraction and secure auth (OAuth, bearer tokens, headers).
• Strong analytical, problem-solving and stakeholder management skills.
  
  

• Experience in data engineering within external audit processes.
• Orchestration tools (Airflow/Prefect); Infrastructure-as-Code (Terraform/Bicep).
• Unity Catalog/metadata governance; Delta Live Tables; cost optimisation in Azure.
• Containerisation (Docker) and packaging (wheels).
• Experience working in financial accounting, regulatory compliance, or internal audit.
• Knowledge of major ERP table structures (SAP, Oracle, D365).
• Experience consuming REST APIs (e.g., Workday, D365, SAP, Oracle) for data extraction using Python, Azure Data Factory REST connectors, Databricks, or Alteryx HTTP tools.
• Understanding of API authentication (OAuth, bearer tokens, headers) for securely accessing ERP/HCM REST endpoints.
• Understanding of Azure Data Factory, ADLS, and cloud data workflows.
  
  

• Data transformation & modelling: Databricks (PySpark), Delta Lake, SQL.
• Data storage & querying: ADLS, Databricks SQL.
• Orchestration: Azure Data Factory (pipelines, triggers, dependencies).
• DevOps: Azure DevOps (Git, CI/CD), testing automation.
• Observability: logging, monitoring, alerting, SLA/SLO management.
• Lineage & governance: metadata, Unity Catalog (preferred).
• APIs & Auth: REST, OAuth/bearer tokens.
• Containers: Docker (as applicable).