Analyst II, Aircraft Financial Planning and Analysis

Position Summary

• 100% On-site position, Monday-Friday
• Compensation: Annual salary $68,000 – $83,000

The Analyst II position within Clay Lacys Aircraft Financial Planning and Analysis Department, is responsible and accountable for all financial planning, billing, reporting, and analysis to the assigned Clay Lacy managed aircraft owners, owners teams, and FDSS customers. This position will be the front of Clay Lacys customer facing Aircraft Management Finance operations. The Analyst is expected to have the skills necessary to forecast, execute, analyze, and manage to a customers desired strategic financial and operational plan for their aviation asset, as well as use discretion to make decisions for the account. The Analyst must use professionalism and independent judgement in the financial management of each specific account, specifically in regard to customer interactions.

Performance Objectives

To achieve the mission for this position, one must produce the following actions and results:

1. New Customer Onboarding Work with Aircraft Management Sales to create a clean transition for the customer from the Aircraft Management Sales Team to the Aircraft Financial Planning & Analysis Team
   1. At time of formal client engagement, plan introduction and formal touch point with customer and discuss customers reporting expectations, wants, and needs. Ensure proper introductions are made and relationship is seamlessly handed off from the Aircraft Management Sales Team
   2. With the assistance of the Manager, FP&A, ensure New Aircraft Onboarding List Data Sheet & Internal Setup is completed and adheres to Clay Lacys Reporting Guidelines
2. Annual Aircraft Operating Budget Process Enhance and participate in current process by which Clay Lacy creates annual aircraft operating budgets for each customer
   1. These are to be created by the Analyst and reviewed with the Director, Aircraft FP&A as well as with each Assigned Aircraft Manager to be presented to the different levels of ownership on each account
   2. As an Analyst, you will play an active role in this engagement, and be the primary point of contact for the annual setting of the aircrafts financial expectations with the customers team, based upon projected usage, expenses, and when applicable, charter revenues
   3. You will be the accountable and responsible individual for speaking to the financial reporting throughout the year for the respective airplane, against the annual pro-rated budget and must be able to speak to any and all positive and negative variances
3. Standardized Monthly Customer Reporting & Deliverables Provide customers with and be the face to speak to all Standard Reporting & Deliverables
   1. Create standardized Customer-Facing Communication Template & Process for Monthly Reporting Deliverables
      1. Utilize this format and channel to provide backward and forward-looking analysis, insights, and recommendations.
   2. Ensure Standard FP&A Deliverables are being provided fleetwide. Standard Monthly Deliverables include:
      1. Weekly Accounting Summary (as applicable)
      2. Monthly Management Summary
      3. Monthly YTD P&L Summary
      4. Monthly Account Balance Summary
      5. Quarterly Reporting Package (Dashboard & KPI Summary)
      6. Annual Budget Package
   3. Ensure consistent touch point with customers on a monthly basis, thus strengthening the relationship and building rapport
4. Ad Hoc Monthly & Quarterly Analysis Create new Clay Lacy Ad Hoc Analysis Templates & Reporting Deliverables (Part of Value-Add Initiative)
   1. Create, Implement, and Enhance Newly Defined Reporting Deliverables. These include but are not limited to:
      1. Owner Aircraft Summary Dashboard (Part 91 & Part 135)
      2. Direct Operating Cost Analysis (Part 91 & Part 135)
      3. Charter Revenue and Contribution Margin Analysis (Part 135)
         1. Net Impact of Charter Analysis (Part 135)
      4. Clay Lacy Cost Savings Summary (Part 91 & Part 135)
      5. Aircraft P/L Analysis Templates Revenue & Expense
         1. Fuel Analysis, Owner Trip Expense Analysis, Maintenance Analysis, etc.
      6. Period-Over-Period Analysis Templates Revenue & Expense Comparisons
