Product Control Tech ETL Developer, AVP

Citigroup Inc.; Belfast; Hybrid; GBP 50,000 - 90,000; Full time

Job summary

An established industry player is seeking an ETL Developer to join their dynamic FX Exposure Management Tech team. This role offers the chance to work on critical data processing solutions, ensuring high-quality software delivery while collaborating with cross-functional teams. You'll leverage your expertise in ETL development using AB Initio, SQL, and big data technologies to drive impactful projects. With a hybrid working model and a commitment to employee well-being, this position promises a rewarding career path in a supportive environment. If you're ready to tackle new challenges and grow your skills, this opportunity is perfect for you.

Benefits

Generous holiday allowance starting at 27 days

Discretional annual performance-related bonus

Private medical insurance

Employee Assistance Program

Pension Plan

Paid Parental Leave

Special discounts for employees

Access to learning and development resources

Qualifications

• Experience in ETL development using AB Initio in Financial/Investment banking.
• Strong knowledge of ETL processes and data modelling concepts.
• Hands-on experience with big data technologies is a plus.

Responsibilities

• Understand business requirements and produce technical design documents.
• Collaborate with cross-functional teams and perform unit testing.
• Write efficient, maintainable code and mentor junior developers.

Skills

ETL Development

AB Initio

Data Warehousing

SQL

NoSQL

Shell Scripting

Unix/Linux

Performance Tuning

Problem-Solving

Communication Skills

Tools

MongoDB

Hadoop

Spark

Hive

Jenkins

Docker

Kubernetes

Job description

Are you looking for a career move that will put you at the heart of a global financial institution? Then bring your skills in ETL-Abinitio design, development and data processing solutions in Citi’s FX Exposure management tech team.

By Joining Citi, you will become part of a global organisation whose mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress.

Team/Role Overview

This role is part of Global FX Exposure Management Tech team which supports various deliveries, including regulatory and data quality controls related deliverables for FX exposure reporting process. The application is primarily used by Market Controllers users globally in the firm responsible for identification, allocation and hedging of FX Risk.

The ETL Developer role we are recruiting will be responsible working closely with the business and SMEs on the Backend service development work slate, provide estimate efforts, ensure timely delivery on committed items and to provide solutions and deliverables as part of software development as according to the Software Development Lifecycle (SDLC).

What you’ll do

• Understanding Business Requirements and Functional Requirements provided by Business Analysts and working as part of the development team to produce Technical Design Documents and deliver solutions on those requirements.
• Work closely with Cross Functional Teams e.g. Business Analysis, Product Assurance, Platforms and Infrastructure, Business Office, Controls and Production Support. Prepare handover documents, perform unit testing, SIT and assist with UAT and Production Implementation as required.
• Identify and proactively resolve issues that could impact system performance, reliability, and usability.
• Write efficient, maintainable, and reusable code following best practices.
• Perform code reviews, debugging, and unit testing to ensure high-quality software delivery.
• Collaborate with DevOps teams to implement CI/CD pipelines using Jenkins, Docker, and Kubernetes.
• Optimize application performance and ensure security best practices are followed.
• Mentor junior developers and participate in agile development processes (Scrum/Kanban).

What we’ll need from you

• Experience in ETL development using AB Initio preferably in Financial/Investment banking domain.
• Strong knowledge of ETL processes, data warehousing, and data modelling concepts.
• Hands-on experience with AB Initio GDE, EME, Co>Operating System, Conduct>It.
• Work with databases (SQL & NoSQL) such as MongoDB, etc.
• Experience working with big data technologies (Hadoop, Spark, Hive) is a plus.
• Strong knowledge of shell scripting and Unix/Linux environments.
• Experience with performance tuning and optimization of ETL jobs.
• Excellent problem-solving, analytical, and communication skills.

What we can offer you

This is a role that'll offer you the opportunity to build an in-depth knowledge of FX Exposure management process in a fast-growing global team. Every day there will be new business challenges that will help you develop new skills that can drive your career.

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 Leave
• Special 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.

Sounds like Citi has everything you need? Then apply to discover the true extent of your capabilities.

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. 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 the "EEO is the Law" poster. View the EEO is the Law Supplement.

View the EEO Policy Statement.

View the Pay Transparency Posting