Python and Database Developer, Assistant Vice President

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