NAVAIR/Journeyman Management Analyst

WASEYABEK DEVELOPMENT COMPANY LLC; Annapolis (MD); Remote; USD 70,000 - 100,000; Full time

Job summary

FED95 is seeking an experienced Microsoft Excel expert to support the PMW-200 Aviation Logistics IT program for a DoD customer. The role is remote with minimal travel, based at NAS Patuxent River, MD oversight, and requires US citizenship and ability to obtain a secret clearance.

You will develop financial reports, dashboards, and TCO analyses, build PivotTables, Power Query pipelines, and dynamic visuals to inform senior leadership and stakeholders across the Navy and joint forces.

Qualifications

• U.S. citizenship required and ability to obtain Secret Clearance.
• Bachelor’s degree required; master’s preferred.
• Expert in Microsoft Office, especially Excel with advanced formulas.
• Mastery of INDEX/MATCH, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IFS, LET, and array formulas.
• Proficient in dynamic arrays, structured references, and multi-step calculations.
• Data modeling, PivotTables/Charts, and dashboards for executives.
• Power Query, Power Pivot, and DAX for relational data modeling.
• Creative, proactive problem-solving and efficiency improvements.
• Ability to communicate with non-technical stakeholders and document processes.
• Familiarity with DoD environment and ability to pass background checks.

Responsibilities

• Create and maintain financial reports using Microsoft Excel.
• Prepare charts, reports, memos, and emails for signature or collaboration.
• Support workshops and conferences with administrative/logistical services.
• Establish and maintain filing systems per naval standards.
• Perform SharePoint Online tasks: libraries, permissions, users.
• Develop and maintain task-tracking systems for projects.
• Utilize databases; reconcile data; generate reports across sources.
• Contribute to Total Cost of Ownership analyses for PMW-200 IT products.
• Other duties as directed by leadership.

Skills

Excel expert

Advanced formulas

Data modeling

PivotTables/Charts

Problem solving

Team player

Communication

Background check

Education

Bachelor's degree

Master’s degree

Tools

SharePoint Online

Power Query

Power Pivot

DAX

Power BI integration

Job description

**This is a remote position.**

Mission

FED95 is currently hiring for an experienced Management Analyst to fully support our Government client Program Manager, Warfare-200 Aviation Logistics Information Technology (PMW-200 Aviation Log IT) at NAS Patuxent River, MD. PMW-200 Aviation Log IT has the overall responsibility to research, develop, analyze, and evaluate solutions in order to implement and deploy the best web enabled system that will automatically deliver updated technical, supply, and maintenance information to joint forces throughout the DoD in ashore, afloat, and expeditionary settings.

Summary/Objective:

FED95 is currently hiring for an experienced expert with Microsoft Excel to fully support our Government client, Program Manager, Warfare-200 Aviation Logistics Information Technology (PMW-200 Aviation Log IT), that is headquartered at NAS Patuxent River, MD. The highly qualified candidate will be able to work remotely, with minimal travel required.

Position Summary

PMW-200 Aviation Log IT manages a portfolio of acquisition programs of record that delivers logistics IT solutions for the Department of the Navy and Joint Forces throughout DoD in ashore, afloat, and expeditionary settings. FED95 is currently seeking an experienced Microsoft Excel expert to support their Business Office and executive leadership with managerial and financial analysis and presentations for PMW-200 Log IT.

Responsibilities:

• Creating and maintaining Financial Reports utilizing Microsoft Excel
• Review, prepare and coordinate a variety of high-quality charts, reports, memorandums, emails, and other documents for signature or collaboration.
• Assist with special projects and provide administrative services and logistical support for office-sponsored workshops, conferences, and symposiums, when necessary.
• Establish and maintain filing systems in accordance with the Naval Correspondence Manual including document control.
• Perform various Share Point Online tasks including creating document libraries, uploading files, adding groups and people, and setting permissions
• Develop and maintain task tracking systems to keep track of tasks assigned.
• Utilize and maintain databases and information systems. Review and reconcile data. Generate reports from various informational databases using standard parameters or special queries as required. Provide data entry for startup or closeout information on projects.
• Perform review of technical analysis and research for the development and maintenance of Total Cost of Ownership (TCO) models for the IT products and services ultimately delivered to the warfighter for PMW-200 Aviation Log IT.
• Additional functions not specifically outlined in this position description as directed by the leader.

Minimum Qualifications, Knowledge, Skills, and Abilities:

• United States Citizenship
• Bachelor’s degree
• Ability to obtain Secret Clearance
• Expert in Microsoft Office Products, specifically Excel
• Advanced Formulas & Functions
• Mastery of complex functions like INDEX/MATCH, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IFS, LET, and array formulas.
• Understanding of dynamic arrays and structured references.
• Ability to build multi-step calculations, conditional logic, and error handling
• Data Modeling & Analysis
• Creating and managing PivotTables and PivotCharts for summarizing and visualizing large datasets.
• Using Power Query for data cleaning, transformation, and integration from multiple sources.
• Applying Power Pivot for relational data modeling and DAX functions
• Dynamic Dashboards & Visualization
• Building interactive dashboards with slicers, timelines, and dynamic filters.
• Using charts, sparklines, and conditional formatting to tell data stories.
• Ensuring dashboards update automatically with new data
• Strategic & Business Skills
• Problem-Solving & Efficiency
• Identifying inefficiencies in processes and designing Excel solutions to streamline them.
• Optimizing formulas and layouts for speed and accuracy.
• Using Excel to support decision-making at all levels of an organization
• Collaboration & Communication
• Sharing and protecting workbooks effectively (permissions, sharing options).
• Explaining complex Excel models and dashboards to non-technical stakeholders.
• Documenting processes and formulas for team use.
• Staying updated with Excel features (e.g., new functions, Power Query enhancements).
• Experimenting with advanced techniques like Power Automate, Power BI integration, and AI-assisted Excel tools.
• Ability to quickly adapt focus, adjust schedule and problem solve to meet evolving work demands and needs of supervisor and other stakeholders.
• Highly resourceful team-player, with the ability to also work independently and balance multiple competing priorities and tasks.
• Ability to pass a pre-employment drug screen.
• Ability to pass an extensive background investigation, including but not limited to personal and professional financial history, nationwide criminal record search, credit check and other relevant background information deemed necessary.

Preferred Qualifications, Knowledge, Skills, and Abilities:

• Experience working with the Department of Defense
• Using Artificial Intelligence (Ai) for data analysis and presentation
• Project Management experience
• Master’s Degree in the field of business
• Secret clearance

Physical Requirements:

While remote, this position operates in a professional office environment. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Flexibility related to work hours as project demands arise.
• Must be able to remain in a stationary computer position for extended periods of time.
• Must be able to use hands and fingers to type.
• Must be able to reach with hands and arms for using a computer.

Travel Requirements:

Minimal, less than 5%.

Work Hours:

Core work hours are 0700-1700 EST Monday through Friday. Compressed Work Schedule (CWS) may be authorized.

Disclaimer:

This job description indicates in general the nature and levels of work, knowledge, skills, abilities, and other essential functions (as covered under the Americans with Disabilities Act) expected of an incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of an incumbent. An incumbent may be asked to perform other duties as required.