About the role
ITnova is seeking Data Engineer / Developers to support the Port Authority of New York and New Jersey’s Aviation Department. The role develops and maintains cloud-based data pipelines, ELT workflows, data warehouse solutions, Power BI models, data quality checks, and governed data entry applications for the Aviation Data Analytics Warehouse. Responsibilities Develop new and maintain existing data pipelines within ADAW, including configuring automated data extraction processes and troubleshooting ingestion failures and data source connectivity issuesDesign, build, and maintain Extract, Load, Transform (ELT) workflows, including standardizing and cleansing data according to PANYNJ data governance standards and business rulesDevelop reusable data transformation frameworks in Azure Synapse Analytics and optimize pipeline performance and data processingCreate, maintain, and manage database objects, including tables, views, and stored procedures, to support Azure Synapse serverless and dedic