Journeyman Management Analyst

Waséyabek

. Support the Government client Program Manager for PMW-200 Aviation Logistics Information Technology .

Posted 10/10/2026full-timeRemote • Maryland • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Microsoft Excel, including advanced functions and data visualization techniques, while providing managerial and financial analysis support. Capable of managing projects and collaborating effectively with stakeholders in a government environment.

Highest-signal resume keywords

Expert In Microsoft ExcelAdvanced Excel FunctionsData Cleaning And TransformationProject Management ExperienceSecret Clearance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Financial AnalysisData ReconciliationTask-Tracking SystemsDatabase ManagementPivotTables And PivotChartsDAX FunctionsDynamic ArraysConditional LogicExcel DashboardsDocument Control

Soft Skills

Problem SolvingCollaborationAdaptabilityTime ManagementCommunication

Tools & Technologies

Microsoft Office ProductsSharePoint OnlinePower QueryPower PivotArtificial Intelligence

Certifications & Qualifications

Bachelor's DegreeAbility To Obtain Secret Clearance

Industry Keywords

Government Client SupportAviation LogisticsDepartment Of DefenseTotal Cost Of OwnershipNaval Correspondence Manual

About the role

Key responsibilities & impact

Support the Government client Program Manager for PMW-200 Aviation Logistics Information Technology
Support the Business Office and executive leadership with managerial and financial analysis and presentations
Create and maintain financial reports using Microsoft Excel
Review, prepare, and coordinate charts, reports, memorandums, emails, and other documents for signature or collaboration
Assist with special projects and provide administrative and logistical support for workshops, conferences, and symposiums
Establish and maintain filing systems in accordance with the Naval Correspondence Manual, including document control
Perform SharePoint Online tasks, including creating document libraries, uploading files, adding groups and people, and setting permissions
Develop and maintain task-tracking systems
Utilize and maintain databases and information systems
Review and reconcile data
Generate reports from informational databases using standard parameters or special queries
Enter startup or closeout information for projects
Review technical analysis and research for development and maintenance of Total Cost of Ownership models
Perform additional duties as directed by the leader

Requirements

What you’ll need

United States Citizenship
Bachelor’s degree
Ability to obtain Secret Clearance
Expert in Microsoft Office Products, specifically Excel
Mastery of complex Excel functions including 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
Experience creating and managing PivotTables and PivotCharts
Experience using Power Query for data cleaning, transformation, and integration
Experience using Power Pivot for relational data modeling and DAX functions
Ability to build interactive dashboards with slicers, timelines, and dynamic filters
Ability to use charts, sparklines, and conditional formatting
Ability to identify process inefficiencies and design Excel solutions
Ability to optimize formulas and layouts for speed and accuracy
Ability to share and protect workbooks effectively
Ability to explain complex Excel models and dashboards to non-technical stakeholders
Ability to document processes and formulas
Ability to adapt focus, adjust schedule, and solve problems to meet evolving work demands
Ability to work independently, balance multiple competing priorities, and collaborate as a team player
Ability to pass a pre-employment drug screen
Ability to pass an extensive background investigation, including financial history review, nationwide criminal record search, and credit check
Flexibility related to work hours as project demands arise
Ability to remain in a stationary computer position for extended periods
Ability to type and use a computer
Preferred: Experience working with the Department of Defense
Preferred: Using Artificial Intelligence for data analysis and presentation
Preferred: Project Management experience
Preferred: Master’s Degree in business
Preferred: Secret clearance

Benefits

Comp & perks

Minimal travel required (less than 5%)
Remote work arrangement
Compressed Work Schedule (CWS) may be authorized
Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions