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

On-site in Belfast·Full-time·Added 7 days ago (last checked 26 Oct)

Citi

179 open roles

Apply

Our summary

Work mode: On-site, Belfast
Contract: Full-time
Experience: 5+ years

Skills

Requirements

What we're looking for

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

The role

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.

What you'll do

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