Business Data Analyst - Aviation & Infrastructure (New York / New Jersey, Full-Time)

McKnight International; United States; Hybrid; USD 100,000 - 125,000; Full time

Benefits offered by this job

Medical, dental, vision benefits

401(k) with employer matching

PTO & holidays

Professional development support

Job summary

McKnight International is seeking a Business Data Analyst to support aviation & infrastructure projects in the New York and New Jersey area. The role requires 3–5 years of analytics experience, Power BI expertise, and strong SQL and Excel skills.

You will develop dashboards, monitor KPIs, and deliver data-driven insights for project teams. The position is hybrid (4–5 days on-site) with on-site collaboration 4–5 days per week and occasional travel to project locations.

Qualifications

• 3–5 years of professional experience in data analytics, BI, or related field.
• Proven ability to design dashboards and data visualizations.
• Strong Excel skills and data modeling experience.

Responsibilities

• Collect, consolidate, and analyze data from multiple project sources.
• Develop and maintain Power BI dashboards and performance reports.
• Translate data into actionable insights for project leaders and stakeholders.

Skills

Power BI

SQL

Excel

Data Visualization

Education

Bachelor's degree in Data Analytics or related field

Tools

Power BI

SQL

Job description

Business Data Analyst - Aviation & Infrastructure (New York / New Jersey, Full-Time)

Jamaica, United States | Posted on 11/04/2026

McKnight International is a leading project controls and technology implementation company known for its commitment to delivering high-quality projects on time and within budget. We take pride in our dedication to safety, quality, and excellence in the construction industry. As we continue to grow, we seek skilled individuals to join our team and contribute to the success of our projects.

Job Description

Business Data Analyst - Aviation & Infrastructure (New York / New Jersey, Full-Time)

Employment Type: Full-Time

Work Arrangement: Hybrid (4–5 Days On-Site Per Week)

Note: We kindly ask not to be contacted at this time by recruiters or third-party agencies.

Our Company

At McKnight International, we specialize in providing innovative project controls and infrastructure technology consulting services to architects, engineers, and construction firms. Our work spans aviation, transportation, capital improvement programs, civil infrastructure, commercial development, and infrastructure technology initiatives.

We focus on integrating qualified personnel and effective systems to deliver precision, visibility, and successful project outcomes. Our organization is committed to fostering innovation, collaboration, and operational excellence while supporting complex infrastructure and consulting environments.

To learn more about McKnight International, please visit mcknightintl.com. For additional career opportunities, visit mcknightintl.com/careers.

The Role

McKnight International is seeking a Business Data Analyst - Aviation & Infrastructure with 3–5 years of professional experience in data analytics, business intelligence, performance reporting, or a related analytical field.

The ideal candidate will collect, analyze, interpret, and present data to support aviation infrastructure projects, capital improvement programs, operational initiatives, and project management activities.

This position requires hands‑on experience with Microsoft Power BI, SQL, advanced Excel, data modeling, and dashboard development. The successful candidate will develop and monitor key performance indicators (KPIs), analyze project performance, and translate complex datasets into actionable insights that support management decision‑making.

The individual hired will collaborate with project managers, project controls professionals, engineering teams, operations personnel, technology departments, finance teams, and other stakeholders to support accurate reporting and data‑driven project and program management. Projects may involve capital improvements, facility planning, asset management, technology and innovation, sustainability, safety, customer experience, and other aviation initiatives.

Experience supporting data analytics and reporting within aviation, transportation, infrastructure, construction, or capital improvement environments is preferred.

This position requires on‑site availability 4–5 days per week, with potential assignments at multiple project locations throughout the New York and New Jersey metropolitan area.

Requirements

Business Data Analytics Scope

