Citigroup, Inc

Data Engineer ETL Developer - Assistant Vice President

Citigroup, Inc$96K — $145K *
Finance & Insurance
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5-8 years of relevant experience in data systems analysis and ETL development.
  • Proven 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 and shell scripting.
  • Demonstrated success in managing data-centered projects, preferably in financial services.
  • Strong understanding of data warehousing and ETL best practices.
  • Experience with large-scale data transformations and loading data into financial systems like Oracle Financials or SAP.

Responsibilities

  • Design and develop high-performance ETL processes using Ab Initio to format upstream data for Oracle Financials SaaS.
  • Conduct data analysis and quality assessments to ensure data integrity.
  • Translate business requirements into technical specifications for ETL jobs.
  • Develop and optimize SQL queries for data extraction and loading across databases.
  • Manage metadata within the Ab Initio Enterprise Meta>Environment for version control.
  • Create Unix/Linux shell scripts for job automation and data manipulation.
  • Monitor all phases of the development process from design to implementation.
  • Provide operational support for production applications and troubleshoot issues.

Benefits

  • Medical, dental and vision coverage.
  • 401(k) retirement plan.
  • Life, accident, and disability insurance.
  • Wellness programs for employees.
  • Paid time off, including vacation and sick leave.
Full Job Description
The Data Engineer ETL Developer is an intermediate-level position responsible for the design, development, and implementation of robust and scalable data integration solutions. The successful candidate will be a key member of the Oracle Ledger program, a critical initiative focused on transforming upstream data into the CIT template for loading into Oracle Financials SaaS. This role is a core part of the Technology team, focusing on building and maintaining the firm's critical data pipelines using the Ab Initio platform. The overall objective is to contribute to high-quality data systems analysis and programming activities that support our strategic financial data objectives.

Responsibilities:
  • Design, develop, and maintain high-performance, resilient, and scalable ETL processes using the Ab Initio suite of products (GDE, Co>Operating System, EME) to transform upstream data into the required format for Oracle Financials SaaS.
  • Conduct detailed data analysis, data profiling, and data quality assessments to ensure the integrity of data moving through the Strategic Ledger pipelines.
  • Translate business requirements from the Strategic Ledger program into technical specifications for ETL jobs and data models.
  • Develop and optimize complex SQL queries for data extraction, transformation, and loading across various database platforms.
  • Create and manage metadata within the Ab Initio Enterprise Meta>Environment (EME), ensuring proper version control and adherence to development standards for the program.
  • Develop Unix/Linux shell scripts for job automation, scheduling, and file manipulation related to the data transformation process.
  • Monitor and control all phases of the development process, including analysis, design, construction, testing, and implementation.
  • Provide operational support for production applications, troubleshoot issues, and perform performance tuning to meet business SLAs.
  • Utilize in-depth specialty knowledge of ETL and Ab Initio to analyze complex data-related problems and recommend efficient solutions.
  • Collaborate with data architects, business analysts, and other technology groups to ensure solutions are aligned with enterprise standards and business needs.
  • Ensure essential procedures are followed and help define operating standards and processes for the ETL framework.
  • Serve as an advisor or coach to new or lower-level analysts, sharing expertise in Ab Initio and data integration best practices.
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients, and assets. This includes driving compliance with applicable laws, rules, and regulations related to data handling, adhering to Policy, applying sound ethical judgment, and escalating, managing, and reporting control issues with transparency.


Qualifications:
  • Hands-on experience in data systems analysis and ETL development.
  • Proven, in-depth expertise with the Ab Initio platform (GDE, Co>Operating System, EME) is mandatory.
  • Strong proficiency in SQL and experience with relational databases (e.g., Oracle, Teradata).
  • Solid experience with Unix/Linux environments and shell scripting.
  • Demonstrated experience in managing and implementing successful data-centric projects, preferably within the financial services industry.
  • Strong understanding of data warehousing concepts, data modeling, and ETL best practices.
  • Experience with large-scale data transformation projects and loading data into financial systems (e.g., Oracle Financials, SAP) is highly desirable.
  • Ability to work under pressure, manage deadlines, and adapt to unexpected changes in requirements.
  • Excellent problem-solving and analytical skills.
  • Experience with job scheduling tools (e.g., Autosys) is a plus.
  • Working knowledge of consulting/project management techniques/methods is beneficial.


