KPMG Global Services – Hiring for Analyst / Data Analyst @ Bengaluru / Gurgaon

KPMG Global Services (KGS) is hiring for the position of Analyst / Data Analyst under Req ID: 30046319 for its technology and advisory delivery hubs in Bengaluru and Gurgaon.

This entry-level role focuses on supporting client engagement teams through data extraction, reporting, quantitative analysis, business intelligence (BI) dashboarding, and audit/consulting data analytics workflows.

Job Details

About Company

KPMG Global Services (KGS) is a strategic global delivery organization that provides management consulting, risk advisory, tax, and technology services to KPMG member firms worldwide. KGS delivers high-end analytical solutions, cloud services, software development, and digital transformation for global clients across financial services, healthcare, consumer goods, and technology sectors.

Job Description

As an Analyst at KPMG Global Services, you will work as part of an analytics delivery team to solve complex business problems using data-driven insights.

You will be responsible for gathering structured and unstructured dataset requirements, performing data sanitation, writing analytical queries, designing BI reports, and automating recurring operational reporting for global stakeholders.

Requirements & Qualifications

1. Educational Qualifications & Experience

• Degree: Graduate or Postgraduate degree (B.Tech / B.E. / B.Sc / BCA / M.Sc / MCA / MBA) in Computer Science, Data Analytics, Mathematics, Statistics, or related technical disciplines.
• Experience: 0 to 1 year of experience (Freshers and early-career candidates are eligible).

2. Core Technical Competencies

• Data Querying & SQL: Strong foundation in SQL (select statements, joins, aggregations, conditional filtering, and subqueries).
• Data Visualization & BI: Practical familiarity with visualization tools like Power BI, Tableau, or Excel Dashboards.
• Data Wrangling: Proficiency in Advanced MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query, complex formulas) and basic exposure to Python (Pandas, NumPy) or R.
• Problem-Solving & Communication: Analytical mindset with strong verbal and written communication skills to articulate data findings effectively.

Telegram Channel:Click Here to Join

Key Roles and Responsibilities

1. Data Processing & Cleaning: Extract, clean, and structure high-volume client datasets to eliminate data anomalies and ensure compliance standards.
2. Dashboard & Metric Development: Build and maintain interactive KPI dashboards using Power BI/Tableau for leadership reporting.
3. Analytics Support: Execute custom ad-hoc quantitative analyses, trend modeling, and risk evaluations under project lead supervision.
4. Stakeholder Collaboration: Coordinate directly with global engagement teams to validate key metrics, explain findings, and deliver documentation.

WhatsApp Group:Click Here to Join

Why We Recommend This Job

1. Big 4 Exposure: Gain direct working experience with KPMG’s global methodologies, clients, and technical advisory frameworks.
2. Ideal Launchpad for Freshers: Exceptional training and career launchpad for 0-1 year professionals aspiring to build careers in Data Analytics and BI.
3. Structured Skill Development: Build expertise across the entire data lifecycle—from SQL querying and cloud infrastructure to executive storytelling.

Career Growth Potential

Analyst (Req 30046319) ➔ Senior Analyst ➔ Lead Consultant / Assistant Manager ➔ Manager - Data & Analytics

Skills You’ll Gain

Salary & Benefits Info

• Compensation: Standard market-competitive entry-level package for Big 4 delivery centers in India (typically ₹4.5 LPA to ₹7.5 LPA depending on degree tier and background).
• Perks: Comprehensive health insurance, professional certification stipends, flexible work arrangements, and global learning modules.

How to Apply?

1. Click on the official KPMG Oracle Candidate Experience link below.
2. Verify the Job Title (Analyst) and Req ID (30046319).
3. Click Apply Now to log in or create your candidate profile.
4. Upload your updated CV/Resume emphasizing your SQL, Power BI, Advanced Excel, and Python skills.
5. Complete the candidate declaration form and submit your application.

Official Application Link:Apply Now

Frequently Asked Interview Questions (With Answers & Solution Guidelines)

1. SQL Joins & Data Aggregation
   • Question:“What is the difference between an INNER JOIN and a LEFT JOIN, and when would you use a LEFT JOIN in client reporting?”
   • Answer Strategy: Explain that INNER JOIN returns only matching rows from both tables, whereas LEFT JOIN returns all rows from the left table and matched rows from the right (filling missing values with NULL). Use LEFT JOIN when you need to retain all master entity records (e.g., all clients) even if they haven’t made a transaction in the reporting period.
2. Excel Data Processing
   • Question:“How do you handle duplicate records and missing values in a messy Excel dataset before importing it into Power BI?”
   • Answer Strategy: Detail using Power Query to remove duplicate rows based on unique key columns, fill down missing structural headers, replace blank values with standardized defaults (e.g., 0 or N/A), and unpivot dynamic columns into tall tabular formats.
3. Power BI Visual Optimization
   • Question:“What is the difference between a Calculated Column and a DAX Measure in Power BI?”
   • Answer Strategy: Clarify that a Calculated Column computes values row-by-row during data refresh and consumes RAM memory, whereas a DAX Measure evaluates dynamically on the fly based on report slicers and filter contexts, minimizing storage footprint and optimizing dashboard speed.