• Collect, organize, analyze, and interpret project and program data to support operational and management decision‑making.
• Design, develop, and maintain interactive Power BI dashboards, visualizations, and performance reports.
• Develop, track, monitor, and analyze KPIs across assigned projects and programs.
• Support reporting of project schedules, budgets, milestones, deliverables, risks, and overall performance.
• Identify trends, variances, performance gaps, and opportunities for improvement.
• Prepare executive summaries, project status reports, dashboards, presentations, and management briefings.
• Collaborate with project managers and stakeholders to identify reporting requirements and develop analytical solutions.
• Support project controls, capital planning, asset management, and operational performance initiatives.
• Maintain accurate reporting documentation, datasets, and performance records.
• Support data quality assurance, reporting consistency, and continuous improvement.

Essential Job Functions

Data Analysis, Business Intelligence & Reporting

• Collect, consolidate, and analyze data from multiple project, operational, and business information sources.
• Develop analytical reports and dashboards to monitor project and program performance.
• Transform complex datasets into accurate, actionable information for project teams and leadership.
• Identify trends, patterns, variances, and performance concerns through quantitative analysis.
• Prepare recurring and ad hoc reports for assigned projects and programs.
• Gather business requirements and recommend improvements to analytical and reporting processes.

Power BI Dashboard Development & Data Visualization

• Design, develop, maintain, and enhance interactive dashboards and reports using Microsoft Power BI.
• Build data models and establish relationships between datasets.
• Use Power Query and DAX to transform data, develop calculations, and create performance measures.
• Integrate information from spreadsheets, databases, and other available project data sources.
• Develop visualizations to communicate project performance, operational trends, and KPIs.
• Maintain dashboards, troubleshoot reporting discrepancies, and improve data accuracy and performance.

Project Controls & Performance Monitoring

• Support monitoring and analysis of project scope, schedules, budgets, milestones, and deliverables.
• Develop project performance dashboards, milestone trackers, and management reports.
• Analyze schedule and budget performance data to identify trends, variances, and potential risks.
• Collaborate with project controls professionals to support performance monitoring and forecasting.
• Consolidate information across multiple projects and workstreams for program‑level reporting.
• Support corrective action tracking, performance improvement, and management reporting.

KPI Development, Monitoring & Program Analytics

• Develop, track, analyze, and report KPIs for aviation projects, programs, and initiatives.
• Support performance reporting related to capital improvements, asset management, sustainability, technology, customer experience, and safety.
• Collaborate with stakeholders to establish reporting metrics and performance measures.
• Analyze KPI results to identify emerging issues, performance trends, and opportunities for improvement.
• Prepare performance summaries, dashboards, and management‑level reports.
• Maintain consistent KPI definitions, reporting methodologies, and supporting documentation.

Data Management, Quality Assurance & Process Improvement

• Collect and consolidate information from multiple project teams and reporting systems.
• Review datasets and reports for accuracy, completeness, consistency, and reliability.
• Identify and resolve data discrepancies, missing information, and reporting inconsistencies.
• Coordinate with stakeholders to validate source data and reporting requirements.
• Develop standardized reporting templates, dashboards, and analytical processes.
• Support improvements to data collection, reporting workflows, and information management practices.

Stakeholder Collaboration & Business Requirements

• Collaborate with project managers, engineering, operations, technology, finance, and other departments.
• Gather and document business requirements, reporting needs, and performance monitoring objectives.
• Translate stakeholder requirements into dashboards, analytical reports, and practical reporting solutions.
• Participate in project meetings, reporting reviews, and stakeholder discussions.
• Communicate analytical findings and performance trends to technical and non‑technical stakeholders.
• Support cross‑functional reporting initiatives and management decision‑making.

Project Administration, Documentation & Executive Reporting

• Prepare project status reports, executive summaries, dashboards, presentations, and management briefings.
• Support tracking of project milestones, deliverables, budgets, schedules, risks, and performance metrics.
• Maintain reporting records, supporting datasets, performance trackers, and analytical documentation.
• Consolidate project information into management‑level reports and presentations.
• Support reporting requirements associated with project planning, implementation, monitoring, and closeout.
• Ensure reporting deliverables are accurate, organized, and completed within established deadlines.

Qualifications

Required