Recommended Qualifications:
  • 5-8 years of relevant experience
  • Experience in systems analysis and programming of software applications
  • Experience in managing and implementing successful projects
  • Working knowledge of consulting/project management techniques/methods
  • Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements


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:
Jun 22, 2026

About Citigroup, Inc

Citigroup is a financial services holding company that provides financial products and services. The company operates through two segments, Global Consumer Banking (GCB) and Institutional Clients Group (ICG). The GCB segment offers traditional banking services to retail customers through retail banking, commercial banking, Citi-branded cards, and Citi retail services. The ICG segment offers various banking, and financial products and services to corporate, institutional, public sector, and high-net-worth clients. This segment provides wholesale banking products and services, including fixed-income and equity sales and trading, foreign exchange, prime brokerage, derivative services, equity and fixed-income research, corporate lending, investment banking, and advisory services, private banking, cash management, trade finance, and securities services. Citi is committed to sustainability and social responsibility, and the company invests in initiatives that promote economic progress.

Citigroup, Inc Careers

Join the vibrant team at Citigroup, Inc, a leading global bank, and propel your career into the future. Citigroup offers a plethora of job opportunities that span across various fields and expertise, making it an ideal place for ambitious professionals to thrive.

Work You’ll Do

At Citigroup, Inc, you will engage in exciting work that matters. Join our team to help innovate and drive transformation in the banking industry. With Citigroup, you can lead initiatives that redefine how banking works and how financial services can empower people globally.

Innovate and Lead

Citigroup, Inc is at the forefront of financial innovation and leadership. By joining our team, you will work alongside top professionals to develop solutions that enhance customer experiences and operational efficiency. Our commitment to innovation is fundamental, and we encourage our team to push boundaries and think outside the box.

Grow Your Career

Citigroup, Inc is not just a company; it's a place where you can grow both professionally and personally. We offer robust career paths and professional development opportunities that help you reach your potential. With diverse career tracks and the support of leadership, your growth at Citigroup is limitless.

Diversity and Inclusion

We believe our strength comes from the diversity of our team. Citigroup, Inc is dedicated to fostering an inclusive workplace where everyone can contribute their best work. Through diversity training and a culture that embraces differences, we create a welcoming environment for all employees.

Benefits and Culture

Citigroup, Inc values the well-being of its employees. We offer competitive benefits packages that support the health, finance, and lifestyle of our team members. Our culture is built on collaboration, respect, and a commitment to excellence. We ensure that every team member feels valued and part of our global family.

Internship and Employment Opportunities

Start your professional journey with Citigroup through our internship programs or full-time job opportunities. We are constantly hiring fresh talent and seasoned experts who bring creativity and innovation to our team. Whether you're refining your skills or ready to lead, there's a position waiting for you at Citigroup.

Networking and Professional Development

At Citigroup, Inc, networking and continuous learning are part of our DNA. We provide platforms for employees to connect with industry leaders and peers, enhancing their skills and opening up new career opportunities. Our leadership programs and professional development initiatives ensure that you are always ahead of the curve.

Join Our Team

Explore the numerous positions available at Citigroup, Inc that match your skills and interests. We are looking for passionate, curious, and solution-driven team players who are ready to make an impact.

Stay Connected

Keep up to date with the latest in career opportunities and industry insights at Citigroup, Inc. Subscribe to our job alert emails and read our careers blog to stay ahead in your professional journey.

Explore Citigroup, Inc Jobs

Discover the exciting and rewarding opportunities that await at Citigroup, Inc. Tailor your resume, prepare for your interview, and take the next step in your career with us.

SEARCH CITIGROUP JOBS

READ CAREERS BLOG

Citigroup, Inc is where your ambition meets opportunity. Join us and transform your career while making a global impact.
Learn more about Citigroup, Inc
Market Cap
$1.3 billion
Industry
Net Income
$89.6 million
Founded
1812
5 Year Trend
+4.6%
NASDAQ

Similar Jobs

More Jobs at Citigroup, Inc

More Finance & Insurance Jobs

Find similar Data Engineer ETL Developer - Assistant Vice President jobs: