📋 Job Details at a Glance 📍 Location Bangalore, Karnataka, India 🏢 Company Citi 👥 Experience 0-2 years 🎓 Qualification 2024, 2025, 2026 📅 Eligible Batch 2024, 2025, 2026 📄 Job Type Full Time 💰 Salary ₹8–12 LPA 🏢 Industry Technology 🛠 Key Skills SQL Excel data analysis Spec Analytics Analyst at Citi — Full Details & How to Apply Citi is seeking fresh talent for the Spec Analytics Analyst role in Bangalore, Karnataka, India , offering a competitive salary of ₹8–12 LPA . This position is ideal for graduates from 2024, 2025, and 2026 looking to launch their analytics careers in a thriving industry. The demand for data analytics professionals is surging, as companies increasingly rely on data-driven decisions. The Spec Analytics Analyst role at Citi is crucial in this landscape, providing freshers with the opportunity to influence strategies that enhance customer experiences and operational efficiency. This role not only addresses the growing need for analytics but also positions you at the forefront of technological advancements. Citi , founded in 1812 , is a global leader in financial services with over 200,000 employees worldwide. This extensive scale offers a robust platform for freshers, ensuring that you will be part of a culture that values innovation and collaboration. The company’s commitment to leveraging advanced analytics tools sets it apart, making it an attractive employer for those entering the field. We encourage 2024, 2025, 2026 graduates with 0-2 years experience to apply for this role. The competitive salary of ₹8–12 LPA reflects the value placed on fresh talent, making it an excellent starting point for your career in analytics. As a Spec Analytics Analyst , you will gain hands-on experience with essential skills such as SQL , Excel , and data analysis . This role opens doors to various career paths in analytics and data science, providing a strong foundation for future roles in the technology sector. 📊 Role Difficulty: Medium | Competition Level: Medium | Fresher Friendly: Yes NexisGrow.com features this opportunity as part of its curated tech job listings. All details are sourced from the official job posting. Apply online before the opportunity closes. Job Role & Responsibilities The Spec Analytics Analyst at Citi is tasked with leveraging data to drive strategic decisions, ensuring that insights are actionable and aligned with business goals. Analyze large data sets using SQL and Excel to identify trends that inform strategic decision-making. Utilize SQL to extract and manipulate data for accurate reporting, ensuring relevance to business objectives. Collaborate with IT and marketing teams to align analytics initiatives with overall business strategies. Monitor key performance indicators ( KPIs ) to evaluate the effectiveness of various strategies and report findings to stakeholders. Take ownership of specific analytics projects, driving them from inception to completion using data analysis . Document analytical processes and results, ensuring clear communication of findings to both technical and non-technical stakeholders. Engage in problem-solving discussions with clients to understand their data needs and provide actionable insights. This role fosters an ownership culture, allowing analysts to directly impact business outcomes through data-driven insights. Required Skills & Technical Competencies The ideal candidate for the Spec Analytics Analyst position at Citi should possess a strong skill set in data analytics and effective communication. Technical Skills SQL — entry — essential for data extraction and manipulation, enabling accurate reporting and analysis. Excel — entry — critical for data analysis and visualization, facilitating effective presentation of findings. Data analysis — entry — applied daily to interpret data trends and support decision-making processes. Data visualization tools (Tableau or Power BI) — entry — advantageous for presenting insights in a clear and impactful manner. Soft Skills & Professional Competencies Strong communication skills are necessary to convey complex data findings to non-technical stakeholders effectively. Analytical thinking is crucial for interpreting data trends and providing actionable insights. Attention to detail ensures accuracy in data reporting and analysis. Problem-solving abilities are essential for engaging with clients to understand their data needs. Good to Have (Bonus Skills) Knowledge of Python or R can enhance your data analysis capabilities, making you more versatile in your role. Experience with data cleaning techniques will streamline your analysis process. Familiarity with statistical methods can provide deeper insights into data trends. When showcasing these skills in your resume or interview, emphasize specific projects or experiences that demonstrate your proficiency and impact. Eligibility Criteria This role is designed for recent graduates eager to start their careers in data analytics. Candidates must hold a degree in fields such as Computer Science , Statistics , or Mathematics . Only graduates from the 2024 , 2025 , and 2026 batches are eligible. No prior experience is required, making this role ideal for freshers. A minimum academic performance of 60% is preferred to ensure a strong foundational knowledge. Having a portfolio or GitHub showcasing relevant projects or internships can provide a competitive edge. Documentation & Portfolio Requirements Ensure your resume is clear and concise, highlighting relevant skills and experiences, along with a portfolio that includes data projects or internships. Pro tip: Tailor your application to emphasize your analytical projects and any experience with SQL or Excel to stand out. Salary for Spec Analytics Analyst at Citi 💰 Compensation ₹8–12 LPA The advertised compensation for the Spec Analytics Analyst role at Citi is ₹8–12 LPA . The exact in-hand figure and any additional components are confirmed by the company during the offer or HR discussion stage. Selection Process at Citi The selection process for the Spec Analytics Analyst role at Citi is designed to identify candidates with strong analytical skills and a good cultural fit. 1 Online Assessment — 60 minutes, testing analytical skills and basic SQL knowledge 2 Technical Interview — focuses on SQL, Excel, and data analysis concepts, including 3-4 specific scenarios 3 Behavioral Interview — assesses cultural fit and problem-solving approaches through situational questions 4 HR Interview — discusses salary expectations and company culture, with an offer timeline of 1-2 weeks Topic-wise Preparation Guide Round 1: Online Assessment Basic SQL queries — essential for data manipulation and retrieval — W3Schools Excel functions — focusing on VLOOKUP, pivot tables, and data visualization — YouTube Data interpretation — understanding trends and making data-driven decisions — Khan Academy Logical reasoning — solving analytical puzzles relevant to data analysis — HackerRank Round 2: Technical Interview Advanced SQL techniques — joins, subqueries, and data aggregation — GeeksForGeeks Data analysis frameworks — understanding how to apply statistical methods — Coursera Excel data visualization — creating charts and dashboards — Udemy Business case studies — analyzing real-world scenarios relevant to Citi — freeCodeCamp Problem-solving methodologies — applying structured approaches to analytics — MindTools Round 3: Behavioral Interview Behavioral questions using the STAR method — focusing on teamwork and conflict resolution Situational judgment tests — assessing decision-making in hypothetical scenarios Technical deep-dive — on SQL and data analysis techniques relevant to the role Timeline & Expectations The application to offer timeline typically spans 1-2 weeks , allowing candidates to prepare adequately for each stage. Focus on demonstrating both technical expertise and cultural fit throughout the selection process. Expected Interview Questions for Spec Analytics Analyst at Citi These questions are based on the role's actual tech stack and responsibilities. Technical Questions What are the different types of joins in SQL and when would you use them? How do you handle missing data in a dataset? Explain the difference between a clustered and a non-clustered index. What Excel functions would you use to analyze large datasets? How would you visualize data trends effectively? Describe a time when you used data to solve a problem. Behavioral Questions Describe a situation where you had to work in a team to achieve a goal. How do you handle tight deadlines and pressure? Give an example of a time you faced a challenge and how you overcame it. What motivates you to pursue a career in analytics? Role-Specific Questions What specific analytics tools have you used in your projects? How would you prioritize multiple data analysis tasks? What do you believe is the most important skill for a Spec Analytics Analyst? Structure your answers using the STAR method to effectively communicate your experiences and thought processes. Resume Tailoring & ATS Keywords for Spec Analytics Analyst Optimizing your resume for ATS is crucial for this role to ensure it gets noticed by recruiters. ATS Keywords to Include SQL Excel data analysis analytical skills problem-solving teamwork data visualization statistical methods Bangalore Citi freshers analytics Resume Tips for This Role Highlight your SQL and Excel skills prominently, as they are crucial for this role. Emphasize any relevant projects or internships that showcase your analytical abilities. Include a portfolio link to demonstrate your practical experience with data analysis. Optimize for ATS by using keywords from the job description. Avoid including unrelated work experience that does not pertain to analytics. Build an ATS-optimized resume for this role using NexisGrow Resume Builder — free for all job seekers. Do not include irrelevant work experience that does not demonstrate your analytical skills. 7-Day Preparation Roadmap for Spec Analytics Analyst Interview This roadmap is tailored to the JD requirements to help you prepare effectively. Day 1-2: Review SQL basics using online resources like W3Schools . Day 3-4: Practice Excel functions through tutorials on platforms like YouTube . Day 5-6: Work on data analysis projects using Kaggle datasets to apply your skills. Day 7: Conduct mock interviews focusing on behavioral and technical questions. Recommended Resources Khan Academy Coursera GeeksForGeeks HackerRank Boost your profile with relevant certifications at NexisGrow GetCertified — strengthen your application before you apply. Common Mistakes to Avoid ❌ Failing to tailor your resume to highlight relevant skills and experiences — customize your resume for each application. ❌ Neglecting to practice SQL and Excel before the technical interview — dedicate time to hands-on practice. ❌ Not researching Citi's recent initiatives and culture before interviews — familiarize yourself with the company. ❌ Underestimating the importance of soft skills in the behavioral interview — prepare examples showcasing your soft skills. ❌ Submitting applications without proofreading for errors — always review your application materials. ❌ Ignoring the significance of networking and reaching out to current employees — leverage LinkedIn to connect with insiders. Before You Apply — Checklist ✅ Review the job description thoroughly to understand requirements. ✅ Update your resume to align with the skills and experiences needed. ✅ Prepare a cover letter that reflects your interest in Citi and the role. ✅ Gather references who can vouch for your analytical skills. ✅ Practice common interview questions and scenarios. ✅ Ensure your LinkedIn profile is up-to-date and professional. ✅ Follow Citi on social media to stay informed about company news. ✅ Submit your application before the deadline through the provided link. About Citi Citi was established in 1812 and has expanded to become one of the largest financial institutions globally, operating in over 160 countries . With its headquarters in New York City , Citi serves millions of customers worldwide, showcasing its extensive reach and influence in the financial sector. Among its core offerings, Citi provides innovative financial products such as Citi Double Cash Card , Citi Personal Wealth Management , and Citi Investment Banking . These services cater to diverse customer needs, from personal finance to corporate investments, highlighting Citi's comprehensive approach to financial solutions. Citi has received numerous accolades for its workplace culture, including a Glassdoor rating of 4.0 , which reflects a supportive environment for freshers. The company actively promotes employee development through programs like Citi’s Leadership Development Program , fostering growth and collaboration among its workforce. Recently, Citi announced a significant investment of $3 billion in technology to enhance its digital banking capabilities. This initiative underscores Citi's commitment to innovation and its focus on leveraging technology to improve customer experiences and operational efficiency. Joining Citi as a fresher provides unparalleled access to mentorship and career development opportunities in the analytics domain. With a strong emphasis on training and skill enhancement, new employees can expect to build a solid foundation for their careers in technology. Why Join Citi as Spec Analytics Analyst? As a Spec Analytics Analyst at Citi , you will gain hands-on experience with real-world data sets, enhancing your analytical skills in a structured environment designed for growth. SQL and Excel Proficiency — Participate in a comprehensive training program focused on mastering essential tools for data analysis. Real-World Data Exposure — Work with actual data sets that challenge your analytical skills and improve your problem-solving capabilities. Career Advancement Opportunities — After 1-2 years, explore career paths such as Data Analyst, Business Analyst, or Senior Analyst within Citi . Collaborative Work Culture — Engage in a supportive environment that emphasizes teamwork and communication, crucial for personal and professional growth. Bangalore's Tech Ecosystem — Benefit from a vibrant city that offers networking opportunities and professional development in the technology sector. According to NexisGrow.com, starting your career as a Spec Analytics Analyst at Citi positions you for success in the evolving tech landscape, providing essential skills and a robust professional network. Frequently Asked Questions Interview · Role · Salary · Growth ? Who can apply for Spec Analytics Analyst at Citi? Eligibility Tap to expand + Answer Candidates with 2024, 2025, 2026 and 0-2 years experience are eligible. Eligible batches: 2024, 2025, 2026. ? What skills are most important for this role? Skills Tap to expand + Answer Key skills: SQL, Excel, data analysis. Strong fundamentals and practical project experience matter most. ? What is the salary for this position? Salary Tap to expand + Answer Compensation: ₹8–12 LPA. Final offer depends on skills, experience, and interview performance. ? What is the interview process at Citi? Interview Tap to expand + Answer Typically: Resume shortlisting → Online test → Technical interview(s) → HR round. ? Is this role remote, hybrid, or onsite? Work Mode Tap to expand + Answer Work mode varies by team. Confirm with HR during recruitment. ? What is the career growth path from this role? Growth Tap to expand + Answer Structured appraisals every 6–12 months. Senior roles accessible within 12–18 months based on performance. ? How do I apply? Application Tap to expand + Answer Apply via the official link in How to Apply section. Highlight: SQL, Excel, data analysis. ? Is there a probation period? Probation Tap to expand + Answer Standard 3–6 months probation. Confirmation follows successful completion. ? How to prepare for the Spec Analytics Analyst interview? Preparation Tap to expand + Answer (1) Core concepts of SQL, Excel, data analysis, (2) 2–3 project walkthroughs, (3) Problem-solving, (4) Citi research, (5) Clear communication. ? What is the work culture like at Citi? Culture Tap to expand + Answer Research on LinkedIn and Glassdoor for authentic employee reviews. NexisGrow.com features only verified employers. 🔗 Explore More on NexisGrow More jobs in Bangalore Browse all Tech jobs Latest Fresher jobs More jobs at Citi Work From Home jobs Ready to Apply? Don't Miss This Opportunity! Apply only via the official link. NexisGrow.com charges zero application fees. 👉 Apply Now — Official Link NexisGrow.com does not charge any application or registration fees. Beware of fraudulent offers. Naukri ki baat, NexisGrow ke saath • NexisGrow.com