About this role
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. 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. Familiarity with Docker and deployment on cloud environments (AWS/Azure/GCP) is a plus. Good communication skills and ability to work in a collaborative team environment Bachelor's degree/University degree or equivalent experience ------------------------------------------------------ For complementary skills, please see above and/or contact the recruiter. ------------------------------------------------------
Other facts
About Citi
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have over 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
For information on Citi’s commitment to privacy, visit on.citi/privacy.
What you'll do
- Design, develop, and maintain ETL pipelines for data extraction, transformation, and loading. Collaborate with cross-functional teams to define requirements and ensure data integrity and security.
Ready to join Citi?
Take the next step in your career journey