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

Data Analyst with SQL/Python/Data visualization

Citigroup

  • Gurugram, India
  • 7-9 LPA
  • Fresher (0-1 Yrs)
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Citi is one of the world’s leading financial services institutions, operating in more than 160 countries with a workforce of over 219,000 professionals. In India, Citi has built a strong presence across banking, capital markets, and technology, offering a collaborative environment that encourages innovation and continuous learning. The firm’s culture emphasizes diversity, inclusion, and a commitment to community impact, making it an attractive destination for fresh talent looking to launch a global career.

The Data Analyst (SQL/Python/Data Visualization) role is a trainee position designed for recent graduates who are eager to apply analytical skills in a real‑world banking environment. As a member of the Data/Information Management team, you will support day‑to‑day data operations, assist senior analysts in building dashboards, and contribute to data‑driven decision making across the organization. This hybrid role blends hands‑on technical work with exposure to business processes, providing a solid foundation for a long‑term career in data analytics within the financial sector.

Key Responsibilities

  • Write, test, and maintain SQL queries to extract and manipulate data from relational databases.
  • Develop Python scripts for data cleaning, transformation, and basic statistical analysis.
  • Create interactive visualizations and reports using Power BI or Tableau to communicate insights to stakeholders.
  • Perform routine data quality checks and support data governance initiatives.
  • Assist in preparing daily, weekly, and monthly analytical reports for internal teams.
  • Collaborate with senior analysts to understand business requirements and translate them into technical solutions.
  • Document data pipelines, processes, and reporting standards for knowledge sharing.
  • Participate in team meetings, providing updates on progress and flagging any data‑related risks.
  • Continuously learn and adopt new tools and best practices in data analytics.
  • Ensure compliance with Citi’s data security and privacy policies.

Tech Stack: SQL, Python (pandas, numpy), Power BI/Tableau, Excel, Git (basic version control), and familiarity with data warehousing concepts.

Growth Path: Successful analysts can progress to Senior Analyst, Data Engineer, or Business Intelligence Lead roles, with opportunities to move across functional domains such as risk, finance, or digital banking. Citi invests heavily in up‑skilling through internal learning platforms, certifications, and mentorship programs.

Why Join Citi?

  • Exposure to global banking data and cutting‑edge analytics tools.
  • Structured training and mentorship from experienced professionals.
  • Competitive compensation, performance‑linked bonuses, and comprehensive benefits.
  • A culture that values diversity, encourages innovation, and supports work‑life balance.
  • Clear career progression pathways within a reputable multinational organization.

Eligibility & process

Who can apply

Bachelor’s degree or equivalent in Engineering, Computer Science, Statistics, Mathematics, Economics or any quantitative discipline. Minimum 60% aggregate (or CGPA 6.0/10). Final year students of 2024‑2026 batches are eligible. No active backlogs at the time of joining. Strong analytical mindset and good communication skills are essential.

Skills & stack

SQL Python Power BI Tableau Advanced Excel Data Analysis Data Visualization Git

Selection process

  1. Round 1: Online Aptitude Test (Logical Reasoning, Quantitative, Verbal)
  2. Round 2: Technical Assessment (SQL/Python coding)
  3. Round 3: Technical Interview (data concepts, case studies)
  4. Round 4: HR Interview (fit, motivation, behavioral questions)

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 (SQL, Python, Power BI, Tableau, Advanced Excel, Data Analysis, Data Visualization, Git) & 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 Citigroup 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 Citigroup as a Data Analyst with SQL/Python/Data visualization?
Highlight Citigroup's market reputation, recent tech innovations, and how your skills in SQL 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.
Citigroup 7-9 LPA
Recruiter Resume Apply
Chat Chat with Kashii