ITnova is seeking a Cloud Architecture Team Lead to support the Port Authority of New York and New Jersey (PANYNJ) Aviation Department's Aviation Data Analytics Warehouse (ADAW). The ideal candidate will have strong experience designing and leading cloud-based data architectures using Microsoft Azure, including Synapse Analytics, Data Factory, Azure SQL, and Databricks. This role will lead platform architecture and strategy, oversee data integration solutions, establish security and access controls, and ensure the platform remains scalable, secure, and reliable. The position also includes Agile project and portfolio management, business requirements coordination, budget and resource oversight, program governance, and platform performance monitoring. Experience with enterprise data warehouses, data governance, and technical team leadership is highly desirable.
Responsibilities
- Define and lead the cloud data architecture and technology strategy for the Aviation Data Analytics Warehouse (ADAW), establishing standards for scalability, resilience, and performance.
- Design and oversee a scalable, secure, resilient, and high-performing cloud-based data warehouse platform.
- Establish standards for data ingestion, transformation, storage, lakehouse architecture, and data retention.
- Oversee multiple data integration projects and ongoing enhancement requests using Agile project management practices and Azure DevOps.
- Translate business requirements into actionable tasks for the data engineering team, track progress, analyze outcomes, and communicate project status, risks, and milestones.
- Coordinate with the PA Program Manager to develop and manage annual budgets, monitor staff hours and performance, and prepare weekly and monthly status reports and invoices.
- Establish and implement data engineering, data governance, and stakeholder engagement frameworks for the ADAW program.
- Support continuous improvement of DABI's engineering standards, internal documentation, business logic, and process transparency.
- Lead the integration of data from APIs, batch feeds, streaming sources, and SFTP file transfers.
- Establish API management strategies and secure, reliable data transfer standards and best practices.
- Implement security architecture, including identity and access management (IAM), role-based access controls, and key management.
- Provide technical leadership and guidance to the data engineering team.
- Ensure the platform architecture supports evolving data integration, analytics, and business intelligence requirements.
- Design and oversee workflows to monitor and troubleshoot Power BI Premium Capacity usage and Azure Synapse performance, including CPU utilization, job scheduling, failed pipeline runs, and compute scaling needs.
- Identify opportunities to improve platform performance, optimize cloud resource usage, and manage costs.
Required Qualifications
- Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field preferred.
- Demonstrated experience designing and implementing cloud-based data architectures.
- Experience with Microsoft Azure cloud services and data platform development.
- Experience with Microsoft Azure Synapse Analytics, Azure Data Factory, Azure SQL, Databricks, and Azure DevOps.
- Experience with relational databases, including Microsoft SQL Server.
- Experience with data integration methods, including APIs, batch processing, streaming data, and SFTP file transfers.
- Knowledge of data warehouse architecture, data ingestion, transformation, storage, and lakehouse design.
- Experience implementing cloud security, identity and access management, and role-based access controls.
- Ability to lead technical initiatives and establish architecture standards and best practices.
- Experience coordinating technical projects, tracking deliverables, managing priorities, and communicating project status, risks, and milestones.
- Strong analytical, problem-solving, communication, and documentation skills.
- Experience with budget planning, contract management, staff-hour tracking, invoicing, and program financial reporting.
Preferred Experience
- Experience architecting enterprise-scale cloud data warehouses or lakehouse platforms.
- Experience supporting business intelligence and analytics environments using Microsoft Power BI, including Premium Capacity monitoring and performance optimization.
- Experience monitoring and troubleshooting Azure Synapse performance, pipeline failures, job scheduling, and compute scaling.
- Experience with cloud data governance, data retention, and security compliance practices.
- Experience leading technical teams in an Agile development environment.
- Experience supporting complex data integrations across multiple business units or enterprise systems.
- Experience managing multiple projects, enhancement requests, and technical delivery portfolios.
Must be US Citizen or current green card holder
Full-time remote ( Mon – Fri, 9:00 am – 5:00 pm EST)
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
ITnova is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.