At a Glance
- Tasks: Design and optimise high-performance ETL applications using Ab Initio for financial data solutions.
- Company: Join Citi's innovative Finance Technology team in Belfast.
- Benefits: Enjoy 27 days holiday, private medical insurance, and a competitive salary.
- Other info: Hybrid working model with a focus on employee well-being and development.
- Why this job: Make a real impact on global finance technology while enhancing your technical skills.
- Qualifications: Experience in ETL applications, SQL, and Agile methodologies required.
The predicted salary is between 80000 - 100000 £ per year.
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.
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 analyze 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.
- A Bachelor’s degree/University degree or equivalent practical experience.
What we can offer 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.
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 discretionary 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
Equal Opportunity Employer: 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.
Data Engineering Lead (Ab Initio), Vice President in Dundonald employer: Citi
Citi Belfast is an exceptional employer that prioritises employee well-being and professional growth, offering a dynamic work environment with a hybrid model that promotes work-life balance. With generous benefits including a competitive salary, extensive holiday allowance, and comprehensive medical insurance, employees are supported in both their personal and professional lives. Joining our team means engaging in meaningful projects that directly impact global finance technology while collaborating with talented professionals in a business casual setting.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineering Lead (Ab Initio), Vice President in Dundonald
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Citi!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineering Lead (Ab Initio), Vice President at Citi.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Citi.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineering Lead (Ab Initio), Vice President at Citi, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineering Lead (Ab Initio), Vice President in Dundonald
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Citi, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Citi. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Citi
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Citi!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.