JobRushJobRush
Sign inCreate account
All jobs

Data Engineer ETL Developer - Assistant Vice President

Citigroup•2h ago
United StatesOnsite$97K–$145.4KFull-timeMid Level5+ yrs exp
H-1B sponsor
Apply now

Top focus

Etl DeveloperData EngineerVp DataData Analyst

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

  • maintain high-performance, resilient
  • 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
  • regulations related to data handling, adhering to Policy, applying sound ethical judgment
  • 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
  • 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 ------------------------------------------------------ Citi is an equal opportunity employer
  • 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
  • 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.

Required skills

Ab InitioSQLUnixLinuxdata warehousingdata modelingETLdata integrationdata analysisdata profilingdata qualityshell scriptingOracleTeradatajob scheduling
Posted on JobRush — the end-to-end AI job-search platform.