Apply on Employer Site

Citi · 6 hours ago

Python and Database Developer, Assistant Vice President

New York, NY

Full-time

Onsite

Mid, Senior Level

$121K/yr - $182K/yr

6+ years exp

Citi is seeking a skilled and motivated Python and Database Developer to join their dynamic technology team. The role involves designing, developing, and maintaining efficient and scalable applications, focusing on data processing pipelines and database integrations.

BankingFinanceFinancial Services

H1B Sponsor Likely

Responsibilities

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

Qualification

PythonSQLData EngineeringDatabase SystemsData VisualizationAPI DevelopmentSQLAlchemyData WarehousingDevOps PracticesAgile MethodologiesLeadership & MentorshipSoftware Engineering PrinciplesCommunication Skills

Required

6+ years of hands-on experience in a Data Engineering role

Experience with data visualization tools and techniques for presenting data insights effectively

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

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

Solid understanding of data warehousing concepts and experience working with large datasets, including data modeling and ETL processes

Ability to guide and mentor junior developers, fostering a collaborative team environment and promoting professional growth

Strong communication skills, both written and verbal, with the ability to explain complex technical concepts to both technical and non-technical audiences

Experience working in a Continuous Integration and Continuous Delivery environment and familiarity with tools like Jenkins, TeamCity, SonarQube, OpenShift, ECS, or Kubernetes

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

Preferred

Experience with workflow management tools like Airflow (experience with PySpark or PyFlink is a major plus)

Benefits

Medical, dental & vision coverage

401(k)

Life, accident, and disability insurance

Wellness programs

Paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays

Company

Citi

Glassdoor3.8

Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress.

Founded in 1812

San Antonio, Texas, USA

10001+ employees

https://www.citi.com

H1B Sponsorship

Citi has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (1386)

2024 (849)

2023 (1375)

2022 (1117)

2021 (876)

2020 (901)