Python ETL Engineer - Assistant Vice President

Citi; New York (NY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Citi is looking for a Python ETL Engineer - Assistant Vice President to join their Data and Analytics team in New York, NY. This role requires extensive experience designing, developing, and maintaining ETL processes and data pipelines. Candidates should have expertise in Python, PL/SQL, and data warehousing concepts. The position offers a hybrid work model, emphasizing a strong background in data technologies.

The ideal candidate will contribute significantly to applications systems analysis and programming, collaborating with various stakeholders to enhance data management solutions.

Qualifications

• 8+ years of relevant experience in data technologies.
• Experience in designing, developing, and maintaining ETL processes.
• Strong understanding of data warehousing concepts.

Responsibilities

• Design, develop, and maintain ETL processes for data extraction, transformation, and loading.
• Write complex SQL queries and PL/SQL scripts.
• Optimize performance and scalability of ETL processes and data pipelines.

Skills

Python

ETL

PL/SQL

SQL

Data Warehousing

Data Modeling

Database Management

Problem Solving

Communication

Teamwork

Education

Bachelor’s degree/University degree or equivalent experience

Job description

Python ETL Engineer - Assistant Vice President

Job Req Id: 26949476

Location(s): Pune, Maharashtra, India

Job Type: Hybrid

Posted: Apr. 01, 2026

Job Overview

The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.

Responsibilities

• Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establish and implement new or revised applications systems and programs to meet specific business needs or user areas
• Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users
• Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement
• Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality
• Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems
• Ensure essential procedures are followed and help define operating standards and processes
• Serve as advisor or coach to new or lower level analysts
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Acts as SME to senior stakeholders and/or other team members.
• 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.

Qualifications

• 8+ years of relevant experience
• Job Title: Python, ETL, AI Engineering and PL/SQL Developer
• Job Description: We are seeking a skilled and motivated Python, ETL, and PL/SQL Developer to join our Data and Analytics team. Candidate should have 8-12 years of industry experience on data technologies. The ideal candidate will be responsible for designing, developing, and maintaining ETL processes, data pipelines, and database solutions to support our growing data needs. This role requires a strong understanding of data warehousing concepts, experience with various ETL tools, and proficiency in Python, PL/SQL, and database technologies. Methodology of AI includes Chunking, Embedding, AI Engineering, Prompt Engineering.
• Responsibilities: Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our data warehouse. Write complex SQL queries and PL/SQL scripts to perform data manipulation, validation, and transformation. Develop and maintain data pipelines using Python and related libraries (e.g., Polar ,Pandas). Optimize ETL processes and data pipelines for performance and scalability. Collaborate with data analysts and other stakeholders to understand data requirements and develop solutions to meet their needs. Implement data quality checks and monitoring to ensure data accuracy and consistency. Troubleshoot and resolve data-related issues. Create and maintain technical documentation for ETL processes, data pipelines, and database solutions. Stay up-to-date with the latest trends and technologies in data management and analytics.
• Skills: Python, ETL, PL/SQL, SQL, Data Warehousing, Data Modeling, Database Management, Problem Solving, Communication, Teamwork.

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.

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.