ETL Developer

Talantir; New York (NY); Vor Ort; USD 83.000 - 138.000; Vollzeit

Zusammenfassung

Talantir seeks an ETL Developer in New York to build and optimize data pipelines and APIs for geospatial and non-geospatial data. You will work with Oracle, SQL Server and PostgreSQL, applying SSIS/SSRS/SSAS and cloud data services to deliver reliable analytics-ready datasets.

You will design data models, implement tests, and collaborate with GIS analysts and developers to meet business requirements and standards.

Qualifikationen

• Bachelor's degree in a relevant field; master's preferred.
• Minimum 4 years in ETL/Data engineering with geographic data focus.
• Proficient in T‑SQL/PL‑SQL with MS SQL Server, Oracle, PostgreSQL.
• Experience with SSRS/SSAS/SSIS and data warehousing concepts.
• Strong SQL and data modeling, plus Python or C# for ETL/API work.
• Experience with cloud data services and DevOps practices.

Aufgaben

• Design, develop, test and maintain ETL pipelines for large datasets.
• Extract data from Oracle, SQL Server; ensure quality and integrity.
• Create APIs and data models for analytics and integration.
• Build reporting solutions using SSRS and data warehouses.
• Optimize database performance and ensure data security.
• Collaborate with GIS analysts and developers on data requirements.
• Document data flows, models and API specs for knowledge sharing.
• Mentor team members on database tasks and best practices.

Kenntnisse

ETL development

Python

C#

API development

SQL proficiency

Data modeling

GIS data handling

Collaboration

Ausbildung

Bachelor in CS/IS/Geospatial

Master's degree a plus

Tools

SSIS

SSRS

SSAS

Oracle

SQL Server

PostgreSQL

Azure DevOps

GitHub

GIS tools (ArcGIS, QGIS)

Jobbeschreibung

Job Description – ETL DeveloperLocation: New York, NYJob Type: Contract

Responsibilities

• Extract geographic and non-geographic data from Oracle and SQL Server databases, ensuring theintegrity and quality of the data.
• Transform raw data into structured formats suitable for analysis, reporting, and system integration.
• Design and implement data pipelines for efficient handling of large datasets.
• Automate ETL integrations using SQL Server Integration Services (SSIS).
• Perform data analysis to drive key business objectives.
• Document ETL processes, data models, and API specifications for transparency and knowledge sharing.
• Develop, test, and maintain ETL workflows and scripts to automate data processing.
• Monitor ETL processes to ensure reliability, scalability, and performance.
• Perform data modeling and database design for application development and product implementationinitiatives under the guidance of Database Administrator and Architect.
• Create reporting solutions using SQL Server Reporting Services (SSRS) by analyzing user needs andinformation availability.
• Troubleshoot and resolve data-related issues promptly.
• Create APIs to enable data access and integration with various applications and systems.
• Ensure APIs are secure, performant, and adhere to industry standards.
• Collaborate with developers and analysts to design API endpoints that meet business requirements.
• Work with GIS analysts, developers, and stakeholders to understand data requirements.
• Participate in requirements definition, analysis and design.
• Work closely with business analysts, subject matter experts and development teams in design,development, testing, implementation, and support of application projects.
• Facilitate creation, migration and maintenance of database objects across development/ QA/production environments.
• Follow best practices in data modeling including use of standard naming conventions, processes andtemplates to ensure consistency of data models.
• Monitor and optimise database performance and capacity utilization to provide high availability and redundancy.
• Take ownership of database performance, scalability and security.
• Define and implement data testing strategies with business stakeholders, application development teams and QA groups.
• Participate in the software testing process, including identification and resolution of defects.
• Contribute to and support roll‑out strategies.
• Participate in and contribute to formal/informal technical reviews and presentations.
• Accurately estimate time required to complete development tasks.
• Demonstrate the ability to cooperate with a variety of people and achieve results.
• Mentor and guide development team members on database‑related tasks.
• Provide technical support and knowledge transition to team members and end users as needed.
• Communicate effectively with team members, stakeholders, and project managers to gatherrequirements, provide updates, and manage expectations.
• Create and maintain technical documentation, including system designs, workflows, and user guides.
• Ensure solutions comply with industry best practices,standards, and security protocols.
• Prepare documentation and conduct knowledge transition to support adoption across the organizationand other city agencies.
• Stay current with industry trends and emerging technologies to propose innovative solutions andimprove development processes.

Required Qualifications, Skills, And Experience

• Bachelor's degree in Computer Science, Software Engineering, Information Systems, GeographicInformation Systems (GIS), or a related field.
• Master's degree is a plus.
• Minimum of 4 years as ETL Developer, Data Engineer, or similar role, with a focus on geographicdata.
• Proficiency in T‑SQL and PL/SQL with experience working with Microsoft SQL Server, Oracle, andPostgreSQL databases.
• Familiarity with SSRS, SSAS, SSIS and data warehousing concepts like ETL, Dimensions, Facts, Cubes.
• Demonstrated knowledge of designing, developing and integrating databases, data warehousesand multidimensional databases in MS‑SQL Server.
• Knowledge of data integration patterns, database design, and data modeling principles.
• Strong programming skills in Python, C#, or other relevant languages for ETL and API development.
• Experience with API frameworks (e.g., Flask, FastAPI, or Django REST Framework).
• Experience with geographic data formats (e.g., shapefiles, GeoJSON) and geospatial tools (e.g., ArcGIS,QGIS).
• Experience with cloud platforms (e.g., AWS, Azure, GCP) and related data services.
• Familiarity with ETL tools like Talend, Apache Nifi, or Informatica.
• Ability to write and optimize complex SQL queries, stored procedures, triggers, and functions.
• Experience in code migration, database change management and data management through thevarious stages of the development life cycle.
• Familiarity with application lifecycle management (ALM) tools such as Azure DevOps and GitHub.
• Experience with version control and release management practices.
• Excellent problem-solving, collaboration, and communication skills.
• Experience with MS‑SQL Server, PostgreSQL, Oracle, and/or other geospatial databases.
• Ability to collaborate effectively within a team environment.
• Strong knowledge of software architecture principles, design patterns, and best practices.
• Familiarity with DevOps practices and tools for continuous integration and delivery.
• Familiarity with application lifecycle management (ALM) tools such as Azure DevOps and GitHubextensions.
• Experience with version control using Git and GitHub and release management practices.
• Excellent problem-solving skills and ability to work effectively in a collaborative team environment.
• Strong communication skills, both written and verbal.
• ETL certifications on Microsoft SQL Server or Oracle will be a plus.
• Demonstrated experience working with technical and non-technical staff.

Desirable Skills / Experience

• The selected candidate must have excellent verbal and written communication skills and have the ability to interact professionally with a diverse group including executives, managers, and subjectmatter experts.
• The candidate should be a team player