Citi Data Analyst Interview Questions + Guide in 2024

Citi is a leading global bank with approximately 200 million customer accounts, operating in over 160 countries and jurisdictions. As a trusted partner, Citi provides financial services to foster growth and economic progress while upholding the highest ethical standards.

Citi seeks Data Analysts who are highly analytical, collaborative, and possess strong communication skills. Experience in a fast-paced environment and a strong sense of urgency to meet deadlines is also an important factor for this role.

In this guide, we’ll walk you through their interview process, commonly asked Citi data analyst interview questions, along with tips to help you excel in the interview.

Typically, the Citi data analyst interview process consists of 4 rounds. Here’s what you can expect at each stage:

Initial HR Interview

A 20-30 minute initial phone call with their HR team consists of sharing your work experience, projects you’ve worked on, and expectations. You’ll also learn more about Citi and its interview process at this stage.

Technical Rounds

There will be two rounds to evaluate your technical skills, so review and brush up on data analytic (SQL, case studies, and statistics/probability) concepts to succeed in this round.

Hiring Manager Interview

The final round of interviews will be with the hiring manager, who will primarily focus on assessing your cultural fit within the team and the organization. This round will involve discussions about your values, work style, and how well you align with the company’s mission and culture.

Here are some sample Citi data analyst interview questions:

1. Why do you want to work at Citi?

2. How would you design a function to detect anomalies in a univariate dataset?

3. Write a query to show the number of users, transactions, and total order amount per month in 2020

4. How would you analyze focus group data to decide which TV series to feature?

5. Write a function replace_words to stem words in a sentence using a dictionary of roots.

6. Select the top 3 departments with at least ten employees and rank them by the percentage of employees making over 100K.

7. What are Z and t-tests, and when should you use each?

8. What is the expected churn rate in March for customers who bought the product since January 1st?

9. How would you explain a p-value to a non-technical person?

10. Due to an ETL error, the employees table, instead of updating the salaries every year when doing compensation adjustments, did an insert instead. Write a query to get the current salary for each employee.

11. Write a SQL query to calculate the total expenditure for each department in 2022.

12. What would be a reason why we would want to create partner cards?

13. How would you investigate if the redesigned email campaign actually led to the increase in the conversion rate, and that it wasn’t the result of other factors?

14. What is the probability that it’s actually raining in Seattle?

15. How would you identify the top 1,000 small businesses to reach out from a list of 100,000 businesses?

16. Describe a data project you worked on. What were some of the challenges you faced?

17. Tell me about a time when you exceeded expectations during a project. What did you do, and how did you accomplish it?

18. How do you prioritize multiple deadlines?

19. How do you handle cleaning and organizing a large dataset?

20. How comfortable are you presenting your insights?

Preparing for a data analyst interview at Citi mostly consists of brushing up your analytical approach, technical skills, and soft skills. Here’s a structured approach to help you get ready:

Understand the Role and Company

Familiarize yourself with the specific responsibilities of a Data Analyst at Citi. This might include data analysis, data visualization, statistical analysis, and reporting. Review the job description to identify key skills and qualifications. Understanding Citi’s values and culture will also help you align your responses during the interview.

Practice Case Studies and SQL

When tackling case study questions, focus on structuring your thought process, asking clarifying questions, and using data-driven reasoning to reach your conclusions. Additionally, be sure to brush up your SQL knowledge, as technical rounds often include SQL interview questions.

Focus on Behavioral Interview Questions

Prepare to answer data analyst behavioral questions using the STAR (Situation, Task, Action, Result) framework. They may ask you about your experience working with different teams, dealing with difficult stakeholders, and prioritizing multiple deadlines.

Participate in Mock Interviews

Getting real-time feedback is something you’ll need whenever you prep for an interview. Use our P2P Mock Interview Portal or AI Interviewer to receive personalized feedback on your answers. This approach will surely let you identify what you need to improve and build confidence, making you prepared for your upcoming Citi data analyst interview.

What’s the average annual salary for a Data Analyst at Citi?

The salary for Citi data analysts ranges between $75k to $200K, with an average of $138k, depending on location and job role.

What other companies are hiring data analysts besides Citi?

Numerous companies are hiring data analysts across various industries. Some well-known examples include Google, JPMorgan Chase, and Amazon

Does Interview Query have job postings for Citi data analyst role?

Yes, visit our Job Board to check out current opportunities.

While the data analyst interview process at Citi can be quite rigorous, we hope this guide has equipped you with the insights and strategies needed to navigate it successfully.

As you prepare for the interview, don’t forget to stay confident in your skills and experiences, and never hesitate to showcase your unique perspective. Best of luck on your interview journey!