Python/SQL Server Developer

at SoHo Dragon
Published May 20, 2023
Location New York, NY
Category Default  
Job Type Full-time  

Description

SoHo Dragon represents an investment bank with offices in New York, NY that needs to hire a Python/SQL Server Developer.DutiesMigrate existing SSIS ETL scripts to Python; develop new ETL scriptsSupport existing SSIS SQL ProjectsMaintain ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQLWrite SQL queries against Snowflake.Understanding data pipelines and modern ways of automating data pipeline using cloud-basedWork closely with existing senior integration staff to flush out design, priority and build.Scaffolding and framework will be needed for staging and transforming datasets.Use existing DevOps pipeline for Python and enhance if necessary.Automate Python scripts on our enterrprise scheduler.Strong troubleshooting skills to identify root cause and resolve production issuesSkills5 years of full-time development experience using PythonExperience building data piplines using Azure Data Factory and DatabricksExperience with Python application frameworks (Django, Flask, Pyramid, Tornado)Experience with Python testing and code analysis tools (Pytest, Pylint)Strong SQL skillsFamilarity with SSISStrong troubleshooting skillsOn-point communication skillsEducation *Bachelors degree in Computer Science or Finance