Senior Software Engineer, Reference Data Platform; Python​/Oracle; AVP

Citi is seeking an experienced and driven Applications Development Senior Programmer Analyst (C12 / AVP) to join our Master Reference Data (MRD) technology organization. In this role, you will be responsible for the design, development, testing and implementation of the Operating Model & Aritifical Intelligence (OMAI) Fusion application - a critical enterprise platform responsible for centralizing, mastering and distributing high-quality reference data across Citi’s global business lines.

As a Senior Programmer Analyst, you will leverage your expertise in Python and Oracle database technologies to build high-performance data processing pipelines, optimize complex database architectures and deliver resilient software solutions that support mission-critical enterprise operations.

• Application & Pipeline Development:
  Design, code, test and implement robust backend services, ETL data pipelines and batch/real-time processing components for the Fusion platform using Python.
• Database Architecture & Optimization:
  Architect, optimize and maintain complex Oracle databases; write, tune and maintain advanced SQL queries, stored procedures, PL/SQL packages, triggers and views to handle large volumes of reference data efficiently.
• Master Reference Data Integration:
  Partner closely with business analysts, data stewards and upstream/downstream application teams to analyze reference data requirements and translate them into scalable technical implementations.
• System Performance & Scalability:
  Identify system bottlenecks, perform performance tuning across Python code and Oracle databases and implement partitioning, indexing and memory optimization strategies.
• Engineering Standards & Quality:
  Define and adhere to software development best practices, test-driven development (TDD), automated unit/integration testing and code review processes to maintain high code quality and reliability.
• CI/CD & Dev Ops
  
  Collaboration:
  
  Work with modern CI/CD pipelines to support automated builds, deployments and environment configuration management.
• Production Support & Risk Mitigation:
  Assist in tier-3 technical troubleshooting and root cause analysis for production incidents; ensure all implementations comply with Citi’s security, risk management and governance standards.
• Mentorship & Team
  
  Collaboration:
  
  Provide technical guidance and peer reviews to junior developers, actively participating in Agile/Scrum ceremonies and sprint planning.

• Experience:
  
  5–8 years of professional experience in software engineering and application development, with a proven track record of delivering enterprise-scale systems into production.
• Python Expertise:
  Strong hands‑on proficiency in Python (3.x) for enterprise application development, data manipulation, object-oriented design and automated testing.
• Oracle & SQL Mastery:
  Advanced proficiency with Oracle Database (12c/19c+), including complex SQL query design, PL/SQL programming, schema design, index optimization, query execution plan analysis and database performance tuning.
• Data Modeling & ETL:
  Strong understanding of relational data modeling, Master Data Management (MDM) concepts, data normalization/denormalization and large-scale data ingestion and transformation pipelines.
• Development Practices:
  Practical experience with version control systems (Git), continuous integration/continuous deployment (CI/CD) pipelines and automated testing frameworks (e.g., pytest, unittest).
• Problem Solving & Communication:
  Excellent analytical, troubleshooting and problem‑solving skills, with the ability to communicate technical concepts clearly to both technical peers and business stakeholders.
• Education:
  
  Bachelor’s degree in Computer Science, Software…