← Back to jobs
PPricewaterhouseCoopers

IN_Senior Associate_SIS Reporting & Automation_GCC_Advisory_Gurugram

PricewaterhouseCoopers

Gurugram
Full-Time
3-6 Years experience

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

Eligibility Criteria

  • Experience: 3+ years
  • Seniority: Mid Level
  • Education: Bachelor's degree preferred
  • Languages: English

About PricewaterhouseCoopers

Global professional services firm providing audit, tax, and advisory services.

Industry: Professional ServicesEmployees: 31+Website