Lead Data Analyst (Advance SQL) - VP - C13 - Pune

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

The Applications Development Technology Lead Analyst is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to lead applications systems analysis and programming activities.

Responsibilities:

• The Lead Analyst will be responsible for re-engineering the interaction of incoming and outgoing data flows from the Core Accounts DDA platform to Reference Data platforms, Data Warehouse, Data Lake as well as other local reporting systems which consume data from Core Accounts
• Drive the data architecture and roadmap for eliminating non-strategic point to point connections and batch handoffs
• Define canonical data models for key entities and events related to Customer, Account, Core DDA in line with the Data Standards
• Assess opportunities to simplify/rationalize/refactor the existing database schemas paving way for modularization of the existing stack
• Provide technical guidance to Data Engineers responsible for designing an Operational Data Store for intra-day and end-of-day reporting. Implementing data strategies and developing logical and physical data models.
• Formulate efficient approach to rationalize and formulate strategy to migrate reports
• Build and nurture a strong engineering organization to deliver value to internal and external clients
• Acts as SME to senior stakeholders in business, operations, and technology divisions across upstream and downstream Organizations.
• Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users.
• Exposure to Industry Core Banking Platforms is must eg Flexcube
• Liaise closely with Product Owners to translate the User Stories to well-defined technical requirements and solutions

Qualifications

• Significant experience in Data lineage analysis, Operational reporting, preferably in a global organization
• 12+ years relevant industry experience
• Proven architecture experience in solutioning of horizontally scalable, highly available, highly resilient data distribution platforms
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Experience with Data Integration patterns and with Real/Near Real time streaming patterns.
• Strong background in Data Management, Transformation initiatives preferred.
• Preferred Experience/Familiarity with core banking product, Flexcube

Education:

• Bachelor’s degree/University degree or equivalent experience
• 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.

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

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.