← Back to jobsJob ID col-cmv8nsdnt0gefoz01s7f0ex1l

ITNOVAPosted 30+ days ago

Data Engineer

Full-time
Remote
Mid level
Competitive
Posted 30+ days ago

ITnova is seeking a Data Engineer to support the Port Authority of New York and New Jersey Aviation Department’s Aviation Data Analytics Warehouse. The role develops and maintains data pipelines and ELT workflows, integrates Azure data services, and supports database development, pipeline optimization, and Power BI semantic modeling.

Posted
30+ Days Ago
Source
ziprecruiter.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Develop new and maintain existing data pipelines supporting the Aviation Data Analytics Warehouse (ADAW)
  • Configure automated data extraction processes and troubleshoot data ingestion failures and connectivity issues
  • Design, develop, and maintain Extract, Load, Transform (ELT) workflows
  • Clean, standardize, and transform data according to established data governance standards and business rules
  • Build reusable data transformation frameworks using Azure Synapse Analytics
  • Optimize data pipelines for performance, efficiency, and processing speed
  • Create and maintain database objects, including tables, views, and stored procedures
  • Support serverless and dedicated SQL pools and SQL Server databases
  • Design and maintain Power BI semantic data models to support reporting, dashboards, and analytical requirements
  • Integrate new data sources and enhance existing data processing workflows
  • Document data pipelines, transformations, database objects, and technical processes
  • Collaborate with the Cloud Architecture/Team Lead, Program Manager, and QA/QC Specialist to deliver reliable data solutions

Qualifications

  • Must be US Citizen
  • Demonstrated experience developing and maintaining data pipelines and data integration solutions
  • Experience with Microsoft Azure data services, including Synapse Analytics, Data Factory, Azure SQL, and Databricks
  • Experience with relational databases, including Microsoft SQL Server
  • Proficiency in SQL and experience developing database objects such as tables, views, and stored procedures
  • Experience designing and implementing ELT or ETL workflows
  • Experience with data transformation, data cleansing, and data quality practices
  • Experience with Microsoft Power BI and semantic data modeling
  • Experience using Azure DevOps or similar tools for development coordination, version control, and work tracking
  • Ability to troubleshoot data processing issues and document technical solutions

Preferred

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field preferred
  • Experience developing enterprise data warehouse or lakehouse solutions
  • Experience integrating data from APIs, batch feeds, streaming sources, and SFTP file transfers
  • Experience optimizing large-scale data pipelines and SQL queries
  • Experience with Power Apps and Power Automate
  • Experience supporting business intelligence dashboards and enterprise reporting
  • Experience working in an Agile development environmen
  • Bachelor's Degree

Required skills

Data PipelinesData IntegrationMicrosoft Azure Synapse AnalyticsAzure Data FactoryAzure SQLDatabricksSQLMicrosoft SQL ServerETL/ELT WorkflowsPower BI Semantic ModelingAzure DevOps

Full job description

ITnova is seeking a Data Engineer to support the Port Authority of New York and New Jersey Aviation Department’s Aviation Data Analytics Warehouse. The role develops and maintains data pipelines and ELT workflows, integrates Azure data services, and supports database development, pipeline optimization, and Power BI semantic modeling.

Responsibilities

  • Develop new and maintain existing data pipelines supporting the Aviation Data Analytics Warehouse (ADAW)
  • Configure automated data extraction processes and troubleshoot data ingestion failures and connectivity issues
  • Design, develop, and maintain Extract, Load, Transform (ELT) workflows
  • Clean, standardize, and transform data according to established data governance standards and business rules
  • Build reusable data transformation frameworks using Azure Synapse Analytics
  • Optimize data pipelines for performance, efficiency, and processing speed
  • Create and maintain database objects, including tables, views, and stored procedures
  • Support serverless and dedicated SQL pools and SQL Server databases
  • Design and maintain Power BI semantic data models to support reporting, dashboards, and analytical requirements
  • Integrate new data sources and enhance existing data processing workflows
  • Document data pipelines, transformations, database objects, and technical processes
  • Collaborate with the Cloud Architecture/Team Lead, Program Manager, and QA/QC Specialist to deliver reliable data solutions

