Data Analyst

Saliense • Frederick, MD

24d

About The Position

This role supports logistical and financial operations by extracting, transforming, and analyzing complex datasets. It requires advanced knowledge of Defense Medical Logistics Standard Support (DMLSS), expert-level Microsoft Excel and Power Query skills, and ongoing support for the congressionally mandated Air Force Working Capital Fund (AFWCF) audit. The position supports data accuracy, traceability, and compliance with financial reporting standards.

The analyst works with DMLSS logistics and supply-chain data, builds models to track inventory, procurement, and operational readiness, and serves as a subject matter expert on DMLSS data architecture and reporting. The role also provides analytics and evidence for the AFWCF audit, reconciles financial and logistics data for audit readiness and compliance with Financial Improvement and Audit Readiness (FIAR) directives, and responds to auditor inquiries with accurate, reproducible data models.

The position uses Excel and Power Query to create automated, repeatable data-transformation workflows; merges and cleans large datasets from multiple Department of Defense legacy systems; and designs scalable dashboards that provide actionable information to leadership.

Requirements

• Demonstrated advanced expertise in DMLSS.
• Deep proficiency in Microsoft Excel, including advanced array functions and VBA.
• Deep proficiency in Power Query, including M code.
• Proven experience supporting DoD or Federal financial audits, specifically AFWCF operations.
• Experience and working knowledge of DMLSS and the Joint Medical Asset Repository (JMAR).

Nice To Haves

• Experience migrating legacy Excel and Power Query models to advanced visualization tools such as Power BI.
• Knowledge of broader DoD logistics systems, such as LogiCole, as DMLSS transitions to newer enterprise platforms.
• Experience with Business Intelligence Central Services (BCS), including working knowledge of SQL for BCS ad hoc reporting.

Responsibilities

• Extract, query, and analyze logistics and supply-chain data from DMLSS.
• Formulate data models to track inventory, procurement, and operational readiness.
• Serve as the subject matter expert for DMLSS data architecture and reporting capabilities.
• Provide ongoing analytics and evidentiary support for the congressionally mandated AFWCF audit.
• Reconcile financial and logistical data to support continuous audit readiness and compliance with FIAR directives.
• Respond to auditor inquiries with accurate, timely, and reproducible data models.
• Use 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.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed