Senior Software Engineer, Reference Data Platform; Python/Oracle; Avp
-
Software Development
Job Description & How to Apply Below
Location: Belfast City District
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 & 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,…
Position Requirements
10+ Years work experience(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction