Project Finance Analyst II

Alutiiq, LLC; Huntsville (AL); Hybrid; USD 90,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, vision

Life insurance

401(k) retirement

Paid leave

Job summary

Afognak Native Corporation seeks a Project Finance Analyst II to manage accounting, planning, estimating, tracking, analysis, budgeting and reporting for a portfolio of federal contracts. The role requires GAAP knowledge and Deltek CostPoint expertise to set up projects and track costs against performance.

You will provide cost and schedule updates, perform EACs, prepare monthly revenue recognition, and collaborate with Operations, Contracts, and Procurement to maintain data accuracy.

Qualifications

• Bachelor’s degree in business, accounting or related field required.
• Minimum 3 years in project accounting/control or related area.
• Strong knowledge of GAAP and government contract accounting preferred.
• Experience with Deltek CostPoint and Excel required.
• Ability to analyze contracts, forecast costs, and recognize revenue.

Responsibilities

• Forecast planned costs and explain variances to Operations.
• Set up projects in Deltek CostPoint and maintain funding records.
• Prepare monthly revenue recognition and billings for projects.
• Provide cost and schedule updates and perform EACs.
• Coordinate with Operations, Contracts, and Procurement on financial deliverables.
• Assist with month-end close, journal entries, and variance analysis.

Skills

GAAP knowledge

Forecasting

Revenue recognition

Deltek CostPoint

Excel

Cost analysis

Team collaboration

Education

Bachelor's degree in business, accounting, or related

Tools

Deltek CostPoint

Excel

Job description

POSITION OVERVIEW AND PRIMARY DUTIES AND RESPONSIBILITIES (ESSENTIAL FUNCTIONS):

Afognak Native Corp has an opportunity for aProject Finance Analyst II (PFA III). The PFA II is responsible for executing business processes related to accounting, planning, estimating, tracking, analysis, budgeting, and reporting throughout the life cycle of a portfolio of moderately-sized Federal fixed-price, cost-plus and time & material contracts and task orders as assigned. Duties include:

• Utilizing government contracting and accounting knowledge to complete reviews and analysis of government contracts.
• Setting up projects in the accounting system using contract documents
• Coordinating with project team to produce financial deliverables for both internal and external use.
• Processing revenue recognition and subcontract accruals for assigned projects.
• Providing cost and schedule updates.
• Performing Estimates at Completion (EACs) for management analysis.

The PFA II interacts with and provides direct support to management and other project team members and advises project management on financial matters related to the execution of contracts and task orders. Specific assignment will include monitoring project cost in conjunction with schedule performance and performing related analyses. The employee also provides input for management review presentations and participates in proposal preparation, interfaces with members of Corporate Finance and Accounting, Contracts, Pricing, and Procurement consultants, and subsidiary management at all levels. The PFA II will work in both virtual and office team environments.

• Planning and Project Setup: The PFA II is required to:
• Forecast the planned costs throughout a period of performance. If variances appear between planned and actual costs, the PFA II will:
• Communicate the issues to Operations.
• Provide cause explanations and advise on corrective actions.
• Determine appropriate project setup related to assigned contract based on their type and structure including proper billing and revenue terms.
• Ensure that project set-ups and modifications are accurately entered in Deltek CostPoint (ERP).

• Estimating: The PFA II may be required to provide cost estimates for Task Orders, Option Periods, Travel, and/or ODCs for submittal to the end user customer.

• Tracking: The PFAI will be required to:
• Create and maintain, at a minimum, the following records:
• Monthly costs incurred.
• Forecast costs throughout the entire period of performance.
• Allowable labor / ODC categories.
• Funding records.
• Self-performance percentages.
• Subcontractor Blanket Purchase Orders

• Additionally, the PFA II will utilize knowledge of Deltek CostPoint to update automated systems with project information such as:
• Contract values and contract funding levels.
• Period of performance.
• Line of business.
• Project labor categories.
• Other Project related data.

• Analysis: The PFA II is required to provide analysis of assigned projects and/or task orders. In so doing, the PFA II:
• Utilizes knowledge and training to analyze contracts to determine appropriate revenue recognition related to generally accepted accounting principles.
• Processes and analyzes revenue and margins monthly.
• Reviews and posts timely and accurate project monthly revenue recognition procedures, in accordance with GAAP.
• Works with Operations regarding cost analysis requests and provides feedback and suggestions.
• Funding availability
• Allowance of costs

• Prepares and processes billing for assigned projects.
• Analyzes Open Billing Detail reports.
• Determines if costs are billable / allowable.
• Identifies financial discrepancies.

• Reviews monthly Project Status Reports.
• Compares reports to project proposals and notes any variances.
• Determines corrective action required to correct accounting system errors related to accounting system project information.
• Provides analysis findings to Operations.
• Reviews subcontractor/vendor invoices and accepts or rejects.
• Tracks and monitors projects in anticipation of de-obligation of funds requests.
• Reviews and prepares month-end journal entries related to subcontracts and ODC accruals and analyzes results after posting.
• Prepares, analyzes, and/or reviews, project costs and variance reporting for assigned projects.
• Assists, supports and trouble shoots Accounts Payable, Billing, Payroll and Procurement project/account errors.
• Reconciles unbilled PSR/GL monthly and communicate discrepancies to management.
• Review all direct project purchase card statements in Concur after cardholders have reconciled and before Supervisor approva to ensure proper coding and adequate supporting receipts and documentation are provided.
• Responsible for creating, maintaining, and updating Wage Determination Tables (required for projects with employees working multiple PLCs with varying pay rates).

