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: