Data Analyst

Saliense

Frederick (MD)

On-site

USD 90,000 - 125,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Saliense is seeking a data analyst to support crucial DoD logistics and financial operations. You will leverage DMLSS expertise along with advanced Excel and Power Query skills to extract, transform, and analyze complex datasets and ensure audit readiness for the AFWCF.

You will build data models, dashboards, and repeatable workflows that enable leadership to monitor inventory, procurement, and operational readiness while maintaining traceability and compliance with FIAR directives.

Qualifications

  • Must have working knowledge of Defense Medical Logistics Standard Support (DMLSS) and Joint Medical Asset Repository (JMAR).
  • Experience supporting DoD or Federal financial audits, specifically AFWCF operations.

Responsibilities

  • Execute advanced extraction, querying, and analysis of logistics data from DMLSS.
  • Formulate data models to track inventory, procurement, and operational readiness.
  • Provide ongoing analytics for the AFWCF audit and ensure FIAR alignment.
  • Develop automated Excel/Power Query workflows and scalable dashboards for leadership.

Skills

DMLSS proficiency
Advanced Excel
Power Query (M code)
VBA
DoD/AFWCF audits

Tools

DMLSS
Power BI
JMAR

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).
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst (DMLSS)
Data Analyst (DMLSS)

Saliense • Frederick (MD)

On-site
USD 80,000 - 90,000
20 Days PTO + 40 Hours of Paid Sick &
Health, Vision, Dental, and Life보험
401(k) with Tiered Match & 100% Vest
+2
DMLSS Data Analyst & Audit Readiness Specialist
DMLSS Data Analyst & Audit Readiness Specialist

Saliense • Frederick (MD)

On-site
USD 90,000 - 125,000
DMLSS Data Analyst: Audit-Ready Analytics & Reporting
DMLSS Data Analyst: Audit-Ready Analytics & Reporting

Saliense • Frederick (MD)

On-site
USD 80,000 - 90,000
20 Days PTO + 40 Hours of Paid Sick &
Health, Vision, Dental, and Life보험
401(k) with Tiered Match & 100% Vest
+2
Data Analyst
Data Analyst

Spectrum Comm Inc • Newport News (VA)

On-site
USD 90,000 - 120,000
Data Analyst
Data Analyst

Spectrum Comm Inc • Arlington (VA)

On-site
USD 110,000 - 150,000
Data Engineer
Data Engineer

KeyLogic Systems • United States

Remote
USD 140,000 - 170,000
Health insurance
Data Engineer - Remote
Data Engineer - Remote

LDSS Corp • Bath Township (OH)

Remote
USD 120,000 - 130,000
401(k)
Dental insurance
Health insurance
+3
Data Analyst Level II
Data Analyst Level II

SSC • Frederick (MD)

On-site
USD 87,000 - 95,000
Data Engineer
Data Engineer

CSA Global LLC • Norfolk (VA)

On-site
USD 90,000 - 140,000
Data Analyst, Business Intelligence and Application Support Analyst
Data Analyst, Business Intelligence and Application Support Analyst

DCS Corporation • Ridgecrest (CA)

On-site
USD 70,000 - 81,000