Citigroup logo

Business Analytics Analyst

Citigroup
NewPosted today

LOCATION

Bangaluru · Hybrid

EXPERIENCE

5 - 8 Years

TYPE

FullTime

SKILLS REQUIRED

SQLPythonPySparkData analysisA/B TestingTableauPower BiDashboard DevelopmentData Quality

Job description

Overview

Analytics and AI enablement specialist (C11) within Citi's Analytics & Information Management group, acting as analytical owner and insight lead across Credit Card and Wealth Management products.

What you'll do

  • Partner with Cards and Wealth Product Managers, Marketing and Segment teams to translate business priorities into technical logic.
  • Develop, test and execute data extraction queries and analytical pipelines using SQL, PySpark and Python to generate analytical datasets and customer segment pools.
  • Analyze customer lifecycle funnels across Card and Wealth portfolios to diagnose drop-offs and identify revenue-generating opportunities.
  • Design and execute test-versus-control experimental frameworks and A/B test splits to isolate incremental conversion, spend lift, revolving behavior and Net New Assets (NNA).
  • Analyze transactional patterns, merchant categories, revolving balances and channel touchpoints to recommend strategy refinements and targeting optimization.
  • Build and maintain interactive performance dashboards in Tableau / Power BI with automated data aggregation feeds.
  • Organize analytics rules, data dictionaries, product taxonomies and strategy playbooks into searchable knowledge bases for AI retrieval.
  • Optimize data retrieval contexts and prompt structures for conversational AI and retrieval-augmented tools.
  • Apply Text-to-SQL interfaces and NLP techniques to accelerate ad-hoc data exploration, query generation and client feedback analysis.
  • Use GenAI coding tools to draft, optimize and debug SQL queries, PySpark transformations and Python scripts.
  • Leverage GenAI pipelines to generate executive narrative summaries, performance commentary and anomaly explanations.
  • Use Generative AI to generate personalized messaging copy variations and engagement talking points for specific card and wealth tiers.
  • Manage and version-control analytical scripts, SQL queries and configuration files using Git / GitHub.
  • Perform QA validations such as row count reconciliations, schema validations, null checks and deduplication before delivering datasets and insights.
  • Maintain documentation of data definitions, analytical assumptions and data lineage.

What you'll need

  • Bachelor's degree in Computer Science, Information Technology, Engineering, Statistics, Mathematics, Economics or related quantitative field.
  • 5–8 years of hands-on experience in Credit Cards Analytics, Wealth Analytics, Marketing Analytics, Business Intelligence or Customer Data Operations within Banking / Financial Services.
  • Strong hands-on proficiency in SQL, including complex joins, CTEs, window functions and query execution plan optimization.
  • Practical working knowledge of Python and PySpark for data manipulation, pipeline automation and analytical dataset creation.
  • Strong background in customer lifecycle analytics, spend/balance behavior, portfolio growth, test vs. control lift measurement and funnel conversion analysis.
  • Proven experience designing executive-level interactive performance dashboards in Tableau or Power BI.
  • Solid understanding and practical usage of Git / GitHub for code repository management, branching and versioning.
  • Solid conceptual understanding of modern AI, Large Language Models and Conversational AI capabilities.
  • Experience setting up, organizing and structuring domain knowledge bases, data schemas and contextual documentation for AI-assisted workflows.
  • Understanding of retrieval optimization techniques to feed relevant context into LLMs for accurate code generation and data querying.
  • Demonstrated ability to craft structured, multi-turn and few-shot prompts for data analysis, code generation and content drafting.
  • Practical familiarity with Text-to-SQL tools and Natural Language Processing techniques for data extraction, schema querying and text analysis.
  • Experience utilizing AI coding tools to accelerate SQL/Python script writing, query refactoring and automated debugging.
  • Practical experience using GenAI to summarize portfolio outcome metrics into narrative insights and brainstorm personalized copy variations.
  • Excellent communication and stakeholder management skills, with ability to translate complex card/wealth data into strategic business recommendations.
  • Strong problem-solving orientation with attention to detail, data accuracy and regulatory compliance.
  • Proactive mindset with keen interest in adopting and propagating modern AI productivity tools within the team.

Nice to have

  • Familiarity with modern data platforms, data lakes and Dataiku DSS.

Details

  • Full-time position.
  • Location: Bangaluru, Karnataka, India.

Read the full description and apply on the company’s own careers page.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

Business Analytics Analyst