Data Analyst with SAS and SQL

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

Job summary

Citi is seeking a Data Analyst in Bengaluru to monitor, analyze and improve data processes. You will build and optimize SQL/SAS pipelines, validate data quality, and prepare dashboards for stakeholders.

Strong problem-solving in banking operations and familiarity with BI tools are required. This role focuses on data-driven policy insights and iterative improvements.

Qualifications

• 3+ years of hands-on data analysis, reporting and data engineering experience.
• Strong SQL skills with complex joins, windows, subqueries and optimization.
• Proficiency in SAS including macros, data step processing, and PROC SQL.
• Experience with BI reporting tools (Tableau/Power BI/others) for dashboards.

Responsibilities

• Develop, optimize, and maintain complex SQL queries and SAS scripts for data extraction and aggregation.
• Conduct data analysis, reconciliation, validation, and quality assessments across financial and transactional data.
• Translate business requirements into clear data deliverables and dashboards; support ad-hoc analytics.

Skills

SQL

SAS

Python/Spark/Hive

BI Tools

Tools

Tableau

Power BI

Qlik

MicroStrategy

SAP BusinessObjects

Job description

The Data Analyst is a developing professional role. Applies specialty area knowledge in monitoring, assessing, analyzing and/or evaluating processes and data. Identifies policy gaps and formulates policies. Interprets data and makes recommendations. Researches and interprets factual information. Identifies inconsistencies in data or results, defines business issues and formulates recommendations on policies, procedures or practices. Integrates established disciplinary knowledge within own specialty area with basic understanding of related industry practices. Good understanding of how the team interacts with others in accomplishing the objectives of the area. Develops working knowledge of industry practices and standards. Limited but direct impact on the business through the quality of the tasks/services provided. Impact of the job holder is restricted to own team.

Responsibility

• Data Analysis, Querying & Extraction
  • Develop, optimize, and maintain complex SQL queries and SAS scripts/macros to extract, transform, and aggregate datasets from relational databases and enterprise data lakes.
  • Conduct data analysis, data reconciliation, validation, and quality assessments across multifaceted financial and transactional datasets.
  • Perform root cause analysis for data discrepancies and collaborate with upstream/downstream data owners to implement robust resolutions.
• Reporting & Dashboard Development : Good to have
  • Translate business requirements and ad-hoc analytics requests from stakeholders into clean, interpretable, and high-impact data deliverables.
  • Streamline manual reporting cadences to tools like tableau.
• AI Tool Adoption & Continuous Innovation
  • Have an idea or exposure to leverage modern AI productivity tools and workflows (e.g., AI-assisted code generation, data exploration, automated documentation, process automation) to enhance operational efficiency

Requirement

• Experience: Minimum 3+ years of hands-on professional experience in data analysis, reporting, and database programming.
• Core Technical Competencies:
  • SAS: Intermediary to advance proficiency in Base SAS, SAS Macros, PROC SQL, and data step processing.
  • SQL: Strong hands-on querying, complex joins, subqueries, analytical window functions, indexing, and query optimization across enterprise RDBMS +Basics of python /Spark and understanding of HIVE
  • Good to have BI & Reporting Tools: Direct hands-on experience developing reports and visual dashboards in at least one enterprise reporting platform (e.g., Tableau, Power BI, Qlik, MicroStrategy, or SAP BusinessObjects).
• Domain Knowledge:
  • understanding of banking, financial services operations, and core financial metrics.
• Analytical & Logical Capabilities:
  • Good problem-solving, critical thinking, and structured analytical skills with keen attention to detail.
  • Proven ability to dissect complex data logic and design elegant, maintainable analytical solutions.

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.