Audit and Assurance - Data, Analytics and Technology Solutions - Senior Ass at pwc

Kolkata, west bengal, India -

Full Time

Start Date

Immediate

Expiry Date

17 Jun, 26

Salary

0.0

Posted On

19 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Python, PySpark, Databricks, ETL/ELT Development, Azure Data Factory, Azure Data Lake Storage, Delta Lake, Azure DevOps, CI/CD, Data Quality Testing, API Extraction, OAuth, Stakeholder Management, ERP Systems, Change Data Capture

Industry

Professional Services

Description

Industry/Sector Not Applicable Specialism Assurance Management Level Senior Associate Job Description & Summary 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. 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. Job Specification About the Job Introduction to PwC Acceleration Centre 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. Roles and Responsibilities As a Senior Associate, you will play a key role in designing and developing innovative audit solutions. ERP Data Extraction & Engineering: 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. ETL / ELT Pipeline Development: 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). Cloud & Lakehouse: 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. Data Quality, Testing & Observability: 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. API-driven Acquisition: Consume REST APIs (Workday, D365, SAP, Oracle) using Python/ADF connectors with secure OAuth/bearer token flows. DevOps & CI/CD: 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. Documentation & Collaboration: 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 Day to day responsibilities will include: 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. Minimum Degree(s): 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. Essential Skills 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. Desirable 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. Technical Skills: 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). Travel Requirements Not Specified Job Posting End Date Are you ready to make a difference? Want to unlock new value by applying your unique perspective and talents? You can grow exponentially at PwC. Here, you can uncover hidden talents, build lifelong relationships rooted in trust and empathy and turn challenges into opportunities for innovation. We’ll help you grow your skills through challenging, meaningful work so you can go further.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The Senior Associate will play a key role in designing and developing innovative audit solutions, focusing on extracting, engineering, and automating data pipelines using technologies like SQL, Python, and Databricks from ERP systems.