Data Engineer- ETL Developer - Assistant Vice President

Citigroup Inc.; Tampa (FL); Hybrid; USD 97,000 - 145,000; Full time

Benefits offered by this job

Hybrid work model (3 days in office, 2

Learning and development programs

Exposure to large-scale programs

Wellbeing and work-life balance

Job summary

Citi in Tampa, FL is seeking a mid‑level Data Engineer to design, build, and maintain scalable ETL pipelines using Ab Initio for the Oracle Ledger program. You will translate business requirements into precise technical specs and ensure data quality across Oracle Financials SaaS platforms.

With 4+ years of ETL and Ab Initio experience, you will optimize SQL queries, automate processes with Unix scripts, and provide production support.

Qualifications

• 4+ years in ETL development and data systems analysis with complex data projects.
• Expertise with Ab Initio (GDE/OS/EME) in production environments.
• Advanced SQL and experience with Oracle or Teradata.
• Proficiency with Unix/Linux and shell scripting for automation.

Responsibilities

• Design, build, and maintain high‑performance ETL pipelines using Ab Initio to transform upstream data for Oracle Financials SaaS.
• Conduct data analysis, profiling, and quality assessments to ensure data integrity.
• Translate business requirements into precise technical specifications for ETL jobs and data models.
• Develop and optimize complex SQL queries across multiple databases.
• Create and manage metadata in Ab Initio EME with version control and standards.
• Write Unix/Linux shell scripts for job scheduling and data transformation automation.
• Provide production support and performance tuning to meet service levels.
• Collaborate with data architects, analysts, and cross‑functional teams to align ETL solutions with business goals.

Skills

ETL development

Ab Initio (GDE/OS/EME)

SQL

Unix/Linux

Data warehousing

Data modeling

Multitask management

Education

Bachelor's degree or equivalent

Tools

Ab Initio Suite (GDE/OS/EME)

Autosys

Oracle/Teradata databases

Job description

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

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

Education:

• Bachelor’s degree/University degree or equivalent experience

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

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.

We are an 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. View Citi’s EEO Policy Statement and the Know Your Rights poster.