Data Engineering Lead (Ab Initio), Vice President

Citi; Belfast; Hybrid; GBP 90,000 - 120,000; Full time

Benefits offered by this job

Private medical insurance

Pension plan

Discretionary bonus

Employee Assistance Program

Learning & development resources

Paid parental leave

Job summary

Citi Belfast is seeking a senior data engineering expert with deep Ab Initio and ETL development experience to join the Oracle Ledger Data Engineering team. You will design and build critical data pipelines for the firm’s financial systems, ensuring accuracy and integrity of financial data and collaborating with business users and technology partners.

In this role you will lead end-to-end SDLC within Agile, optimize high‑performance ETL applications, write advanced SQL against Oracle RDBMS, and

Qualifications

• Extensive hands-on Ab Initio ETL development experience.
• Strong SQL skills and Oracle RDBMS experience.
• UNIX environments and shell scripting proficiency.
• Experience with Jira and Agile methodologies.
• Proven track record across full SDLC processes.
• Excellent analytical and communication skills.

Responsibilities

• Design, develop, and optimize complex ETL applications using Ab Initio to meet business requirements.
• Collaborate with business users, analysts, and tech teams to understand needs and estimate effort.
• Lead SDLC activities in an Agile environment, including testing and UAT support.
• Apply SQL and Oracle knowledge to analyze data issues and ensure data integrity.
• Create automated utilities to improve system performance and efficiency.
• Own resolution of technical issues and manage bug tracking in Jira.

Skills

Ab Initio ETL

SQL

UNIX

Jira

SDLC

Agile

Oracle

Education

Bachelor's degree or equivalent

Master’s degree preferred

Tools

Ab Initio toolkit

Job description

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

Are you a senior data engineering expert ready to make an impact at a global financial institution? Bring your deep expertise in Ab Initio and ETL development to Citi's Oracle Ledger Data Engineering team, where you’ll design and build critical data solutions at the heart of our financial systems. The team is responsible for engineering and maintaining the critical data pipelines that feed into Citi's Oracle General Ledger system, ensuring the accuracy and integrity of the firm’s financial data.

As a senior engineer on this team, you will collaborate daily with business users, financial analysts, and cross‑functional technology partners to understand complex requirements and deliver robust, high‑performance data solutions. This role offers the opportunity to build and support essential ETL processes, innovate by designing automated utilities, and provide best‑in‑class solutions that directly impact Finance Technology operations. If you are a technical leader passionate about solving complex data challenges in a dynamic financial environment, this team is the right place for you.

What You’ll Do

• Design, develop, and optimize complex, high‑performance ETL applications using the full Ab Initio tool kit (GDE, Control Centre, Metadata Hub) to meet business and functional requirements.
• Collaborate closely with business users, financial analysts, and cross‑functional technology teams to understand requirements, provide effort estimates, and ensure timely delivery of solutions.
• Drive all phases of the software development lifecycle (SDLC) within an Agile methodology, including preparing handover documents, performing unit/SIT testing, and supporting UAT and production implementations.
• Utilize your SQL and RDBMS knowledge to investigate and analyze complex data issues, ensuring the integrity and reliability of financial data within the Oracle ledger.
• Innovate and improve processes by designing and creating automated utilities that enhance system performance and efficiency.
• Take ownership of technical issues by monitoring processes, resolving testing defects, and managing bug tracking in Jira.

Qualifications

• Software development experience in a banking or financial technology environment.
• Extensive, hands‑on experience developing complex ETL applications using the Ab Initio tool kit (GDE, Control Centre, Metadata Hub, etc.).
• Deep expertise in RDBMS (preferably Oracle) and the ability to write advanced SQL to analyze and resolve complex data issues.
• Strong proficiency in UNIX environments and shell scripting.
• Proven experience across the full SDLC and deep familiarity with Agile methodologies and tools such as Jira.
• Exceptional analytical and problem‑solving skills, with the ability to take ownership, manage risks, and drive tasks to completion.
• Excellent communication and collaboration skills, with the ability to work effectively with business users and cross‑functional teams.

Education

• Bachelor’s degree or equivalent experience.
• Master’s degree preferred.

What We Can Offer You

By joining Citi Belfast, you will benefit from a business‑casual workplace with a hybrid working model (up to two days working at home per week), a competitive base salary (annually reviewed), and a host of additional benefits such as:

• Generous holiday allowance starting at 27 days plus bank holidays; increasing with tenure.
• Discretionary annual performance‑related bonus.
• Private medical insurance packages.
• Employee Assistance Program.
• Pension plan.
• Paid parental leave.
• Special discounts for employees, family, and friends.
• Access to an array of learning and development resources.

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, please contact Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.