Senior Technical Data Analyst - Assistant Vice President

Overview

Serve as a senior-level Technical Data Analyst bridging complex business requirements and technical data solutions, with a focus on regulatory reporting and liquidity risk initiatives. Liaise with business stakeholders and technology teams to articulate data needs, extract insights, and ensure data quality and integrity.

What you'll do

• Consult with business clients to determine system functional specifications and partner with multiple management teams and other units to meet organizational objectives.
• Define, document, and validate detailed data requirements, data flows, and data lineage for new or enhanced systems and applications.
• Provide technical input during development and implementation phases, including formulating and defining systems scope, data objectives, and necessary data architecture enhancements for complex, high-impact projects.
• Design and develop robust conceptual, logical, and physical data models to support reporting, analytics, and business processes.
• Prepare and curate data for AI/ML model development, working closely with AI engineers on data quality, feature engineering, and model validation.
• Use advanced SQL for data extraction, manipulation, and analysis from relational databases, data warehouses, and Big Data platforms.
• Develop and maintain data visualization dashboards and reports using tools such as Tableau, Power BI, or QlikView, translating complex data into understandable business insights.
• Lead analysis of complex data sets to identify trends, patterns, and anomalies relevant to regulatory reporting, liquidity risk, and other critical financial functions.
• Identify and communicate data-related risks and impacts and propose risk mitigation options, considering business implications of technology in the current business environment.
• Evaluate new data technologies, analytical tools, and evolving business requirements, and recommend systems alternatives or enhancements by analyzing business processes, systems, and industry standards.
• Serve as an advisor or coach to new or lower-level analysts.
• Assess risk in business decisions, consider the firm's reputation and the safeguarding of Citigroup, its clients, and assets, drive compliance with applicable laws, rules, and regulations, adhere to policy, apply sound ethical judgment, and escalate, manage, and report control issues transparently.

What you'll need

• 6-8 years of experience as a Technical Data Analyst or similar role within the Financial Services industry, preferably in regulatory reporting such as Basel, CCAR, or FR 2052a and liquidity risk.
• Advanced proficiency in SQL for complex data querying, analysis, and optimization across large datasets.
• Strong experience with relational databases such as Oracle, SQL Server, or DB2 and data warehousing concepts such as dimensional modeling and star/snowflake schemas.
• Demonstrated expertise with Big Data technologies including Hadoop, Spark (PySpark/Scala Spark), Kafka, and cloud-based data platforms such as AWS S3 and Databricks.
• Demonstrated experience with data modeling tools and techniques.
• Proficiency in data visualization tools such as Tableau, Power BI, or QlikView.
• Strong Excel skills for data manipulation and presentation.
• Comprehensive knowledge of data analysis principles, methodologies, and data governance frameworks.
• Experience across all phases of the Software Development Life Cycle (SDLC), with a focus on data-centric projects.
• Clear and concise written and verbal communication.
• Problem-solving and decision-making skills.
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements.
• Bachelor's degree/University degree or equivalent experience.

Nice to have

• Experience with scripting languages for data analysis such as Python or R.
• Experience with data preparation for AI/ML models and understanding of core AI/ML concepts and workflows.
• Master's degree.

Details

• Location: Pune, Maharashtra, India.
• Employment type: Full time.