Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

PwC India

IN_Senior Associate_SIS Reporting & Automation_GCC_Advisory_Gurugram(India)

Posted Updated

Who recruits here Pro

Up to three recruiters at PwC India with their work email, so you can write to a person.

View plans

Part of Pro. How it works

Description


Job Description & Summary: We are seeking an experienced Data/Information Management Analyst for our Reporting & Automation (SIS) team with strong hands-on expertise across SQL, SAS, Python, PySpark and Tableau. The role focuses on automating manual control testing using data-driven tools and techniques, analyzing and transforming data, developing and supporting automation and reporting solutions, troubleshooting production failures, and helping identify control/testing gaps so Business and Risk teams can mitigate regulatory, AML/KYC, sanctions, anti-bribery, sales practice, reputational, fraud and theft risks. The ideal candidate is comfortable with Python scripting for file processing, API

Job Position Title:

IN_Senior Associate_SIS Reporting & Automation_GCC_Advisory_Gurugram(India)

Responsibilities:

· Automate manual control testing using data-driven tools and techniques to improve coverage, accuracy and turnaround time. · Analyze and transform large, complex datasets using SQL, SAS, Python and PySpark to support reporting, control testing and data/information management needs. ·
Design, develop and support end-to-end reporting and automation solutions, from requirement gathering through deployment and production support.
· Build Python scripts for file processing, including: · File ingestion, validation and reconciliation
· Parsing of CSV, Excel, fixed-width and JSON files · Archival, logging and exception handling
· Develop and maintain API integrations to source, exchange and publish data across internal and external systems.
· Build and maintain Tableau dashboards and automated MIS reports for Business, Risk and senior stakeholders.
· Identify and fix production failures in SAS & SQL environments; perform root-cause analysis and implement permanent fixes.
· Schedule, monitor and maintain batch jobs using schedulers such as Autosys/LSF and Shell scripting.
· Help identify control/testing gaps so Business and Risk teams can mitigate:
· Regulatory and AML/KYC risks
· Sanctions and anti-bribery risks · Sales practice and reputational risks · Fraud and theft risks

Mandatory skill sets:

· Prepare clear presentations and summaries in Excel and PowerPoint for stakeholders and leadership.

· Strong hands-on experience in Reporting & Automation / Data and Information Management
· SQL and SAS (development and production support)
· Python and PySpark, including Python scripting for file processing ·
API integrations (REST, JSON)
· Tableau dashboarding and reporting · Shell scripting; schedulers such as Autosys/LSF · Data analysis, data patterns, data transformation and problem solving
· Proficiency in Excel, PowerPoint and VBA

Preferred skill sets:

· Banking product knowledge across Wealth, Cards, Deposits, Loans and Insurance
· SAS on Mainframe

Years of experience required:

· · 3–5 years of hands-on Development/Production Support experience, including identifying and fixing production failures in SAS & SQL environments and delivering reporting and automation solutions

Education qualification:

· · Bachelor’s degree in Computer Science, Information Technology, Engineering or a related field · Postgraduate/Master’s qualification in computers preferred

Skills

Apply

See also