KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #2824
Applications open Internship

Associate – Reporting & Analytics

Deloitte

  • Hyderabad, Telangana
  • 6-9 LPA
  • 1–2 Years
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Deloitte is one of the world’s leading professional services firms, offering consulting, audit, tax, risk advisory and technology solutions to a diverse set of global clients. In India, Deloitte USI (United States India Offices) acts as a strategic hub that supports the firm’s global member firms through technology, finance, talent, research and business operations. The firm is known for its strong emphasis on learning, inclusive culture and rapid career progression, making it a preferred destination for fresh talent and early‑career professionals.

The role of Associate – Reporting & Analytics sits within the Global Tax & Legal – People & Purpose organisation. This unit drives learning, talent development and people‑centric initiatives for Deloitte’s tax and legal professionals worldwide. As an Associate, you will be the data‑driven backbone of these initiatives, responsible for preparing recurring reports, maintaining interactive dashboards, cleaning and validating data from multiple sources, and translating analytical findings into clear stakeholder‑ready presentations.

The position offers exposure to both traditional reporting tools and modern visualisation platforms, along with a chance to support digital learning content creation.

Key Responsibilities

  • Prepare, update and own recurring learning and talent reports and dashboards.
  • Collect, clean, validate and reconcile data from diverse systems ensuring high accuracy.
  • Identify trends, anomalies and data gaps; raise escalations where required.
  • Create visual summaries, charts and interactive dashboards using Excel, Power BI or Tableau.
  • Develop PowerPoint insight packs that communicate findings to senior stakeholders.
  • Perform quality checks, maintain version control and document reporting processes.
  • Coordinate with global and local stakeholders to gather requirements and follow‑up on missing data.
  • Support project trackers, action logs and status reporting for learning initiatives.
  • Assist digital learning teams with asset organisation, content updates and basic video editing using Camtasia or Articulate 360.
  • Contribute to internal communications, newsletters and virtual meeting logistics as needed.

Tech Stack: Microsoft Excel (advanced formulas, pivot tables, dashboards), PowerPoint, Power BI, Tableau, Microsoft Copilot, Camtasia, Articulate 360, Adobe Creative Cloud Suite.

Growth Path: Starting as an Associate, high performers can progress to Senior Associate, Manager and eventually to senior leadership roles within the People & Purpose or broader Analytics practice. Deloitte’s internal mobility program encourages cross‑functional moves, enabling you to gain experience in consulting, risk advisory or technology domains.

Why Join Deloitte: You will work in a globally recognised brand that invests heavily in employee development, offers structured mentorship, and provides exposure to cutting‑edge analytics tools. The collaborative culture, emphasis on work‑life balance and clear promotion pathways make Deloitte an ideal launchpad for a long‑term analytics career.

Eligibility & process

Who can apply

Bachelor’s degree or equivalent in any discipline (Business Analytics, Data Analytics, Commerce, Engineering, Science etc.) with a minimum of 60% aggregate (or CGPA 6.5/10). No active backlogs at the time of joining. 1–2 years of relevant corporate experience in reporting, analytics, learning & development, talent management or operations. Open to any graduation batch; no specific batch year restriction.

Skills & stack

Microsoft Excel Powerpoint Data Validation Reporting Data Visualization Power BI Tableau Microsoft Copilot

Selection process

  1. Round 1: Online Aptitude Test (numerical, logical reasoning, data interpretation)
  2. Round 2: Technical/Case Study Interview (focus on Excel, reporting concepts, data handling)
  3. Round 3: HR Interview (behavioral fit, communication, career aspirations)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Microsoft Excel, Powerpoint, Data Validation, Reporting, Data Visualization, Power BI, Tableau, Microsoft Copilot) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Deloitte Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Deloitte as a Associate – Reporting & Analytics?
Highlight Deloitte's market reputation, recent tech innovations, and how your skills in Microsoft Excel directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Deloitte 6-9 LPA
Recruiter Resume Apply
Chat Chat with Kashii