Location: New York City, NY
Duration: 18 Months
A highly skilled ETL Developer is required to support a large-scale data modernization initiative focused on redesigning and integrating complex data systems. The consultant will design, develop, and maintain ETL processes across SQL Server, Oracle, and PostgreSQL environments (both on-premise and cloud), build APIs and data pipelines, and enable seamless data accessibility for geospatial and enterprise applications. The ideal candidate will ensure data integrity, performance, and reliability while collaborating with cross-functional teams to support business and technical objectives.
The consultant will:
Extract, transform, and load geographic and non-geographic data from Oracle and SQL Server databases.
Transform raw data into structured, analytics-ready formats.
Design and implement efficient, scalable data pipelines for large datasets.
Automate integrations using SSIS.
Develop, test, and maintain ETL workflows and scripts for automated data processing.
Monitor ETL performance to ensure reliability and scalability.
Troubleshoot and resolve complex data issues quickly.
Perform data modeling and database design under guidance of DBAs/Architects.
Support creation, migration, and maintenance of database objects across environments.
Create reporting solutions using SSRS based on user requirements.
Apply best practices for naming conventions, templates, and modeling standards.
Optimize database performance, capacity, and security.
Develop secure, performant APIs to enable data access and system integration.
Collaborate with developers and analysts to design API endpoints aligned with business needs.
Ensure APIs follow modern development standards and security practices.
Work closely with GIS analysts, developers, and stakeholders to understand data and business requirements.
Participate in requirements definition, analysis, design, testing, and implementation activities.
Contribute to software testing—including defect identification and resolution.
Create and maintain documentation including system design, data workflows, and user guides.
Support knowledge transfer, training, and technical guidance for team members.
Provide accurate time estimates and collaborate effectively across diverse teams.
Conduct reviews, contribute to solution design discussions, and support deployment planning.
Ensure industry best practices, security standards, and governance protocols are followed.
Stay current with industry trends, new technologies, and modern ETL/ELT tooling.
Recommend improvements to development processes and data workflows.
Candidates without the required skills will not be considered.
Bachelor’s degree in Computer Science, Information Systems, GIS, or a related field (Master’s preferred).
Minimum 4 years of experience as an ETL Developer, Data Engineer, or similar role.
Strong experience with geographic data and geospatial workflows.
Proficiency with T-SQL, PL/SQL, and hands-on experience with SQL Server, Oracle, and PostgreSQL.
Experience with SSIS, SSRS, SSAS, and data warehousing concepts (ETL, dimensions, facts, cubes).
Experience designing and integrating databases, data warehouses, and multidimensional data structures in SQL Server.
Strong programming skills in Python, C#, or similar languages for ETL and API development.
Experience with API frameworks such as Flask, FastAPI, or Django REST Framework.
Experience with shapefiles, GeoJSON, and geospatial tools (ArcGIS, QGIS).
Experience with cloud platforms (AWS, Azure, or GCP) and related data services.
Familiarity with ETL tools (Talend, Apache NiFi, Informatica).
Ability to write and optimize complex queries, stored procedures, triggers, and functions.
Experience with database change management and version-controlled deployments.
Hands-on experience with Azure DevOps, GitHub, and CI/CD pipelines.
Strong understanding of software architecture, design patterns, and best practices.
Excellent communication, collaboration, and problem-solving skills.
Proven ability to work effectively with both technical and non-technical staff.
ETL certifications (Microsoft SQL Server or Oracle) are a plus.
Excellent verbal and written communication skills.
Ability to work professionally with executives, managers, SMEs, and cross-functional teams.
Strong team player with a collaborative approach.