VP / Sr. Database Developer

The Enterprise Excellence (EE) team is a group within the Operations and Technology (O&T) that designs solutions to enhance transparency; empowers Operations and Functions to improve processes; and evolves the organization through continuous improvement and simplification. The organization is responsible for defining, deploying, and driving alignment and progress against a firm-wide framework that reduces operational risk, standardizes workforce optimization, and improves process health.

The Senior Database developer will play a key role in designing and developing solutions to support the data management, quality assurance, process mining and data analytics initiatives within the Product & Analytics group. They will work closely with Operations, Technology, Transformation, and Risk & Controls groups across all sectors of the bank to achieve tangible results aligned to the firm’s strategic priorities. Key responsibilities include:

Analyzing and translating the business requirements to design and develop robust and scalable database solutions. This includes aspects such as conceptualizing & developing the data models, the data transformations, data quality framework etc. for medium to high complexity use cases. Writing complex stored procedures to implement the business logic, along with enhancing & debugging the existing database code- with focus on automation, efficiency and error handling.

Hands on experience in query performance tuning, database tuning involving complex PL/SQL code, tables, materialized views etc. Monitoring and controlling all phases of development process- analysis, design, development and testing as well as providing support to the business users. Ensuring essential procedures and best practices are followed along with due documentation- to help achieve higher operating standards & processes.

Ability to operate with a limited level of direct supervision- exercising independent judgement, autonomy & proactivity. Provides the SME support to senior stakeholders & team members, while a mentor to the junior analysts. Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions.

Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firms reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency. Qualifications: Extensive hands-on experience with data modeling, database design and architecture. Experience with Oracle database PL/SQL & DBA experience to enable handling very large datasets efficiently.

Good proficiency in scripting skills in Python and Linux shell are required. Experience with big data technologies (HDFS, Impala, Hive, pySpark etc.) is highly desirable. ETL tool exposure, preferably Talend, and good exposure to other database technologies like Snowflake, Teradata, Starburst etc. is a plus.

Exposure and interest in futuristic technology, Gen-AI/ML is also a plus.

Education: Bachelor’s degree/University degree in computer science/engineering is required. 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.