ETL Developer &ndash

Overview

On Site
Accepts corp to corp applications
Contract - W2
Contract - long term

Skills

QA
api
python
pl/sql
oracle
C#
REST
ETL
MS SQL Server
Informatica
Apache
database
Django
data modeling
Performance Tuning
Azure DevOps
documentation
data pipelines
Amazon Web Services
Database Modeling
GIS
Mentor
Problem-Solving
Self Motivated
Maintenance
GitHub
Team Player
T-SQL
Data Integration
GCP
Technical Support
Version Control
Microsoft SSRS
Performance Optimization
Datasets
Database Management
PostgreSQL
Microsoft SQL Server Integration Services
Arcgis
DCP

Job Details

Job Description

Position Title: ETL Developer Consultant Services
Client: New York City Department of City Planning (NYC DCP)
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:
  1. 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.
  2. 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.
  3. Database Management:
    • Perform data modeling, database design, and performance optimization.
    • Facilitate migration and maintenance of database objects across development, QA, and production environments.
  4. Collaboration:
    • Work closely with GIS analysts, developers, and business stakeholders to define requirements.
    • Partner with QA teams to develop and execute data testing strategies.
  5. 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, Google Cloud Platform).
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.