Product Control Tech ETL Developer, AVP in Belfast

Product Control Tech ETL Developer, AVP in Belfast

Belfast Full-Time 60000 - 80000 £ / year (est.) Hybrid
Citi

At a Glance

  • Tasks: Join Citi's FX Exposure management team to develop ETL solutions and enhance data processing.
  • Company: Citi, a global financial institution focused on responsible growth and economic progress.
  • Benefits: Generous holiday allowance, competitive salary, private medical insurance, and hybrid working model.
  • Other info: Mentorship opportunities and a commitment to diversity and inclusion in the workplace.
  • Why this job: Make an impact in a fast-growing team while developing your skills in a dynamic environment.
  • Qualifications: Experience in ETL development, strong analytical skills, and knowledge of financial services.

The predicted salary is between 60000 - 80000 £ per year.

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

Product Control Tech ETL Developer, AVP in Belfast employer: Citi

Citi is an exceptional employer, offering a dynamic work environment that fosters innovation and collaboration within the Equities Technology team. Employees benefit from cutting-edge technology, opportunities for professional growth, and a culture that values diversity and inclusion. With a focus on high-performance analytics and real-time data solutions, Citi empowers its engineers to make impactful contributions while enjoying a supportive atmosphere in a globally recognized financial institution.

Citi

Contact Details:

Citi Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Product Control Tech ETL Developer, AVP in Belfast

✨Tap into Campus Networks

If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.

✨Get Certified

Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.

✨Connect on Professional Platforms

Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.

✨Apply Directly and Be Proactive

Don’t shy away from reaching out directly to firms like Citi. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.

We think you need these skills to ace Product Control Tech ETL Developer, AVP in Belfast

ETL Development
AB Initio
Data Warehousing
Data Modelling
SQL
NoSQL
MongoDB

Some tips for your application 🫡

Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.

Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Citi.

Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.

Research and Reflect:Before hitting that 'apply' button on Citi's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!

How to prepare for a job interview at Citi

✨Brush Up on Financial Analysis Skills

Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Citi.

✨Prepare for Case Studies

Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.

✨Show Your Passion for Finance

Since this is a full-time position, employers at Citi will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.

✨Network with Industry Professionals

Before your interview, reach out to current or former Citi employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.