Senior Data Platform Engineer - Reference Data (Hybrid)

Citi; Belfast City District; Hybrid; GBP 80,000 - 120,000; Full time

Benefits offered by this job

Hybrid work

Continuous learning

Career development

Competitive compensation

Job summary

Citi is seeking an experienced Applications Development Senior Programmer Analyst (AVP) to join the MRD technology group. You will design, develop and optimize the OMAI Fusion platform, focused on centralizing reference data using Python and Oracle databases.

You will work in a hybrid model, collaborating with global teams, ensuring high quality code, robust ETL pipelines and scalable architectures to support mission-critical enterprise operations.

Qualifications

• 5–8 years of professional experience in software engineering and application development.
• Strong hands-on proficiency in Python (3.x) for enterprise application development, data manipulation, object-oriented design and automated testing.
• 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.
• Relational data modeling, Master Data Management (MDM) concepts, data normalization/denormalization and large-scale data ingestion and transformation pipelines.
• Version control with Git, CI/CD pipelines and automated testing frameworks (pytest, unittest).
• Excellent analytical and communication skills; ability to convey technical concepts to stakeholders.
• Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or related field; or equivalent work experience.

Responsibilities

• Design, code, test and implement backend services, ETL data pipelines and batch/real-time processing components for the Fusion platform using Python.
• 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.
• Partner with analysts and data stewards to translate reference data requirements into scalable implementations.
• Identify bottlenecks and perform performance tuning across Python code and Oracle databases; implement partitioning and indexing strategies.
• Define and adhere to software development best practices, TDD, automated testing and code reviews.
• Work with CI/CD pipelines to support automated builds, deployments and environment configuration management.
• Assist in tier-3 production support and root-cause analysis for incidents; ensure compliance with security and governance standards.
• Provide mentorship and participate in Agile/Scrum ceremonies and sprint planning.

Skills

Python

Oracle SQL

Data modeling

CI/CD

Unit testing

Git

Communication

Education

Bachelor’s degree or equivalent experience

Job description

Citi is seeking an experienced Applications Development Senior Programmer Analyst (AVP) to join the MRD technology group. You will design, develop and optimize the OMAI Fusion platform, focused on centralizing reference data using Python and Oracle databases.

You will work in a hybrid model, collaborating with global teams, ensuring high quality code, robust ETL pipelines and scalable architectures to support mission-critical enterprise operations.