The Applications Development Intermediate 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. Key Responsibilities • Design, develop, and maintain ETL pipelines to extract, transform, and load data from multiple sources into PostgreSQL and MongoDB. • Optimize data ingestion, storage, and retrieval for performance and scalability. • Develop RESTful APIs using FastAPI to serve data and integrate with internal/external systems. • Collaborate with cross-functional teams (data engineering, DevOps, product) to define requirements and deliver solutions. • Ensure data integrity, consistency, and security across the pipeline. • Write clean, maintainable, and well-documented code. • Monitor, debug, and optimize ETL workflows and APIs in production. • Stay updated with the latest trends in Python, ETL frameworks, and database technologies. Required Skills & Experience • 4+ years of professional experience in Python development. • Strong experience in building ETL pipelines and data integration workflows. • Proficiency in PostgreSQL (schema design, queries, performance tuning). • Hands-on experience with MongoDB (document design, aggregation pipelines, indexing). • Experience developing REST APIs using FastAPI (or Flask/Django REST Framework with willingness to switch to FastAPI). • Solid understanding of data modeling and database best practices. • Experience with asynchronous programming in Python. • Familiarity with Docker and deployment on cloud environments (AWS/Azure/GCP) is a plus. • Strong problem-solving and debugging skills. • Good communication skills and ability to work in a collaborative team environment 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 ------------------------------------------------------ **Most Relevant Skills** Please see the requirements listed above. ------------------------------------------------------ **Other Relevant Skills** For complementary skills, please see above and/or contact the recruiter. ------------------------------------------------------ _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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._ _View Citi’s_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf)_ _poster._ Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.