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

Data Analyst

CBRE

  • Hyderabad, Telangana, India
  • 5 LPA
  • 0-3 Years
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

CBRE (Coldwell Banker Richard Ellis) is a Fortune 500 global leader in commercial real estate services and investment management. With more than 155,000 employees across 100+ countries, CBRE offers a broad portfolio of services ranging from facilities management and advisory to project management and real‑estate investment. The company’s Business Services Organisation (BSO) focuses on delivering end‑to‑end solutions for corporate clients, leveraging data‑driven insights and a collaborative culture built on respect, integrity, service and excellence.

Working at CBRE means exposure to world‑class clients, cross‑functional teams, and a chance to contribute to large‑scale real‑estate projects that shape the way businesses operate.

The Procurement Analyst role sits within the Procurement function of BSO and is responsible for turning raw procurement data into actionable intelligence. The analyst designs, generates, and reviews reports that support account, client, and global sourcing requirements. By maintaining data integrity across multiple databases, the analyst ensures that sourcing decisions are based on accurate, timely information.

The position is ideal for recent graduates with a knack for numbers, strong Excel skills, and an interest in supply‑chain dynamics.

Key Responsibilities

  • Design and implement reporting templates for sourcing, contracting, and vendor performance.
  • Generate periodic reports, analyse trends, and present findings to stakeholders.
  • Maintain and cleanse procurement databases to ensure data accuracy.
  • Collect data from multiple internal and external sources and rationalise it for analysis.
  • Conduct financial evaluations, including cost‑benefit analysis and spend forecasting.
  • Prepare forecasts and investigate market trends that impact procurement strategy.
  • Identify improvement opportunities and recommend actionable solutions.
  • Ensure compliance with CBRE’s RISE values and standard operating procedures.
  • Collaborate with cross‑functional teams to support procurement initiatives.
  • Assist in vendor onboarding and performance monitoring.

Tech Stack & Tools: Advanced Microsoft Excel (pivot tables, macros), Microsoft PowerPoint, Word, Outlook, basic SQL for data extraction, and familiarity with procurement software (e.g., SAP Ariba, Coupa) is a plus.

Growth Path: Starting as a Procurement Analyst, high performers can progress to Senior Analyst, Procurement Specialist, Category Manager, and eventually Procurement Lead or Head of Procurement within CBRE’s global network.

Why Join CBRE? CBRE offers a truly global platform, mentorship from industry veterans, and a culture that encourages continuous learning. Employees benefit from structured training programs, exposure to multinational clients, and opportunities to work on complex, high‑impact projects.

The company’s commitment to diversity and inclusion ensures that every voice is heard, making it an ideal place for fresh talent to launch a rewarding career in procurement and supply‑chain analytics.

Eligibility & process

Who can apply

Bachelor's degree in any discipline (preferably Commerce, Business Administration, Economics, Engineering or related fields). Minimum 0-3 years of relevant experience. Minimum aggregate 60% (or equivalent CGPA). No active backlogs at the time of joining. Fresh graduates from the 2026 batch are preferred, but candidates from 2025 or 2027 may be considered based on overall profile.

Skills & stack

Microsoft Excel Data Analysis Procurement Financial Modeling Reporting Ms Office Suite SQL Advanced Excel

Selection process

  1. Round 1: Online Aptitude Test (quantitative, logical reasoning, verbal)
  2. Round 2: Technical/Functional Interview (procurement concepts, Excel case study)
  3. Round 3: HR Interview (cultural fit, RISE values)

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, Data Analysis, Procurement, Financial Modeling, Reporting, Ms Office Suite, SQL, Advanced Excel) & 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 CBRE 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 CBRE as a Data Analyst?
Highlight CBRE'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.
CBRE 5 LPA
Recruiter Resume Apply
Chat Chat with Kashii