Python ETL Engineer - Assistant Vice President

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.

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