Data Engineering Lead (Ab Initio), Vice President

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

Benefits offered by this job

Generous holiday allowance starting at

Discretional annual bonus

Private medical insurance

Employee Assistance Program

Pension Plan

Parental Leave

Discounts for employees

Learning and development resources

Job summary

Citi Belfast is seeking a senior data engineer to lead design, development, and optimization of high-performance ETL solutions using the Ab Initio toolkit. You will collaborate with business users and finance teams to deliver robust data pipelines feeding Citi's Oracle General Ledger system.

The role requires deep SQL/RDBMS expertise, UNIX shell scripting, and strong SDLC/Agile experience. A hybrid work model is available with opportunities to innovate and own critical data processes.

Qualifications

• Software development experience in Banking/Financial Tech environment.
• Hands-on experience developing complex ETL with Ab Initio toolkit (GDE/Control Centre/Metadata Hub).
• Deep expertise in RDBMS (Oracle) and ability to write advanced SQL.
• Strong proficiency in UNIX environments and shell scripting.
• Experience across SDLC and Agile methodologies; familiarity with Jira.
• Analytical and problem-solving skills; ability to own tasks and manage risks.
• Excellent communication and collaboration with business users and cross-functional teams.

Responsibilities

• Design, develop, and optimize complex ETL apps using Ab Initio toolkit to meet requirements.
• Collaborate with business users, financial analysts, and tech teams to understand requirements and ensure timely delivery.
• Drive all phases of SDLC within Agile; prepare handover docs, perform testing, support UAT/production implementations.
• Utilize SQL and RDBMS knowledge to analyze data issues and ensure data integrity in Oracle ledger.
• Innovate by creating automated utilities to enhance performance and efficiency.
• Own technical issues by monitoring processes, resolving defects, and tracking bugs in Jira.

Skills

ETL development

Ab Initio

SQL

RDBMS

UNIX

Shell scripting

SDLC

Agile

Jira

Communication

Collaboration

Analytical thinking

Education

Bachelor's degree

Master's degree preferred

Tools

GDE

Control Centre

Metadata Hub

Oracle Ledger Systems

Jira

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.

Join the Oracle Ledger Data Engineering team, a cornerstone of Citi's Finance Technology division. Our 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 be at the intersection of finance and technology. 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 unique opportunity to not only build and support essential ETL processes but also to innovate by designing automated utilities and providing 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.

This role offers a unique opportunity to become a subject matter expert in the key area of ledger processing in global finance technology. You will have the chance to solve complex data engineering challenges that have a direct and visible impact on Citi's core financial operations. By collaborating closely with business leaders and cross-functional teams, you will not only enhance your technical skills with a best-in-class ETL tool but also build an in-depth knowledge of financial services. Every day will bring new business challenges that will help you develop the skills and experience to drive your career forward as a technical leader within a global organisation.

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.

What We’ll Need From You

• 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 analyse and resolve complex data issues.
• Strong proficiency in UNIX environments and shell scripting.
• Proven experience across the full Software Development Lifecycle (SDLC) and deep familiarity with Agile methodologies and tools like 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/University degree or equivalent experience
• Master's degree preferred

What We Can Offer You

We work hard to have a positive financial and social impact on the communities we serve. In turn, we put our employees first and provide the best‑in‑class benefits they need to be well, live well and save well.

By joining Citi Belfast, you will not only be part of a business casual workplace with a hybrid working model (up to 2 days working at home per week), but also receive a competitive base salary (which is annually reviewed), and enjoy a whole host of additional benefits such as:

• Generous holiday allowance starting at 27 days plus bank holidays; increasing with tenure
• A discretional annual performance related bonus
• Private medical insurance packages to suit your personal circumstances
• Employee Assistance Program
• Pension Plan
• Paid Parental LeaveSpecial discounts for employees, family, and friends
• Access to an array of learning and development resources

Alongside these benefits Citi is committed to ensuring our workplace is where everyone feels comfortable coming to work as their whole self every day. We want the best talent around the world to be energized to join us, motivated to stay, and empowered to thrive.

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.