ETL Developer

Position Title: ETL Developer – Consultant Services
Project: Geosupport Linear Integrated Ordered Network (LION) ETL Redesign
Location: 120 Broadway, 30th Floor, New York, NY 10271
Type: Full-time, Onsite

About the Role:

The NYC Department of City Planning (NYC DCP) seeks an experienced ETL Developer to redesign and enhance its Geosupport Linear Integrated Ordered Network (LION) ETL processes. The role involves working with geographic and non-geographic data across Oracle, SQL Server, and PostgreSQL databases, creating APIs and data pipelines to improve integration, accessibility, and scalability for geospatial applications. The ideal candidate will collaborate with cross-functional teams to ensure reliable, high-quality data solutions.

This is an in-office role requiring physical presence at the NYC DCP location.

Key Responsibilities:

• ETL Processes:
• Extract, transform, and load (ETL) geographic and non-geographic data from Oracle, SQL Server, and PostgreSQL databases.
• Automate ETL integrations using SQL Server Integration Services (SSIS).
• Design and optimize workflows for handling large datasets.
• API Development:
• Create secure and performant APIs using frameworks such as Flask, FastAPI, or Django REST.
• Enable seamless data integration with various applications and systems.
• Database Management:
• Perform data modeling, database design, and performance optimization.
• Facilitate migration and maintenance of database objects across development, QA, and production environments.
• Collaboration:
• Work closely with GIS analysts, developers, and business stakeholders to define requirements.
• Partner with QA teams to develop and execute data testing strategies.
• Documentation and Support:
• Maintain comprehensive documentation for ETL processes, APIs, and data models.
• Mentor team members and provide technical support as needed.

Required Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, GIS, or a related field.
• 5 years of experience as an ETL Developer or Data Engineer, with a focus on geographic data.
• Proficiency in T-SQL and PL/SQL, with experience in SQL Server, Oracle, and PostgreSQL.
• Hands-on experience with SSIS, SSRS, and ETL tools (e.g., Talend, Apache Nifi, Informatica).
• Strong programming skills in Python, C#, or similar languages for ETL and API development.
• Familiarity with geospatial data formats (e.g., shapefiles, GeoJSON) and GIS tools (e.g., ArcGIS, QGIS).
• Knowledge of data integration patterns, data modeling, and database design principles.
• Experience with cloud platforms (e.g., AWS, Azure, GCP).

Preferred Qualifications:

• ETL certifications in Microsoft SQL Server or Oracle.
• Familiarity with Azure DevOps, GitHub, or similar ALM tools.
• Understanding of database performance tuning, scalability, and version control practices.

Skills and Competencies:

• Excellent problem-solving, collaboration, and communication skills.
• Ability to manage time effectively and meet deadlines.
• A team player with a proactive attitude and attention to detail.

Job Types: Full-time, Contract

Pay: $75.00 - $90.00 per hour

Schedule:

• 8 hour shift

Experience:

• ETL: 7 years (Required)
• T-SQL and PL/SQL: 5 years (Required)
• SSIS, SSRS: 4 years (Required)
• Python and C#: 4 years (Required)
• Azure Devops: 3 years (Required)

Ability to Commute:

• New York, NY 10271 (Required)

Work Location: In person

Salary : $75 - $90