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

Reposted Yesterday
Be an Early Applicant
Belfast, County Antrim, Northern Ireland, GBR
Hybrid
Senior level
Financial Services
The Role
Design, develop, test, and implement Python backend services, ETL pipelines, and batch or real-time processing components for an enterprise reference data platform. Architect and optimize Oracle databases, SQL queries, and PL/SQL packages while improving performance, scalability, and reliability. Integrate master reference data, support CI/CD and automated testing, troubleshoot production issues, and ensure governance compliance. Collaborate with business and technology teams, participate in Agile delivery, and mentor junior developers.
Summary Generated by Built In

Role Overview

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 & Artificial 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.


Key Responsibilities

    • 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 & DevOps 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.

Required Qualifications & Skills

    • 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 Engineering, Information Technology, or a related field; or equivalent relevant work experience.

Beneficial Skills & Qualifications

    • Experience working within Financial Services, specifically with Master Reference Data, market data, instrument/counterparty reference data, or regulatory reporting systems.
    • Experience with Python web frameworks and API design (FastAPI, Flask, or Django) for building internal data services and RESTful APIs.
    • Familiarity with enterprise workload scheduling tools (e.g., Autosys, Airflow, Control-M) and enterprise messaging systems (e.g., Apache Kafka, IBM MQ).
    • Familiarity with containerization technologies (Docker, OpenShift, Kubernetes) and cloud infrastructure concepts.
    • Experience in Linux/Unix shell scripting and automated deployment automation.

What We Offer

At Citi, you will work at the core of enterprise data management and financial services technology, contributing to critical platforms that operate at genuine global scale. This is an opportunity to take technical ownership, develop domain expertise in reference data systems and make a measurable impact within a collaborative, performance-focused engineering environment.

    • Hybrid Working Arrangement: Hybrid model with 3 days in the office and 2 days working remotely, offering flexibility while staying connected with your team.
    • Continuous Learning & Growth: Access to comprehensive technical training, certifications and career development programs.
    • Enterprise Impact: The opportunity to build and scale core reference data solutions that underpin trading, risk, compliance and reporting across global Citi franchises.
    • Comprehensive Wellbeing & Compensation: Competitive financial compensation and benefits packages designed for experienced technology professionals, along with global wellness resources.

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

Job Family Group: Technology

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

Job Family:Applications Development

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

Time Type:Full time

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

Most Relevant Skills Please see the requirements listed above.

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

Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.

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

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.

Skills Required

  • 5-8 years of professional experience in software engineering and application development
  • Bachelor's degree in Computer Science, Software Engineering, Information Technology, or a related field, or equivalent relevant work experience
  • Strong proficiency in Python 3.x for enterprise application development, data manipulation, object-oriented design, and automated testing
  • Advanced proficiency with Oracle Database 12c/19c or later
  • Advanced SQL query design, PL/SQL programming, schema design, index optimization, execution plan analysis, and database performance tuning
  • Understanding of relational data modeling, Master Data Management concepts, normalization/denormalization, and large-scale data ingestion and transformation pipelines
  • Experience with Git, CI/CD pipelines, and automated testing frameworks such as pytest or unittest
  • Strong analytical, troubleshooting, problem-solving, and technical communication skills
  • Experience with financial services Master Reference Data, market data, instrument or counterparty reference data, or regulatory reporting systems
  • Experience with FastAPI, Flask, or Django and RESTful API design
  • Familiarity with Autosys, Airflow, or Control-M
  • Familiarity with Apache Kafka or IBM MQ
  • Familiarity with Docker, OpenShift, Kubernetes, and cloud infrastructure concepts
  • Experience with Linux/Unix shell scripting and automated deployment automation
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
226,610 Employees
Year Founded: 1998

What We Do

Citigroup is a global diversified financial services holding company serving consumers, corporations, governments and institutions. It provides consumer banking and credit, corporate and investment banking, securities brokerage, trade and securities services, and wealth management. Operating across nearly 160 countries and jurisdictions, Citi aims to be a leading partner for institutions with cross-border needs, a global wealth manager, and a valued personal bank in the United States.

Similar Jobs

Citi Logo Citi

Senior Software Engineer

Fintech • Financial Services
In-Office
Belfast, County Antrim, Northern Ireland, GBR
223850 Employees

Pfizer Logo Pfizer

Marketing Associate

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Remote or Hybrid
8 Locations
121990 Employees
69K-114K Annually

Samsara Logo Samsara

Account Executive

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United Kingdom
4000 Employees

WHOOP Logo WHOOP

Senior Manager, Trade Marketing, EU (12-Month Contract)

Fitness • Hardware • Healthtech • Sports • Wearables
Remote or Hybrid
United Kingdom
500 Employees
40-45 Hourly

Similar Companies Hiring

Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account