Citi is a world-leading global bank. We have approximately 200 million customer accounts and a presence in more than 160 countries and jurisdictions worldwide. We provide consumers, corporations, governments, and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. We enable clients to achieve their strategic financial objectives by providing them with cutting-edge ideas, best-in-class products and solutions, and unparalleled access to capital and liquidity.
Citi Belfast is one of the largest employers in Northern Ireland with a diverse and talented team of over 3000 people from over 40 different nationalities across our four Belfast offices.
We are the only global investment bank operating in Northern Ireland. Every day, our local experts interact with global teams in over 100 countries developing and supporting next-generation technology solutions for the enterprise and delivering critical services to the bank and its customers, to make sure we are a stronger and safer organization for our clients.
You will have a truly global reach, which will provide you with new experiences and development opportunities right here in Belfast's iconic Titanic Quarter.
The Senior ETL Engineer position will be responsible for migrating the existing complex ETL scripts and back-office feeds to a more efficient and simpler ETL layer by utilizing new ETD data models. The candidate is expected to have sound knowledge and experience across multiple data handling technologies, database, and ETL processes.
Analyze the existing ETL scripts and evaluate requirements against the new ETD data models for trades, positions, collateral, margin & balances.
Partner with global teams and lead the simplification of existing ETL codebase by utilizing the new ETL data models.
Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.
Relevant experience in the design and development of Ab Initio based ETL solutions
Advanced design & architecture skills in data warehousing
Advanced SQL & No-SQL skills
Experience with AI Metadata Hub is a Plus
Experience in managing and implementing successful projects
Ability to adjust priorities quickly as circumstances dictate
Demonstrated leadership and project management skills
Consistently demonstrates clear and concise written and verbal communication
Bachelor's degree/University degree or equivalent experience
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
What we Offer:
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.
We'll provide you with the resources to meet your unique needs, empower you to make healthy decisions, and allow you to choose which benefits suit you and your personal life best.
Visit our Global Benefits page to learn more.
Highlights to our core benefits include:
Award winning pension
On-site health services
Private medical insurance packages to suit your personal circumstances
Paid parental leave
Generous holiday allowance starting at 27 Days plus bank holidays; increasing with tenure
Citi Belfast also champions diversity within our workforce, which helps us be well and live well together. We have over 40 different nationalities in our Northern Ireland offices, are a vocal supporter of LGBTQ+ rights, and are proud to have 47% of our leadership team made up of individuals who identify as women.
We encourage and lead inclusivity through our Pride, Disability, Multicultural, Families Matter, and Women affinity networks that are run by and for, Citi Belfast colleagues; providing them with the support they need in their personal and professional journeys and supplying them with the tools to help educate colleagues on all things related to each network to help us work better together.
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.