Senior Reporting And Automation Analyst - Python And Generative AI

Citi; Gurugram District; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Citi in India seeks a Reporting Insights and GenAI Senior Analyst (Legal Analytics) to drive data-driven decision making through data collection, cleaning, and in-depth analysis. You will design MIS, automate reporting, and build dashboards to reveal KPIs and insights for business operations.

You will lead applied AI/GenAI initiatives, leveraging SQL, SAS, Python, PySpark, Tableau, Power BI, and related tools to deliver predictive insights while ensuring data quality and governance across

Qualifications

• 5+ years of experience in Reporting & Automation, Reporting Insights and GenAI with proficiency in business intelligence tools/technologies like SQL, SAS, Python, Tableau, MicroStrategy, etc.
• Ability to develop scripts for automating routine tasks (e.g., Python scripting for file processing, API integrations).
• Experience demonstrating a strong track record in developing reports, performing data analysis, and implementing automation solutions.
• Strong understanding of the reporting and automation data & analytics ecosystem; ability to establish a scalable analytics framework – data strategy, process optimization, actionable insights, visualization techniques.
• Demonstrable experience in developing and deploying AI/ML models (e.g., for forecasting, classification, NLP) or GenAI-powered applications in a business or financial context.
• Hands‑on experience with AI/ML frameworks and libraries (e.g., Scikit-learn, TensorFlow, PyTorch) and familiarity with prompt engineering techniques for Large Language Models (LLMs).
• Experience with any banking operations (e.g., expense analytics, movement of funds, cash flow management, fraud analytics, ROI). Knowledge of regulatory requirements related to data privacy and security.

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.
• MIS and Reporting: Designing, developing, and maintaining regular and ad-hoc Management Information Systems (MIS) and reports for different stakeholders. These reports often present 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.
• Applied AI and GenAI Integration: Leading the exploration, development, and integration of AI, ML, and GenAI solutions, including LLMs, NLP, and predictive analytics to enhance data-driven decision-making and automate complex analytical processes.
• Stakeholder Communication: Presenting findings and recommendations to various departments and management, explaining complex data in a clear and concise manner.
• System Maintenance: Ensuring the accuracy and reliability of reporting systems and automation tools, troubleshooting issues, and performing regular updates.
• Documentation: Documenting data requirements, data collection/processing/cleaning, and exploratory data analysis, including Process Automation / Optimization and data visualization techniques.
• Data Governance and Quality: Contributing to efforts to maintain data quality, consistency, and adherence to data governance policies.
• Data Handling: Work with large, complex and unstructured data to evaluate, recommend, and support the implementation of business strategies.

Skills

Data Analysis & Insight Extraction

Data Manipulation & Querying

Reporting & Visualization Tools

Automation Technologies & Scripting

Applied AI/ML and GenAI

Problem-Solving

Education

Bachelor's degree in STEM

Master's degree preferred

Tools

SQL

SAS

Python

PySpark

Tableau

Power BI

Qlik Sense

MicroStrategy

Job description

Job Description

Excited to grow your career?

Roles and Responsibilities

• The Reporting Insights and GenAI Senior Analyst (Legal Analytics) accomplishes results by contributing significantly to the bank's success by focusing on improving efficiency, accuracy, and insights through data and process optimization. The responsibilities involve a blend of data analysis, report generation, and the development of automated solutions.

• Data Collection and Analysis: Gathering data from various sources, cleaning it, and analyzing it to identify trends, patterns, and insights relevant to business operations.

• MIS and Reporting: Designing, developing, and maintaining regular and ad-hoc Management Information Systems (MIS) and 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.

• Applied AI and GenAI Integration: Leading the exploration, development, and integration of Artificial Intelligence (AI), Machine Learning (ML), and Generative AI (GenAI) solutions. This includes leveraging Large Language Models (LLMs), Natural Language Processing (NLP), and predictive analytics to enhance data-driven decision-making and automate complex analytical processes.

• Stakeholder Communication: Presenting findings and recommendations to various departments and management, explaining complex data in a clear and concise manner.

• System Maintenance: Ensuring the accuracy and reliability of reporting systems and automation tools, troubleshooting issues, and performing regular updates.

• 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 Governance and Quality: Contributing to efforts to maintain data quality, consistency, and adherence to data governance policies.

• 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, MicroStrategy) to design, develop, and maintain dynamic dashboards and reports that clearly communicate performance and insights. This includes a strong focus on MIS and executive-level reporting.

• Automation Technologies & Scripting: Strong capability in identifying automation opportunities, developing and implementing automated solutions using automation tools and scripting languages, and optimizing existing automated workflows.

• Applied AI/ML and GenAI: Strong understanding and practical application of machine learning concepts, predictive modeling, and Generative AI technologies, including prompt engineering and experience with LLMs, to solve business problems.

• Problem-Solving: Proactively identifying issues and developing practical, value-driven solutions.

Qualifications

• 5+ years of experience in Reporting & Automation, Reporting Insights and GenAI with proficiency in business intelligence tools/technologies like SQL, SAS, Python, Tableau, MicroStrategy, etc.

• Ability to develop scripts for automating routine tasks (e.g., Python scripting for file processing, API integrations).

• Experience demonstrating a strong track record in developing reports, performing data analysis, and implementing automation solutions.

• Strong understanding of the reporting and automation data & analytics ecosystem; ability to establish a scalable analytics framework – data strategy, process optimization, actionable insights, visualization techniques.

• Demonstrable experience in developing and deploying AI/ML models (e.g., for forecasting, classification, NLP) or GenAI-powered applications in a business or financial context.

• Hands‑on experience with AI/ML frameworks and libraries (e.g., Scikit-learn, TensorFlow, PyTorch) and familiarity with prompt engineering techniques for Large Language Models (LLMs).

• Experience with any banking operations (e.g., expense analytics, movement of funds, cash flow management, fraud analytics, ROI). Knowledge of regulatory requirements related to data privacy and security.

Education

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

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.