Lead Data Analyst Senior (FIAR) #24278 - Aeyon

Job Description:

Background:

The F-35 Lightning II Joint Program Office (JPO) leads the life-cycle program management of the F-35A, F-35B, and F-35C: the fifth-generation joint strike fighter air system for the U.S. Air Force, U.S. Navy, U.S. Marine Corps, international partners, and foreign military sales customers. 

Now that the F-35's have passed their Initial Operational Test & Evaluation (IOT&E), they're ready for serial production, deployment and production.

DoD Audit Readiness is a significant goal for the Office of the Secretary of Defense (OSD) and a major linchpin to the DoD receiving an unmodified Audit is the F-35 program. This has brought increased attention to the F-35 JPO resolving the notices of findings and recommendations (NFRs) for accountable property... Making this the best time to innovate and streamline financial related processes, systems and procedures.

Project Objectives for the Transforming Financial Improvement and Audit Remediation (FIAR) in the F-35 JPO

The JPO will need to change property accountability processes that require utilization of the GFP Module and the Program's Accountable Property System of Record to be populated and sustained with all F-35 property.

The F-35 JPO is listed as a high priority item by the Deputy Secretary of Defense (DepSecDef) to achieve Audit Readiness. 

To achieve audit compliance, the F-35 JPO must:

• Complete the Trial Balance of the F-35 JPO by December 2025 per Deputy Secretary of Defense
• Establish and adhere to all audit methodologies and requirements across the enterprise
• Ensure the control environment aligns with Department of the Air Force, the Department of the Navy and the Defense Logistics Agency.
• Transform our current FIAR efforts to ensure that there is a clear strategy and comprehensive plan to achieve audit compliance
• Transition to a solution that automates our asset tracking into the Procurement Integrated Enterprise Environment (PIEE)
• Remediate Notice of Finding and Recommendations (NFRs) from DOD-IG and GAO
• Ensure an automated capability for total asset visibility and inventory control (TAV/IC)
• Ensure our Accountable Property System of Record is accurate, complete, and is minimal burden capturing all Government Furnished Property movement; seamlessly allowing the US Services to financially report F-35 assets
• Develop, document, and test Internal Controls for audit requirements to establish an Initial Trial Balance

Experience Requirements:

Experience Mandatory:

• 7+ years of both practical experiences working with financial audits, large data sets, and managing professional teams
• Ability to work on large teams & across multiple stakeholders to solve multiple problems and agree on a final goal
• Academic or practical experience creating new ways to display evolving audit data
• Extremely detail oriented
• Experience creating or working with new systems, software, or visualization tools that take existing data off old systems to put into a new creative format
• Experience modernizing systems and pulling together disparate pieces of data from various entities
• Experience supporting cost estimations, conducting financial audits, and establishing an audit strategy
• Experience developing, documenting, testing internal controls for audit requirements
• Advanced excel experience, Power BI, Tableau, R, Python, SQL, C#

Experience General

• Working alongside technologically savvy/detail-oriented teams of professionals
• Backend experience merging systems or software to integrate and automate data
• Navigated updating/automating old ways of doing things within a large institution
• Experience working simultaneously with multiple high-level stakeholders to find agreed upon solutions problems and created a method to address said problem
• Experience leading/ being responsible for the quality assurance of large data sets & transfers
• Comfortable addressing discrepancies in data and efficiently working with groups to find errors
• Professional experience solving large puzzles, finding missing pieces, & piecing together full displays of information to present/ share with others
• Experience being given new policies to integrate into an existing plan coordinating with multiple stakeholders to execute
• Experience or practical education in managing large ledgers
• Experience in double-end bookkeeping

• Experience working with large teams and across large institutions. One or more of the following is a plus:
  • Office of the Secretary of Defense/ United States Military
• White House
• Congress
• Acquisition systems within the Air Force, Navy, or Marine Corps
• Foreign militaries or their multilateral weapons sales and compliance teams
• Government Accountability Office (GAO) and/or DoD Inspector General (IG)
  • Specifically on Notice of Findings and Recommendations (NFRs) identifying weaknesses and inefficiencies in financial processes, their respective impacts, why they exist, and recommendations on how to correct

Certification Requirements: N/A

Education Requirements:

• Bachelor of Arts / Bachelor of Science

Work Type:

OnSite - Washington DC/NCR:

Clearance Requirements:

Secret Clearance is Required (no interim clearances)