Job Title: ETL Developer

Location: New York City, NY
Duration: 18 Months

Job Description

An experienced ETL Developer is needed to support a large-scale data integration and modernization initiative involving the Linear Integrated Ordered Network Redesign project. The consultant will design, develop, and implement ETL processes across heterogeneous database platforms (SQL Server, Oracle, PostgreSQL), both on-premise and in cloud environments. The role includes building APIs and data pipelines to support data accessibility, as well as working closely with cross-functional and geospatial teams to ensure data integrity, consistency, and availability.

Project Scope & Responsibilities

ETL & Data Engineering

• Extract geographic and non-geographic data from Oracle and SQL Server databases while ensuring high data quality.

• Transform raw data into structured formats suitable for analysis, reporting, and system integration.

• Design and implement data pipelines for efficient processing of large datasets.

• Automate ETL workflows using SSIS and other automation tools.

• Develop, test, and maintain ETL processes and scripts for data processing and integration.

• Monitor ETL jobs for reliability, scalability, and performance.

• Perform data modeling and database design under guidance from senior database architects.

• Conduct data analysis to support business objectives and geospatial applications.

API & Integration Development

• Create APIs to enable secure and performant data access across applications.

• Ensure API interfaces meet industry standards and align with business requirements.

• Collaborate with developers/analysts to define API endpoints and integration workflows.

Reporting & Analytics

• Develop reporting solutions using SSRS based on user needs.

• Create and maintain database objects across development, QA, and production environments.

• Follow best practices in data modeling naming standards, documentation, templates, etc.

• Monitor and optimize database performance, ensuring security, scalability, and high availability.

Collaboration & Project Support

• Work closely with GIS analysts, developers, business analysts, and subject matter experts.

• Support all SDLC phases including requirements, design, development, testing, implementation, and post-production support.

• Participate in code reviews, technical discussions, and presentations.

• Accurately estimate task timelines and deliver work in a timely manner.

• Troubleshoot complex data-related issues and support release strategies.

• Contribute to application testing processes and assist in defect resolution.

Documentation & Knowledge Transfer

• Create and maintain technical documentation system designs, workflows, user guides, ETL specs.

• Prepare knowledge-transfer materials for end users and internal technical teams.

• Ensure solutions comply with industry standards, data governance, and security protocols.

• Stay current with emerging technologies and recommend improvements for processes and tools.

• Mentor team members on database, ETL, and data pipeline best practices.

Required Qualifications

Candidates without the required minimum qualifications will not be considered.

Education

• Bachelor s degree in Computer Science, Software Engineering, Information Systems, GIS, or related field.

• Master s degree is a plus.

Experience

• Minimum 4+ years as an ETL Developer, Data Engineer, or similar technical role.

• Experience working with geographic datasets and GIS-based applications.

• Proficiency with SQL Server, Oracle, and PostgreSQL.

• Experience with ETL, data warehousing, and multidimensional databases (Dimensions, Facts, Cubes).

• Strong T-SQL, PL/SQL, and SQL optimization skills.

• Hands-on experience with SSRS, SSAS, SSIS.

• Working knowledge of ETL tools such as Talend, Apache NiFi, or Informatica.

• Experience with cloud platforms (AWS, Azure, Google Cloud Platform).

• Strong programming experience in Python, C#, or similar languages for ETL/API development.

• Experience with API frameworks (Flask, FastAPI, Django REST).

• Familiarity with geospatial technologies (shapefiles, GeoJSON, ArcGIS, QGIS).

• Strong understanding of data modeling, database design, and integration patterns.

• Experience with Git, GitHub, and ALM tools (Azure DevOps).

• Knowledge of DevOps principles and CI/CD practices.

• Excellent written and verbal communication skills.

Preferred Qualifications

• ETL certifications on Microsoft SQL Server or Oracle.

• Experience working collaboratively with both technical and non-technical teams.

• Knowledge of software architecture, design patterns, and best practices.