FULL_TIME
5-10
Python and Database Developer, Assistant Vice President
1/13/2026
The role involves designing and developing data pipelines for data ingestion, transformation, and loading into data warehouses/lakes. Additionally, it includes optimizing data models for performance and ensuring data quality and governance.
Working Hours
40 hours/week
Company Size
10,001+ employees
Language
English
Visa Sponsorship
No
About The Company
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.
About the Role
Data Engineering Leadership: Participate in design and development of data pipelines for ingestion, transformation, and loading of data from various sources (databases, APIs, streaming platforms) into our data warehouse/lake, ensuring seamless data flow and accessibility. Develop data models that support business requirements and analytical needs. Optimize data models for query performance and data accessibility. Database Optimization: Write optimized and maintainable SQL queries and leverage SQLAlchemy for efficient database interaction, ensuring high performance and data accuracy. Data Quality Assurance: Implement robust data quality checks and monitoring systems to ensure data integrity and accuracy, proactively identifying and resolving data issues. Data Governance Contribution: Contribute to the design and implementation of data governance policies and procedures, ensuring compliance with regulatory requirements and internal standards. Technology Innovation: Continuously research and implement new technologies and best practices to improve the efficiency, scalability, and resilience of our data platform. Cloud Deployment & Monitoring: Take ownership of the deployment and monitoring of data pipelines and related infrastructure on cloud platforms such as OpenShift, ECS, or Kubernetes, ensuring optimal performance and reliability. Operational Excellence: Ability to occasionally work a non-standard shift, including nights and/or weekends, and/or have on-call responsibilities to support critical data operations. Experience: 6+ years of hands-on experience in a Data Engineering role Data Visualization: Experience with data visualization tools and techniques for presenting data insights effectively. Agile Methodologies: Familiarity with agile development methodologies and experience working in agile teams. Strong proficiency in Python (version 3.6+), with experience in Python packaging and shared libraries like Pandas and NumPy. API Development: Experience implementing REST APIs in Python using microframeworks like Flask. Extensive experience working with relational databases, writing complex SQL, and optimizing queries for performance. Proven expertise with SQLAlchemy or similar ORM libraries for efficient database interaction. Experience with workflow management tools like Airflow (experience with PySpark or PyFlink is a major plus). Data Warehousing Knowledge: Solid understanding of data warehousing concepts and experience working with large datasets, including data modeling and ETL processes. Leadership & Mentorship: Ability to guide and mentor junior developers, fostering a collaborative team environment and promoting professional growth. Communication Skills: Strong communication skills, both written and verbal, with the ability to explain complex technical concepts to both technical and non-technical audiences. DevOps Practices: Experience working in a Continuous Integration and Continuous Delivery environment and familiarity with tools like Jenkins, TeamCity, SonarQube, OpenShift, ECS, or Kubernetes. Software Engineering Principles: Proficient in industry-standard best practices such as Design Patterns, Coding Standards, Coding modularity, and Prototyping. Design, develop, and maintain database schemas and models. Write and optimize SQL queries for data retrieval, manipulation, and reporting. Communicate technical concepts and solutions effectively to both technical and non-technical audiences. Provide technical support and troubleshooting for production systems. Stay up-to-date with the latest trends and technologies in Python development, database systems, and data engineering. Evaluate and recommend new tools and technologies to improve development efficiency and product quality. Contribute to the continuous improvement of development processes and practices. Bachelor's degree in Computer Science, Software Engineering, or a related field. ------------------------------------------------------ For complementary skills, please see above and/or contact the recruiter. ------------------------------------------------------ Anticipated Posting Close Date: Jan 19, 2026 ------------------------------------------------------
Key Skills
PythonSQLData EngineeringData ModelingData Quality AssuranceData GovernanceCloud DeploymentDatabase OptimizationAPI DevelopmentData WarehousingAgile MethodologiesDevOps PracticesData VisualizationLeadershipCommunication SkillsSoftware Engineering Principles
Categories
TechnologyData & AnalyticsSoftwareEngineeringManagement & Leadership
Apply Now
Please let Citi know you found this job on InterviewPal. This helps us grow!
Prepare for Your Interview
We scan and aggregate real interview questions reported by candidates across thousands of companies. This role already has a tailored question set waiting for you.
Elevate your application
Generate a resume, cover letter, or prepare with our AI mock interviewer tailored to this job's requirements.