• 3–5 years of professional experience in data analysis, business intelligence, business reporting, or a related analytical field.
• Demonstrated experience developing dashboards, reports, and data visualizations using Microsoft Power BI.
• Strong proficiency in advanced Microsoft Excel, including formulas, pivot tables, and data analysis.
• Experience using SQL to query, extract, and analyze information from databases.
• Working knowledge of Power Query, DAX, and data modeling.
• Experience collecting, cleaning, transforming, validating, and analyzing datasets.
• Experience developing and monitoring KPIs, performance metrics, and management reports.
• Ability to identify trends, interpret complex information, and communicate actionable findings.
• Experience gathering business requirements and developing analytical reporting solutions.
• Strong organizational, analytical, problem‑solving, and critical‑thinking abilities.
• Ability to manage multiple assignments, priorities, and deadlines.
• Excellent written and verbal communication skills.
• Ability to work independently and collaboratively with multidisciplinary teams.
• Valid driver's license.
• Ability to travel to assigned project locations and obtain required airport security credentials.

Preferred

• Experience supporting aviation, transportation, infrastructure, construction, or capital improvement projects.
• Familiarity with project controls, project performance monitoring, budget tracking, scheduling, or program reporting.
• Experience supporting operational or infrastructure‑related performance analytics.
• Experience integrating information from multiple business systems and data sources.
• Experience developing executive dashboards and management‑level reporting solutions.

Preferred Certifications

• Relevant Microsoft Power Platform or Business Intelligence certifications
• Relevant data analytics, SQL, or business analysis certifications
• Relevant certifications will be considered alongside demonstrated professional experience and technical capabilities.

Education

Bachelor's degree in Data Analytics, Business Analytics, Information Systems, Computer Science, Business Administration, Engineering, or a related field preferred.

Equivalent combinations of relevant education and professional experience may be considered, subject to applicable project requirements.

• Business Data Analysis & Business Intelligence
• SQL & Database Querying
• Power Query & DAX
• Data Modeling & Transformation
• Advanced Microsoft Excel
• KPI Development & Performance Monitoring
• Project Controls & Performance Reporting
• Project Schedule, Budget & Milestone Analysis
• Capital Improvement & Infrastructure Program Reporting
• Data Quality Assurance & Validation
• Business Requirements Gathering
• Data Integration & Reporting Automation
• Operational & Program Performance Analysis
• Stakeholder Collaboration & Communication
• Reporting Process Improvement
• Microsoft PowerPoint & Executive Presentations
• Project Documentation & Analytical Reporting

Physical, Schedule & Eligibility Requirements

• Full‑time position.
• Hybrid work arrangement with a maximum of one remote workday per week, subject to project requirements.
• Regular on‑site presence required 4–5 days per week.
• Project assignments throughout the New York and New Jersey metropolitan area.
• Primary work location determined by project requirements.
• Ability to travel between assigned project locations as required.
• Regular working hours generally Monday through Friday, 9:00 AM–5:00 PM Eastern.
• Availability outside regular business hours may be required for emergencies, deadlines, and operational needs.
• Ability to sit, stand, and walk for extended periods.
• Ability to work at computer workstations for extended periods.
• Ability to work in office and operational infrastructure environments.
• Ability to participate in project site visits and operational coordination meetings.
• Ability to wear required personal protective equipment (PPE) when accessing designated areas.
• Must be authorized to work in the United States.
• Must possess a valid driver's license.
• Must be able to complete required background checks and obtain airport identification credentials for secured areas.
• Must have reliable transportation to and from assigned work locations.

Salary

Annual base salary range: $100,000–$125,000.

Compensation will be determined based on experience, professional qualifications, certifications, assigned responsibilities, and project requirements and will comply with applicable federal, state, and local pay equity requirements.

• Medical, dental, and vision benefits
• 401(k) with employer matching contribution
• Paid time off (PTO) and company holidays
• Professional development and certification support
• Collaborative and growth‑oriented work environment

McKnight International is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment.