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

Data Analyst with SQL/Python/Data visualization

Citigroup

  • Haryana, India
  • 6-8 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 dynamic environment where innovation meets global best practices. The company prides itself on a culture of inclusion, continuous learning, and a commitment to giving back to the community through various CSR initiatives. As a fresher-friendly organization, Citi invests heavily in training programs, mentorship, and clear career progression pathways, making it an attractive launchpad for young talent. The Data Analyst (SQL/Python/Data Visualization) role is a trainee position designed for fresh graduates who are eager to apply analytical skills in a real‑world banking environment. You will work closely with senior analysts and business stakeholders to extract, transform, and visualize data that drives strategic decisions. The role offers a blend of hands‑on technical work and exposure to business processes, providing a solid foundation for a career in data‑driven finance. **Key Responsibilities** 1. Write and optimize SQL queries to retrieve data from relational databases. 2. Develop Python scripts for data cleaning, transformation, and basic statistical analysis. 3. Create interactive dashboards and reports using Power BI or Tableau. 4. Perform ad‑hoc data analysis to support business queries and decision‑making. 5. Maintain data quality by identifying inconsistencies and suggesting corrective actions. 6. Document data sources, methodologies, and analytical processes for reproducibility. 7. Collaborate with cross‑functional teams to understand reporting requirements. 8. Assist in preparing regular performance and risk reports for senior management. 9. Participate in code reviews and knowledge‑sharing sessions with senior analysts. 10. Ensure compliance with Citi’s data governance and security policies. **Tech Stack**: SQL, Python (pandas, numpy), Power BI/Tableau, Excel, Git (basic version control). **Growth Path**: Successful analysts can progress to Senior Analyst, Data Engineer, or Business Intelligence Lead within 2‑3 years, with opportunities to move into specialized domains such as risk analytics, market analytics, or product analytics. **Why Join Citi?** Citi offers a globally recognized brand, structured training programs, exposure to large‑scale financial data, and a collaborative culture that values diversity and innovation. Freshers receive mentorship from seasoned professionals, access to internal learning platforms, and a clear roadmap for career advancement.

Eligibility & process

Who can apply

Bachelor's degree or equivalent in any discipline (Engineering, Science, Commerce, Arts). Minimum 60% aggregate or CGPA 6.0/10. Fresh graduates of the 2025‑2027 batch. No active backlogs at the time of joining. Strong analytical mindset and good communication skills are essential.

Skills & stack

SQL Python Power BI Tableau Excel Data Analysis Data Visualization Attention to Detail Customer Service

Selection process

  1. Round 1: Online Aptitude Test (Logical Reasoning, Numerical Ability, Verbal)
  2. Round 2: Technical Interview (SQL/Python/Data Visualization)
  3. Round 3: HR Interview (fitment, motivation, cultural fit)

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, Excel, Data Analysis, Data Visualization, Attention to Detail, Customer Service) & 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 6-8 LPA
Recruiter Apply
Chat Chat with Kashii