Data Analyst-Reporting And Automation

Citi; Gurgaon; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Citi in Gurugram is seeking a Reporting & Automation Analyst to drive data-driven insights for Banking Operations & Analytics within the COO. The role blends data analysis, reporting, and automation to improve efficiency and accuracy.

You will collect and clean data from multiple sources, build dashboards with Tableau/Power BI, and develop automated scripts (SQL, Python, SAS, PySpark) to streamline processes. Strong stakeholder communication and governance are essential for success in this role.

Qualifications

• 5+ years of experience in Reporting & Automation, Data/Information Management roles with BI tools
• Ability to develop scripts for automating routine tasks (e.g., Python)
• Experience in developing reports, data analysis and automating solutions
• Strong understanding of analytics ecosystem, data strategy and visualization techniques
• Experience with AI solutions in partnership with Tech and Business
• Knowledge of banking operations data privacy and security requirements
• AI / Gen AI proficiency and leadership in financial/operational domains

Responsibilities

• Data collection, cleaning and analysis to identify trends and insights
• Designing, developing, and maintaining regular and ad-hoc reports with KPIs and metrics
• Developing automated solutions to streamline manual tasks using SQL, Python, SAS, PySpark
• Analyzing workflows to identify inefficiencies and proposing improvements
• Building interactive dashboards (Tableau, Power BI, Python) for real-time visibility
• Presenting findings and recommendations to stakeholders and management
• Maintaining accuracy and reliability of reporting systems and automation tools
• Documenting data requirements, processing steps, and governance practices
• Contributing to data governance and quality initiatives

Skills

Data analysis

SQL/Python/R

Tableau/Power BI

Automation scripting

Stakeholder communication

Education

Bachelor's degree in STEM

Master’s degree preferred

Tools

SQL

SAS

Python

PySpark

Tableau

Power BI

Job description

Job Description:

Reporting & Automation Analyst – AIM, Gurugram

Excited to grow your career?

• We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions.
• Our people make all the difference in our success.
• We are seeking an experienced and strategic Data Analyst for our Data/Information Management Team. The ideal candidate will be responsible for driving the development and implementation of analytical solutions to support key business objectives for Banking Operations & Analytics as part of COO (Chief Operating Office). This role requires a strong analyst with a proven track record of delivering impactful insights and fostering a data-driven culture.

Roles and Responsibilities:

The Data/Information Management Analyst (Banking Operations & 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 involves 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.
• 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.
• 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) to design, develop, and maintain dynamic dashboards and reports that clearly communicate performance and insights.
• 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.
• Problem-Solving:Proactively identifying issues and developing practical, value-driven solutions.

Qualifications:

• 5+ years of experience in Reporting & Automation, Data/Information Management Analyst roles 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 demonstrating a strong track record 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 and Deploying AI solutions in partnership with Tech and Business
• 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
• AI / Gen AI proficiency and thought leadership 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.

Time Type :Full time

Most Relevant Skills

Please see the requirements listed above.

Job Level :C11

Job Family Group:

Decision Management

Job Family:

Data/Information Management

Time Type:

Full time

Most Relevant Skills

Please see the requirements listed above.

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.