Note: The job is a remote job and is open to candidates in USA. ITnova is seeking a Data Engineer to support the Port Authority of New York and New Jersey’s Aviation Department and its Aviation Data Analytics Warehouse. The role develops and maintains data pipelines and ELT workflows, integrates and transforms data using Azure services, optimizes databases, and builds Power BI semantic models for reporting and analytics.
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
Skills
- 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
Benefits
- Full-time remote (Mon - Fri, 9:00 am - 5:00 pm EST)
- 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
Company Overview
Company H1B Sponsorship