Data Engineer / Developer

Job Title: Data Engineer / Developer

Industry: Aviation Industry
Department: Analytics and Data Warehouse (ADAW)
Location: Fully Remote
Job Type: Contract
Pay Rate: $45/hour
Duration: Approximately 4 years
Work Schedule: Monday–Friday, 9:00 AM–5:00 PM ET

Job Description

We are seeking experienced Data Engineers / Developers to support the Port Authority of New York & New Jersey's Aviation Department within its Analytics and Data Warehouse (ADAW) team.

The ideal candidates will have strong hands-on experience in data engineering, enterprise data integration, ETL/ELT development, and cloud-based data platforms, particularly within the Microsoft Azure ecosystem.

The role involves developing, maintaining, and optimizing data pipelines and enterprise data warehouse solutions that integrate data from multiple sources. Candidates should have strong SQL and data transformation skills, along with the ability to troubleshoot technical issues, ensure data quality, and support enterprise data operations.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Azure Data Factory and related Azure services.

• Build and manage data integration solutions using Azure Synapse Analytics and Azure SQL.

• Develop complex SQL queries, stored procedures, and data transformations using SQL/T-SQL.

• Integrate data from multiple enterprise systems and sources into centralized data warehouse platforms.

• Support enterprise data warehouse development, maintenance, and optimization.

• Perform data validation, troubleshooting, and quality assurance to ensure accuracy and consistency.

• Optimize data pipelines, SQL queries, and database performance.

• Collaborate with business, analytics, and technical teams to understand data requirements and deliver solutions.

• Support production data platforms and resolve data-related issues.

• Assist with deployment activities, documentation, and ongoing platform improvements.

Required Qualifications

• Hands-on experience in data engineering and enterprise data integration.

• Strong experience with Azure Data Factory, Azure Synapse Analytics, and Azure SQL.

• Advanced SQL/T-SQL skills and experience working with SQL Server.

• Experience developing and maintaining ETL/ELT pipelines and data transformation processes.

• Experience with enterprise data warehouses and integrating data from multiple sources.

• Strong troubleshooting, data quality, and performance optimization skills.

• Ability to work independently in a remote environment and collaborate with cross-functional teams.

Preferred Qualifications

• Experience with Azure Databricks, PySpark, and Python.

• Knowledge of Power BI datasets and analytical data models.

• Experience with Azure DevOps and CI/CD pipelines.

• Experience integrating data through REST APIs.

• Familiarity with Power Apps and Power Automate.

• Experience supporting enterprise production data platforms.

Work Schedule & Support Requirements

• Fully remote position, Monday through Friday, 9:00 AM–5:00 PM Eastern Time.

• Candidates must be available outside normal business hours for emergency situations and production support.

• Occasional extended hours may be required to support critical issues, production incidents, and project deadlines.