Data Science Senior Analyst - C12

The Application Development Database Senior 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:

• Technical Leadership: Lead technical solutions, mentor developers, and conduct reviews (design, code, documentation).
• Software Development Lifecycle (SDLC): Manage all phases from analysis and design to coding, testing, and continuous integration.
• Database Management: Design, manage, and optimize relational and NoSQL databases, including query development and indexing.
• Data Management: Develop efficient data management components, process external data, and ensure data sharing between systems.
• Security & Compliance: Implement and ensure application security, analyze third-party software compatibility, and adhere strictly to Citi's engineering standards.
• Architectural Improvement: Proactively suggest improvements to database architecture, processes, and technologies.
• Client & Team Communication: Maintain clear communication with clients and project teams.
• Operational Autonomy: Operate with limited supervision and help define operating standards

Education:

Bachelor’s degree/University degree or equivalent experience

Master’s degree preferred

Qualifications:

• 5 plus years of relevant experience in the Financial Service industry
• Extensive experience in system analysis and in programming of Database applications
• Subject Matter Expert (SME) in Database System and Development
• Basic knowledge of industry practices and standards
• Consistently demonstrates clear and concise written and verbal communication
• Be the technical expert and mentor other team members
• Having 8 - 10 Years Experience in RDBMS Database Development preferably in Oracle Database.
• Proficient in SQL including writing complex and analytical queries
• Proficient in creating/maintaining DB objects (tables, indexes), and data manipulation (DML)
• Proficient in PL/SQL including writing stored procedures, functions, packages, etc.
• Good understanding of DB Design principles including concepts such as normalization and general best practice of Database security such as controlling privileges
• Knowledge / experience in Data Warehouse and Dimensional modelling and ETL
• Performance Tuning skills, ability to troubleshoot for performance issues and analyzing Explain/Execution Plan is a plus

Technical Skills:

• Databases: Oracle, PL/SQL
• Data modeling of relational databases - (Oracle/Other RDBMS)
• PL/SQL, SQL, and Performance Tuning expertise.
• Working experience of designing end-to-end Database / Datawarehouse System.
• Github, Jenkins, CICD and related tools.

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as require

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

Job Family Group:

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

Job Family:

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

Time Type:

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

Most Relevant Skills

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

Other Relevant Skills

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

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.