Data Engineer- ETL Developer - Assistant Vice President

Reposted 26 Days Ago
2 Locations
In-Office
97K-145K Annually
Senior level
Fintech • Financial Services
The Role
Design, develop, and maintain scalable ETL pipelines using Ab Initio to transform upstream data for Oracle Financials SaaS. Perform data profiling, quality assessments, complex SQL development, Unix/Linux scripting, metadata management in EME, deployment support, performance tuning, and collaborate with architects and analysts. Provide operational support and mentor junior analysts while ensuring compliance and risk controls.
Summary Generated by Built In

Citi is looking for a skilled Data Engineer to join its Technology team and play a central role in the Oracle Ledger program — a high-impact initiative transforming upstream financial data into the Oracle Financials SaaS platform. In this mid-level role, you will design, build, and maintain enterprise-grade ETL pipelines using the Ab Initio platform, ensuring the accuracy and reliability of data that directly supports Citi's strategic financial operations. This is an opportunity to apply deep data engineering expertise on a complex, large-scale program where the quality of your work has direct and measurable business impact.

Responsibilities
  • Design, build, and maintain high-performance ETL pipelines using the Ab Initio suite — including GDE, Co>Operating System, and EME — to transform upstream data into the format required for Oracle Financials SaaS.
  • Conduct data analysis, data profiling, and data quality assessments to validate the integrity of data flowing through the Strategic Ledger pipelines.
  • Translate business requirements from the Strategic Ledger program into precise technical specifications for ETL jobs and data models.
  • Develop and optimize complex SQL queries to support data extraction, transformation, and loading across multiple database platforms.
  • Create and manage metadata within the Ab Initio Enterprise Meta>Environment (EME), maintaining version control and adherence to program development standards.
  • Write Unix/Linux shell scripts to automate job scheduling, file handling, and data transformation processes.
  • Provide production support for live data applications, diagnose and resolve issues quickly, and carry out performance tuning to meet agreed service levels.
  • Collaborate with data architects, business analysts, and cross-functional technology teams to ensure ETL solutions meet both technical standards and business objectives.
Required Qualifications & Skills
  • 3+ years of hands-on experience in ETL development and data systems analysis, with a background in delivering complex, data-centric projects.
  • Deep, proven expertise with the Ab Initio platform — including GDE, Co>Operating System, and EME — applied in a production environment.
  • Advanced SQL skills and practical experience with relational databases such as Oracle or Teradata.
  • Solid command of Unix/Linux environments, including the ability to write and maintain shell scripts for automation and scheduling.
  • Demonstrated ability to manage multiple workstreams, meet tight deadlines, and adapt when requirements shift.
  • Strong grounding in data warehousing principles, data modelling, and ETL best practices, with the ability to translate these into scalable, maintainable solutions.
  • Bachelor's degree in Engineering, Technology, or Computer Science or equivalent professional experience in a relevant technical discipline.
Beneficial Skills & Qualifications
  • Experience delivering large-scale data transformation programs that load data into financial systems such as Oracle Financials or SAP.
  • Background in financial services, providing familiarity with the data governance and regulatory requirements of the industry.
  • Familiarity with job scheduling tools such as Autosys.
  • Working knowledge of project management methodologies and the ability to contribute to structured delivery frameworks.
What We Offer

At Citi, you will work on technology that sits at the heart of global financial infrastructure, alongside talented engineers and data professionals who take ownership of their work and value high-quality outcomes. We offer a collaborative, performance-driven environment where your technical contributions are visible, valued, and directly connected to business impact.

  • Hybrid working model with 3 days in the office and 2 days working remotely, giving you flexibility without sacrificing team connection.
  • Access to structured learning and development programs to support your continued growth as a data engineering professional.
  • Exposure to large-scale, enterprise-grade programs that offer genuine technical challenge and career advancement.
  • Wellbeing support and work-life balance initiatives designed to help you perform at your best over the long term.
  • Competitive compensation and a comprehensive benefits package aligned to your experience and contribution.

Apply now to bring your Ab Initio and ETL expertise to one of the world's leading financial institutions and help shape the data infrastructure that powers Citi's strategic financial operations.

Education:

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

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

Job Family Group: Technology

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

Job Family:Applications Development

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

Time Type:Full time

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

Primary Location:Tampa Florida United States

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

Primary Location Full Time Salary Range:$96,960.00 - $145,440.00


In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.

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

Most Relevant Skills Please see the requirements listed above.

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

Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.

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

Anticipated Posting Close Date:

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

Automated Processing and AI

We use automated processing, including artificial intelligence, for our legitimate business interests (or our reasonable and appropriate business purposes) to identify and align the candidate's skills and abilities with a specific job opening. Additionally, if you so choose, or consent, we can match your skills and abilities to other suitable roles at Citi.


Importantly, all our hiring processes and decisions, including determining your suitability for a role, are conducted, checked, and decided by individuals. Our automated processing and AI do not involve relying on automatic or autonomous decision-making. Please refer to any Jurisdictional Considerations, with specific provisions for your country (where relevant) for further details.


Illinois residents – AI Notice and Right

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

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.

Skills Required

  • Hands-on experience in data systems analysis and ETL development.
  • Proven, in-depth expertise with the Ab Initio platform (GDE, Co>Operating System, EME).
  • Strong proficiency in SQL and experience with relational databases (Oracle, Teradata).
  • Solid experience with Unix/Linux environments and shell scripting.
  • Strong understanding of data warehousing concepts, data modeling, and ETL best practices.
  • Bachelor's degree or equivalent experience.
  • Demonstrated experience managing and implementing data-centric projects, preferably in financial services.
  • Experience with large-scale data transformation projects and loading into financial systems (e.g., Oracle Financials, SAP).
  • Experience with job scheduling tools (e.g., Autosys).
  • Working knowledge of consulting/project management techniques/methods.

Citi Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.

  • Healthcare Strength Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
  • Retirement Support Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
  • Wellbeing & Lifestyle Benefits Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.

Citi Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Kwun Tong, Kowloon
223,850 Employees

What We Do

Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.

Similar Jobs

Boeing Logo Boeing

First Line Systems Integration Manager

Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
In-Office
Hialeah, FL, USA
170000 Employees
99K-169K Annually

Boeing Logo Boeing

Procurement Agent Manager

Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
In-Office
Hialeah, FL, USA
170000 Employees
95K-135K Annually

MetLife Logo MetLife

Production Support Analyst - CRM & Workflow

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
85K-110K Annually

MetLife Logo MetLife

Product Management Associate - CRM

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
100K-130K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account