Sqlalchemy Developer Jobs

1 job found

Today

Python and Database Developer, Assistant Vice President

Citi New York, NY

New York, NY

Today

$121k - $182k/yr Full time Backend Developer Python Apache Airflow

Apply Now

Job Description

The Python and Database Developer, Assistant Vice President at Citi contributes to building scalable data pipelines, web applications, and database integrations using Python and SQL/ORM technologies. The role emphasizes strong Python expertise, database proficiency, and experience with cloud deployment and data governance.

Location

New York, NY (hybrid)

Compensation

USD 121,200 - 181,800 per year

Responsibilities

Lead the design and development of data pipelines to ingest, transform, and load data from databases, APIs, and streaming sources into the data warehouse or data lake, ensuring reliable data flow and accessibility.
Develop data models that align with business requirements and analytical needs.
Optimize data models for fast query performance and straightforward data access.
Write efficient, maintainable SQL queries and leverage SQLAlchemy for database interaction to sustain high performance and data accuracy.
Implement robust data quality checks and monitoring to safeguard data integrity and proactively resolve issues.
Contribute to the design and implementation of data governance policies and procedures to meet regulatory and internal standards.
Pursue technology innovations to enhance the efficiency, scalability, and resilience of the data platform.
Own the deployment and monitoring of data pipelines and related infrastructure on cloud platforms such as OpenShift, ECS, or Kubernetes, ensuring reliability and performance.
Be prepared to work non-standard shifts, including nights or weekends, and/or provide on-call support for critical data operations.

Requirements

At least 6 years of hands-on experience in a data engineering role.
Experience with data visualization tools to present insights effectively.
Familiarity with agile methodologies and collaboration in agile teams.
Strong Python skills (3.6+) with experience in packaging and libraries such as Pandas and NumPy.
API development experience building REST APIs in Python using microframeworks like Flask.
Extensive experience with relational databases, including writing complex SQL and optimizing queries, plus proficiency with SQLAlchemy or a similar ORM.
Experience with workflow management tools such as Airflow; knowledge of PySpark or PyFlink is a major plus.
Solid understanding of data warehousing concepts, including data modeling and ETL processes for large datasets.
Ability to guide and mentor junior developers and foster a collaborative team environment.
Strong communication skills, both written and verbal, with the ability to explain technical concepts to diverse audiences.
DevOps practices and experience with CI/CD, along with familiarity with tools such as Jenkins, TeamCity, SonarQube, OpenShift, ECS, or Kubernetes.
Knowledge of software engineering principles, including design patterns, coding standards, modularity, and prototyping.
Bachelor's degree in a related field is required.

Technologies

Python
SQLAlchemy
Pandas
NumPy
Flask
OpenShift
ECS
Kubernetes
Airflow
PySpark
PyFlink
Jenkins
TeamCity
SonarQube

Benefits

Discretionary and formulaic incentive and retention awards
Medical, dental, and vision coverage
401(k) retirement plan
Life, accident, and disability insurance
Wellness programs
Paid time off including vacation, sick leave, and paid holidays

View full job page →

Get Job Alerts

New jobs delivered to your inbox.