Python and SQL Developer

Ztek Consulting, Inc.; New York (NY); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Ztek Consulting, Inc. in New York, NY is seeking an experienced Python/SQL developer to design, build, and maintain scalable applications and data integrations. You will work on REST APIs, ETL processes, and performance optimization within a hybrid work setup.

The role requires strong Python, SQL, and cloud experience along with collaboration across teams. Ideal candidates have 8+ years of Python and SQL experience, are familiar with frameworks such as Flask, FastAPI, Django, and have a good

Qualifications

• 8+ years of Python application development and SQL programming.
• 5+ years of experience with relational databases (SQL Server, Oracle, PostgreSQL, MySQL).
• 3+ years of experience developing REST APIs and data integration solutions.
• Strong SQL optimization, database design, and performance tuning skills.
• Experience with Python frameworks: Flask, FastAPI, Django; Pandas.
• Experience with Git, CI/CD, and Agile/Scrum methodologies.

Responsibilities

• Design, develop, and maintain scalable applications, APIs, and automation solutions using Python.
• Develop, optimize, and troubleshoot complex SQL queries and database objects.
• Build and support ETL/data integration processes for enterprise analytics.
• Collaborate with business users and teams to gather requirements and deliver solutions.
• Monitor performance and perform tuning for apps and databases.

Skills

Python development

SQL programming

REST APIs

Git

CI/CD

Agile/Scrum

Data troubleshooting

Education

Bachelor's degree in Computer Science or related field

Tools

Flask

FastAPI

Django

Pandas

Azure/AWS/Google Cloud

Job description

• Design, develop, and maintain scalable applications, APIs, and automation solutions using Python.
• Develop, optimize, and troubleshoot complex SQL queries, stored procedures, views, and database objects.
• Build and support ETL/data integration processes for enterprise applications and analytics platforms.
• Collaborate with business users, architects, and development teams to gather requirements and deliver solutions.
• Monitor application and database performance and implement performance tuning improvements.
• Perform code reviews, unit testing, debugging, and production support activities.
• Develop integrations with internal and external systems using REST APIs and data services.
• Mentor junior developers and contribute to Agile ceremonies and technical documentation.

Basic Qualifications:

• Minimum 8+ years of experience in Python application development and SQL programming.
• Minimum 5+ years of experience working with relational databases such as SQL Server, Oracle, PostgreSQL, or MySQL.
• Minimum 3+ years of experience developing REST APIs, data integration solutions, and automation frameworks.
• Strong expertise in SQL query optimization, database design, indexing, and performance tuning.
• Experience with Python frameworks/libraries such as Flask, Fast API, Django, Pandas, or equivalent.
• Experience with Git, CI/CD pipelines, and Agile/Scrum methodologies.
• Strong analytical, troubleshooting, and communication skills.

Location: New York, Hybrid mode

Degree: Bachelor’s degree in computer science, Information Technology, Engineering, or equivalent work experience.

Nice to Have (But not a must):

• Experience with Azure, AWS, or Google Cloud.
• Exposure to Docker, Kubernetes, and containerized deployments.
• Experience with data warehousing, ETL platforms, or big data technologies.
• Technical leadership or project lead experience.

Relevant Python, SQL, or Cloud certifications.