• Reporting: The PFA II ensures that the analysis and corrective action suggestions (if necessary) are reported appropriately.
• Effectively communicates financial results with project managers (PM) and other stakeholders regarding contract documentation, financial results, and ensures senior leadership are aware of risks and opportunities identified during project financial tracking, revenue recognition review, Accounts Receivable, WIP, etc.
• Participates in monthly meetings with Operations to review project financial performance, provide records of the financial health of the project(s).
• Creates and maintains Estimates at Completion for inclusion in revenue recognition.
• Creates and maintains subcontractor / vendor accruals for inclusion in revenue recognition.
• Maintains project files on SharePoint including: Contracts, subcontracts, proposals, budgets, revenue & plans, schedules, project review materials, reports, deliverables, invoices, leases and agreements.

• Budgeting: The PFA II may also be responsible for budgeting for assigned projects for the annual corporate budget. When tasked, the PFA II:
• Creates calendar year project budget based on trends / backlog value and coordinates the budget with the Project Management Team.
• Submits the PM approved budget to the Director of Budgeting for inclusion into the annual corporate budget.
• Analyzes all direct project costs/fee/revenue data; monitors project budgets and progress; and shares results with Program Managers to ensure projects achieve financial expectations.

• Customer Requirements: The PFA II responds to a wide variety of customer requirements and request to include, but not limited to the following:
• Interacts with other departments, such as Contracts, Project Management, and Business Unit Leads regarding project related issues.
• Provides input for contract required Contract Data Requirements Lists (CDRLs)
• Works with operations on completing required reports and other deliverables for submittal.
• Attends project/program reviews with end user customers and provide explanations of financial data.

• Internal Interface:
  Corporate Finance:
  • Coordinates the accurate set-up of new projects, to include the appropriate project code designations, project labor categories, account codes, periods of performance.
  • Provides explanations regarding revenue variances from month to month.
  • Provides required documentation to initiate labor corrections / accounts payable reclassifications.
  • Communicates with Accounts Payable to ensure that subcontractors / vendors are paid timely.
  • Reviews of TERs for accuracy prior to submittal to Accounts Payable for payment.
• Contracts Management Consultants:
  
  • Reviews contracts / task orders / modifications for accuracy and communicates any necessary changes.
  • Requests financial / administrative modifications as required.
  • Notifies the contract manager when the project option period / task order will reach 75% expended per FAR 52.232-22.
• Procurement Consultants:
  
  • Processes Purchase Requisitions for new projects / modification changes.
  • Reviews Purchase Orders for accuracy and communicates necessary changes.
• Pricing Consultants:
  
  • Provides past performance information to the Bid & Proposal department.
• Corporate Human Resources:
  
  • Coordinates with HR for new project / new employee set-up (as needed).Operations Senior Management:
    
    • Provides operations management information on under-performing projects with variance explanations and corrective action suggestions.
    • Provides senior leadership with guidance on process improvements.
  • Other Duties: As assigned

  REQUIRED QUALIFICATIONS AND EXPERIENCE:

  • Minimum 3 Years in Project Accounting and Control or Related Accounting Field
  • Demonstrated knowledge of general accepted accounting practices (GAAP)
  • General understanding of multiple contract types: FFP, FPLOE, and T&M contracts.
  • Government contract accounting experience preferred.
  • Bachelor's degree in business administration, program management, accounting, or an appropriate related discipline (additional experience may be substituted in lieu of a degree).
  • Technology experience:
    • Experience with Microsoft Office Suites, particularly Excel, as well as other database software is required.
    • Experience with Deltek CostPoint preferred.
  • Desired Attributes:
    • Strong analytical and problem-solving skills.
    • Good communication skills that include communicating with tact and diplomacy.
    • Proven ability to work as a team player.
    • Proven ability to meet deadlines and handle stressful situations.
    • Ability to work independently and be self-motivated and proactive.
  • Must be able to obtain a federal security clearance.

  Afognak Native Corporation and Afognak's direct and indirect subsidiaries, partnerships, joint ventures and affiliates to include Alutiiq, LLC; Afognak Commercial Group, LLC; Alutiiq Professional Consulting, LLC; and each of their respective domestic and foreign, direct and indirect subsidiaries, partnerships, joint ventures and affiliates are equal opportunity employers that do not discriminate on the basis of actual or perceived race, color, religion, national origin, citizenship status, age, sex (including pregnancy, childbirth, related medical conditions and lactation), sexual orientation, protected veteran status, disability, genetic information, or any other characteristic protected by applicable federal, state or local laws (collectively, "Protected Status").

  The pay range information provided is a general guideline. The pay rate offered will be determined based on the candidate's experience and qualifications, as well as geographic locations, market data, and other business considerations, as permitted by law.

  Our full range of benefits include medical, dental, vision, disability protection, life insurance, prescription coverage, voluntary benefits, paid leave, and 401(k) retirement. Positions covered by the McNamara O'Hara Service Contract Act (SCA), Davis-Bacon Act (DBA), or a Collective Bargaining Agreement (CBA), or Fair Labor Standards Act (FLSA) will comply with the statute or CBA requirements as well as other client-customer contract requirements (all benefits are subject to eligibility requirements). For more information, please visit our Company's Career page.