5-7 years of experience in data analysis, specifically within logistics and financial operations.
Advanced knowledge of Defense Medical Logistics Standard Support (DMLSS).
Expert-level proficiency in Microsoft Excel, including advanced array functions and VBA.
Strong skills in Power Query (M code) for data transformation.
Experience supporting Department of Defense (DoD) or Federal financial audits, particularly AFWCF operations.
Responsibilities
Execute advanced extraction and analysis of logistics data from DMLSS.
Formulate data models to track inventory and operational readiness.
Serve as the Subject Matter Expert (SME) for DMLSS data architecture.
Provide analytics support for the AFWCF audit, ensuring compliance with financial standards.
Reconcile financial and logistical data for continuous audit readiness.
Utilize Microsoft Excel and Power Query to build automated data workflows.
Design scalable reporting dashboards for leadership insights.
Benefits
Opportunity to work on critical defense logistics and financial operations.
Engagement in high-impact projects supporting national audit compliance.
Access to advanced data tools and technologies.
Collaboration with a team of experts in the field.
Potential for professional growth within the Department of Defense.
Full Job Description
About the role
This role serves as a critical data analyst supporting logistical and financial operations. The primary responsibility is to leverage advanced knowledge of Defense Medical Logistics Standard Support (DMLSS) and expert-level Microsoft Excel and Power Query skills to extract, transform, and analyze complex datasets. A key operational requirement for this position is providing ongoing, rigorous support for the congressionally mandated AFWCF audit, ensuring data accuracy, traceability, and compliance with financial reporting standards.
What you'll do
DMLSS Operations:
Execute advanced extraction, querying, and analysis of logistics and supply chain data from DMLSS.
Formulate data models to track inventory, procurement, and operational readiness.
Serve as the Subject Matter Expert (SME) for DMLSS data architecture and reporting capabilities.
Air Force Working Capital Fund (AFWCF) Audit Support:
Provide ongoing analytics and evidentiary support for the congressionally mandated AFWCF audit.
Reconcile financial and logistical data to ensure continuous audit readiness and compliance with FIAR (Financial Improvement and Audit Readiness) directives.
Respond to auditor inquiries with accurate, timely, and reproducible data models.
Data Engineering & Reporting:
Expert-level utilization of Microsoft Excel and Power Query to build automated, repeatable data transformation workflows.
Merge and clean large, disparate datasets from multiple DoD legacy systems.
Design scalable reporting dashboards to provide actionable intelligence to leadership.
Required Experience:
Demonstrated advanced expertise in DMLSS.
Deep proficiency in Microsoft Excel (advanced array functions, VBA) and Power Query (M code).
Proven experience supporting DoD or Federal financial audits, specifically AFWCF operations.
Preferred Skills:
Experience migrating legacy Excel/Power Query models to advanced visualization tools (e.g., Power BI).
Knowledge of broader DoD logistics systems (e.g., LogiCole) as DMLSS transitions to newer enterprise platforms.
Experience with Business Intelligence Central Services (BCS) to include a working knowledge of SQL specifically related to BCS ad hoc reporting.
Qualifications
Must have experience and working knowledge of Defense Medical Logistics Standard Support (DMLSS) & Joint Medical Asset Repository (JMAR).
Salary Range: $80,000-90,000
The salary range listed for this position is based on multiple factors, including relevant years of experience, education, certifications, specialized skills, security clearance level, and overall alignment with the role's requirements. The final compensation offered may vary based on the candidate's qualifications and experience.
