Senior Software Engineer, Reference Data Platform (Python/Oracle) – AVP

Overview

In this role you will design and deliver the OMAI Fusion platform to centralize and distribute high-quality reference data across Citi. You will build and optimize data pipelines and backend services using Python, while leveraging Oracle databases to support enterprise operations. You will collaborate with analysts and engineering teams, uphold quality and security standards, and contribute to DevOps and Agile practices. This role offers the chance to shape critical data infrastructure at scale within a global financial services context.

Pay / Benefits

• hybrid work model
• technical training and certifications
• career development programs
• global wellness resources
• competitive compensation and benefits

Responsibilities

• Design, code, test and implement backend services, ETL pipelines, and real-time/batch processing for the Fusion platform using Python
• Architect and optimize Oracle databases; develop advanced SQL, PL/SQL, and performance tuning
• Collaborate with business analysts, data stewards and application teams to translate data requirements into scalable implementations
• Identify bottlenecks and perform performance tuning; apply partitioning, indexing and memory optimization
• Define and adhere to SDLC standards; implement TDD, automated tests and code reviews
• Support CI/CD pipelines for automated builds and deployments, and manage environment configurations
• Provide production support, root cause analysis and ensure compliance with security and governance standards
• Mentor junior developers and participate in Agile/Scrum ceremonies and sprint planning

Key requirements

• 5–8 years of professional software engineering experience
• Strong Python (3.x) for enterprise development
• Advanced Oracle Database experience (12c/19c+); complex SQL, PL/SQL, schema design
• Data modeling, MDM concepts, and large-scale ETL pipelines
• Git, CI/CD, and automated testing frameworks (pytest, unittest)
• Analytical problem solving and clear communication with technical and business stakeholders
• Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or related field or equivalent experience

• Analytical thinking
• Clear communication
• Team collaboration
• Python (3.x)
• Oracle Database (12c/19c+)
• Advanced SQL and PL/SQL

…