Preferred

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field preferred
  • Experience developing enterprise data warehouse or lakehouse solutions
  • Experience integrating data from APIs, batch feeds, streaming sources, and SFTP file transfers
  • Experience optimizing large-scale data pipelines and SQL queries
  • Experience with Power Apps and Power Automate
  • Experience supporting business intelligence dashboards and enterprise reporting
  • Experience working in an Agile development environmen
  • Bachelor's Degree
  • Computer Science
  • Information Systems
  • Data Engineering
  • Enterprise Data Warehousing
  • Lakehouse Solutions
  • API Integration
  • Batch Data Integration
  • Streaming Data Integration
  • SFTP File Transfers
  • Data Pipeline Optimization
  • SQL Query Optimization
  • Power Apps
  • Power Automate
  • Business Intelligence Dashboards
  • Enterprise Reporting
  • Agile Development

Benefits

  • Medical, Dental, and Vision coverage
  • Short Term Disability, AD&D and Life insurance
  • 401(k) Program
  • Paid Time Off
  • 11 Paid Holidays
  • Employee Assistance Program
  • Full-time remote (Mon – Fri, 9:00 am – 5:00 pm EST)

Company

  • Microsoft-focused application consulting and development firm
  • Yeoksamdong, Seoul-t'ukpyolsi, KOR
  • http://www.itnova.co.kr/
  • Founded in 2022
  • 0-1 employees

Qualifications

  • Must be US Citizen
  • Demonstrated experience developing and maintaining data pipelines and data integration solutions
  • Experience with Microsoft Azure data services, including Synapse Analytics, Data Factory, Azure SQL, and Databricks
  • Experience with relational databases, including Microsoft SQL Server
  • Proficiency in SQL and experience developing database objects such as tables, views, and stored procedures
  • Experience designing and implementing ELT or ETL workflows
  • Experience with data transformation, data cleansing, and data quality practices
  • Experience with Microsoft Power BI and semantic data modeling
  • Experience using Azure DevOps or similar tools for development coordination, version control, and work tracking
  • Ability to troubleshoot data processing issues and document technical solutions
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field preferred
  • Experience developing enterprise data warehouse or lakehouse solutions
  • Experience integrating data from APIs, batch feeds, streaming sources, and SFTP file transfers
  • Experience optimizing large-scale data pipelines and SQL queries
  • Experience with Power Apps and Power Automate
  • Experience supporting business intelligence dashboards and enterprise reporting
  • Experience working in an Agile development environmen

Required skills

  • Data Pipelines, Data Integration, Microsoft Azure Synapse Analytics, Azure Data Factory, Azure SQL, Databricks, SQL, Microsoft SQL Server, ETL/ELT Workflows, Data Transformation and Data Quality, Power BI Semantic Modeling, Azure DevOps

Preferred skills

  • Experience with Power Apps and Power Automate, Experience working in an Agile development environmen

Experience

  • Mid level

Job details

Employment type

Full-time

Seniority level

Mid level

Date posted

Oct 9, 2026

Work mode

Remote

Job source

ziprecruiter.com

Company

ITNOVA

Information Technology & AI

Microsoft-focused application consulting and development firm

  • Remote, USA
  • Information Technology & AI
  • 0-1 employees
  • Founded 2022
  • itnova.co.kr

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleAzure Data FactoryRemote

Coinbase

1d ago

New

Senior Software Engineer, Data Engineering Platform

Full-timeRemoteUnited States$186K – $219K/yr

Coinbase is hiring a Senior Software Engineer for its Data Platform team. The role builds and maintains SDKs, self-service applications, reusable abstractions, and security and observability tooling that help internal teams create, manage, and use data…

Why similarSame roleData PipelinesRemote

Airbnb

1d ago

New

Data Engineer Tech Foundations

Full-timeRemoteUnited States$162K – $186K/yr

Airbnb is hiring a Data Engineer to build and operate reliable, reusable datasets and pipelines that support AI usage and cost measurement, Unit Economics, enterprise application data, and critical financial metrics.

Why similarSame roleData PipelinesRemote

Get new Data Engineer jobs by email

Create job alert

Data Engineer

ITNOVA · Competitive

Apply on company site