Data Analyst

About Burns

Burns is a nationally respected provider of specialized engineering services, bringing highly technical, sought-after engineering expertise to complex transportation and critical infrastructure projects.

For more than 50 years, we have built our reputation on outstanding client service. Ranked a Top Workplace and ENR Top 500 Design Firm, we are personally invested in helping our clients achieve their goals, sharing in their passions, and successfully guiding them through the challenges of complex projects using our no surprises Burns Unique Client Experience.

We are seeking a Data Analyst to join our Aviation Technology team to support our client in Los Angeles.

Essential Duties & Responsibilities:

1. Collation, summation and review of daily performance data (Day +1). currently maintain spreadsheets
2. Reports that collate OTP data, aircraft taxi data, cancellations, movements by type, enplaned pax, Load factor
3. Facility utilization (Asset Utilization) analysis for gates, check-in counters, baggage claim devices
4. Curb front, RON analysis (current and forecasted)
5. Facility availability by airline and facility (analyze schedules to identify potential opportunities)
6. System analysis of baggage system reports and data from Brock and Vanderlande
7. Tracking of KPIs related to various Ops systems such as AMS6 and Aerobahn.
8. Creation and maintenance of passenger and movement forecast (both short and long term)
9. Look at key markets to identify trends, gaps and opportunities
10. Analyze reports external to LAWA such as the TBITEC bags left behind reports to and interline reports to identify areas for improvement.
11. Traffic data analysis and correlation
12. Champion collection of data to support passenger presentation curves and similar efforts.
13. Assist with Air Service Development analysis to help identify trends and opportunities. Identify service enhancement opportunities based on traffic flows between terminals.
14. Working with finance systems
15. Working with IMT systems
16. Work with various LAWA divisions system from 3rd party to custom to files.
17. Automation of systems related to data automation

General Requirements:

1. Strong ability to collect, analyze, and interpret large and complex data sets
2. Use a variety of advanced data science and predictive analytical techniques such as mathematical modeling and statistical techniques in conducting research on a wide variety of problems
3. Ingest, compiles, processes, cleanse, validate and analyzes data from a variety of sources
4. Use automation tools to streamline work processes
5. Meet with LAWA Lines of Businesses to gather requirements for data analytics.
6. Uses modern information technology or contemporary statistical tools for necessary calculations and statistical modeling
7. Use LAWA’s data analyst tools like Power BI, SQL, PowerShell, python (not limited too) to accomplish tasks.
8. At the direction of LAWA IT, the Data Analyst will work on various analytics projects based on current needs. May be assigned to work directly with individual or teams and report to different locations on the LAX Campus.

Supervisory Responsibilities

1. No supervisory responsibilities

Education & Experience:

1. A Bachelors Degree in computer science, statistics, or information systems or related field.
2. A minimum of 3-5 years of experience