Data and Reporting Analyst
Citi Bank
·Today
- Location
- Gurugram, HR,IN, IN
- Type
- Full-time
- Seniority
- Mid
- Education
- Master
- Source
- Eightfold
Description
Overview:
Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients.
Our mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. We strive to earn and maintain our clients and the publics trust by constantly adhering to the highest ethical standards and making a positive impact on the communities we serve. Our Leadership Standards is a common set of skills and expected behaviors that illustrate how our employees should work every day to be successful and strengthens our ability to execute against our strategic priorities.
The Quality Assurance and Testing Validation (QATV) team delivers independent oversight and rigorous validation across the organization's regulatory reporting ecosystem and is dedicated to ensuring the highest standards of accuracy, reliability and control through testing Citi’s regulatory and management reporting while providing an objective assessment of issue remediation.
QATV Reporting & Analytics team provides analytical support on:
Reporting & Intelligence — Building and maintaining data marts, synthesizing test results into quantitative metrics, and authoring detailed qualitative narratives and formal publication reports for senior stakeholders and report owners.
Operational Intelligence & Capacity Planning — Monitor testing sprints to ensure timeline adherence, leading proactive capacity planning across all execution phases, and leveraging skill assessments to assign qualified personnel to appropriate testing stages.
Testing & Exception Management Automation — Automation of design, creation, and execution of test scripts
Job Summary:
The Data\Information Management Int Analyst will be part of QATV team within Citi AIM vertical, a global community driving data-driven transformation across Citi. AIM's objective is to generate actionable intelligence for business leaders. In this role, the Analyst will support the QATV function by maintaining dedicated testing data marts, consolidating validation outcomes, identifying data inconsistencies, and assisting in the drafting of detailed narrative reports and metrics for final publication to key stakeholders.
Working in close collaboration with team leads, the Analyst will also support testing delivery governance and resource management. This includes monitoring sprint cycles to track milestone adherence, maintaining capacity planning models to ensure balanced workload distribution, and assisting with skills-matrix assessments to align team capabilities with testing demand across all phases of regulatory validation.
In this role, you are expected to:
- Assist in organizing and maintaining dedicated testing data marts and data pipelines.
- Expertise in data management principles, SQL, SAS programming for data extraction, manipulation and validations. Guide and mentor junior members in team in this area.
- Use of data warehousing concepts, ETL processes, and experience working with Business Intelligence platforms (e.g., Tableau, Power BI). To act as SME in this area and go-to person for the team.
- Research and identify data inconsistencies, trends, or reporting gaps to support root-cause analysis.
- Automate current process to remove manual effort
- Develop workflows and automation logic using SAS, SQL, Workflow tools
- Conduct in-depth analyses of current operational processes to identify inefficiencies and areas for improvement.
- Continuously improve processes and strategies by exploring and evaluating new data sources, tools, and capabilities
- Work closely with internal and external business partners in building, implementing, tracking and improving decision strategies
Qualifications:
- Work experience: 5+ years with Masters as Educational background
- Technical Skills: Expertise in data management principles, SQL, SAS , Python programming for data extraction and manipulation, and database management systems. Including Tableau, and other BI tools.
- Strong coding expertise in SAS & SQL, Autosys package.
- Strong analytical and problem-solving skills, with the ability to identify and quantify opportunities for improvement.
- Excellent communication and interpersonal skills
- Banking Knowledge: Good understanding of the banking domain, banking products and Operations in banking is preferred.
- Soft Skills: Ability to multi-task effectively and efficiently in a fast-paced environment.
Note: 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.