Reporting Analyst with Python and SQL with Gen AI/AI

Citigroup Inc.; Gurugram District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Citigroup Inc. in Gurugram invites an analyst for Reporting Insights and GenAI to build analytical solutions supporting Banking Operations & Analytics in the COO office.

The role emphasizes data collection, analysis, automation, and dashboard creation using SQL, SAS, Python, PySpark, Tableau, and Power BI to deliver actionable insights for business decisions. The ideal candidate has 2+ years of experience in reporting/automation andGenAI, develops scripts for automation, and communicates

Qualifications

• 2+ years of experience in Reporting & Automation and GenAI with proficiency in BI tools like SQL, SAS, Python, PySpark, Tableau etc.
• Ability to develop scripts for automating routine tasks (e.g., Python scripting for file processing, API integrations).
• Experience in developing reports, performing data analysis, and implementing automation solutions.
• Strong understanding of reporting and automation data & analytics ecosystem, establish a scalable analytics framework – data strategy, process optimization, actionable insights, visualization techniques.
• Experience in Developing, Deploying AI or GenAI-powered solutions in partnership with Tech and Business.
• AI / Gen AI proficiency in Financial/Business Analysis and/or operation risk analysis with ability to impact key business drivers

Responsibilities

• Data Collection and Analysis: Gathering data from various sources, cleaning it, and analyzing it to identify trends, patterns, and insights relevant to business operations.
• Report Generation: Designing, developing, and maintaining regular and ad-hoc reports for different stakeholders with KPIs, operational metrics and financial data.
• Automation Development: Identifying manual tasks and developing automated solutions using tools/technologies like SQL, SAS, Python, PySpark, Tableau.
• Process Improvement: Analyzing workflows to pinpoint inefficiencies and recommend improvements leveraging automation.
• Dashboard Creation: Developing interactive dashboards using Tableau, Python, Power BI for real-time visibility into performance and trends.
• Stakeholder Communication: Presenting findings and recommendations to departments and management in clear terms.
• Documentation: Documenting data requirements, collection/processing/cleaning, and EDA including automation/visualization techniques.
• Data Handling: Work with large, complex, unstructured data to evaluate and support business strategies

Skills

Data analysis

Data manipulation & querying

Reporting & visualization

Problem-solving

Education

Bachelor's degree in STEM

Master’s degree preferred

Tools

SQL

SAS

Python

PySpark

Tableau

Power BI

Qlik Sense

Job description

Reporting Insights and GenAI, Analyst – Analytics & Information Management (AIM), Gurugram

We are seeking an analyst for our Reporting Insights and GenAI Team. The ideal candidate will be responsible for the development of analytical solutions to support key business objectives for Banking Operations & Analytics as part of COO (Chief Operating Office). This role requires an analyst with a proven track record of delivering impactful insights and fostering a data-driven culture.

Roles and Responsibilities:

• Data Collection and Analysis:Gathering data from various sources, cleaning it, and analyzing it to identify trends, patterns, and insights relevant to business operations.
• Report Generation:Designing, developing, and maintaining regular and ad-hoc reports for different stakeholders. These reports often present key performance indicators (KPIs), operational metrics, and financial data in an understandable format.
• Automation Development:Identifying manual, repetitive tasks and processes within the organization and developing automated solutions to streamline them. This can involve scripting, using automation tools/technologies like SQL, SAS, Python, PySpark, Tableau etc.
• Process Improvement:Analyzing existing workflows to pinpoint inefficiencies and recommend improvements, often leveraging automation to achieve these.
• Dashboard Creation:Developing interactive dashboards using reporting tools (e.g., Tableau, Python, Power BI) to provide real-time visibility into performance and trends.
• Stakeholder Communication:Presenting findings and recommendations to various departments and management, explaining complex data in a clear and concise manner.
• Documentation: Responsible for documenting data requirements, data collection / processing / cleaning, and exploratory data analysis, which may include Process Automation / Optimization and data visualization techniques.
• Data Handling: Work with large, complex and unstructured data to evaluate, recommend, and support the implementation of business strategies

Core Competencies:

• Data Analysis & Insight Extraction:Proficiently applying analytical techniques to complex datasets to fetch meaningful, actionable insights that address business questions and drive decision.
• Data Manipulation & Querying: Expert ability to query and manipulate data from various data sources (using SQL/Python/R), ensuring data quality and readiness for analysis and reporting.
• Reporting & Visualization Tools:Expertise in using reporting & visualization platforms (e.g., Tableau, Power BI, Qlik Sense) to design, develop, and maintain dynamic dashboards and reports that clearly communicate performance and insights.
• Problem-Solving:Proactively identifying issues and developing practical, value-driven solutions.

Qualifications:

• 2+ years of experience in Reporting & Automation, Reporting Insights and GenAI with proficiency in business intelligence tools/technologies like SQL, SAS, Python, PySpark, Tableau etc.
• Ability to develop scripts for automating routine tasks (e.g., Python scripting for file processing, API integrations).
• Experience in developing reports, performing data analysis, and implementing automation solutions.
• Strong understanding of reporting and automation data & analytics ecosystem, establish a scalable analytics framework – data strategy, process optimization, actionable insights, visualization techniques.
• Experience in Developing, Deploying AI or GenAI-powered solutions in partnership with Tech and Business
• AI / Gen AI proficiency in Financial/Business Analysis and/or operation risk analysis with ability to impact key business drivers

Education:

• Bachelors/University degree in STEM, Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Job Family Group:

Decision Management

Job Family:

Data/Information Management

Time Type:

Full time

Most Relevant Skills

Please see the requirements listed above.

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi's EEO Policy Statement and the Know Your Rights poster.