5. Customer Accounts Receivables Reporting & Adherence Work closely with the Accounts Receivable Manager, Managed Fleet to ensure that all aircraft you oversee remain current and timely payments are made consistently
   1. On an as needed basis, provide customers with analysis and reporting related to customers current and past due Accounts Receivable Balances and assist Accounts Receivable Manager to ensure Customer remains within payment terms on all balances
   2. Act as the informed individual speaking to the customers current Operating Deposit. Provide all analysis, recommendations, and requests for Increases/Decreases in current Account Operating Deposit
   3. Assist in CLAs efforts to transition Managed Aircraft Customers from CLA Operating Deposits to Segregated Bank Accounts
6. Clay Lacy Account Profitability Ensure Clay Lacys Tail Profit & Loss (P&L) Model produces accurate and actionable data for the aircraft you are assigned to work with, as well as other aircraft in the fleet as needed
   1. Monitor to ensure accurate allocations are properly defined, based upon underlying activity basis
   2. Work with Director, Financial Planning and Reporting to further enhance and develop current internal processes related to Tail P&L Initiatives
7. Other All Other Tasks related to Clay Lacys Aircraft Financial Planning & Analysis Efforts, some of which are undefined
   1. Provide Internal Clay Lacy Teams with a Managed Fleet Direct Operating Cost List, summarizing each respective Tail # and Aircraft Type. This is to be updated annually and dispersed to Charter/Flight Operations, Maintenance, and the Aircraft Management Teams
   2. Create and further develop list of actions and department efficiency corrections to be taken in order to further develop efficiencies within the group and ensure the positive affect on Clay Lacys customers

Performance Evaluation & Key Performance Indicators

• The Primary Goal for the Aircraft FP&A Department in 2020 and 2021 is to have consistency and accuracy in the internal and external reporting deliverables, enhanced communication both internally and externally, and to build rapport and relationships with our Level 1, 2, and 3 Customers as needed

The success of the Analyst II Position in achieving the objectives described above will be measured by the following:

• Measuring Touch Points with Assigned Customers through Onboarding and Ongoing Account Relationships. Group and Employee Specific Goals Related to Tiered Customer In-Person and Phone Call Touch Points
• Consistency and Accuracy in providing financial planning, reporting, and analysis to Clay Lacys Customers
• By having the Monthly/Weekly Reporting Deliverables provided to the customer by a set date each month/week

Education and Experience:

• Bachelors Degree or Equivalent preferred, as well as a minimum of 2-3 years of relevant experience in financial reporting and customer service preferred. Must also have the ability to present and discuss issues with Level 1, 2, and 3 Customers Through email and phone communications, Meetings at Clay Lacy Facilities, and Meetings at Off-Site Locations thus including the associated travel requirements.

Personality and Character

The ideal candidate will have most of the following traits:

• Strong technical ability and customer facing financial presentation skills
• Strong analytical and financial reporting understanding and skills
• Ability to use discretion and make decisions for each account you manage
• Quick learner and capable of adding to analytical and technical skills on an ongoing basis
• Open thinker willing to receive feedback for consistent improvement and ongoing employee development
• Ability to be show professionalism in all areas of financial management for each account, as well as using independent judgement, specifically in customer interactions
• Intermediate Computer Skills MS Outlook, Office, Excel, PowerPoint, and Clay Lacy Programs/Financial Reporting Software
• Strong organizational change agent
• Ability to secure respect and credibility with team members, peers, Clay Lacy Leadership Team and Clay Lacy customers.
• Collaborative working style, and skill in organizing resources and establishing priorities
• Ability to communicate effectively, both orally and in writing
• Skill in developing and examining operations and procedures, and assisting in formulating new policy and developing and implementing strategies and procedures
• Employee development and performance management skills
• Strong interpersonal and communication skills and the ability to work effectively with a wide range of constituencies in a diverse community
• Strategic thinker, capable of making key decisions quickly.
• Highly responsible, willing to OWN the process / project and outcome.

Reporting Relationship

The Analyst II Position will report directly to the Manager, Aircraft Financial Planning and Analysis.