Data Engineer / Developer

The Port Authority of New York & New Jersey is seeking Data Engineers / Developers to support its Aviation Department’s Analytics and Data Warehouse team. The role develops, maintains, and optimizes data pipelines and enterprise data warehouse solutions, integrating data from multiple sources and supporting data quality and enterprise data operations.

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

Requirements:

• 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
• 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