Data Analyst

Saliense; San Antonio (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

PTO & Sick Time

Holidays

Health Insurance

401(k)

Parental Leave

Dev Reimbursement

Job summary

Saliense seeks a data analyst to support DoD logistics and finance operations, leveraging DMLSS expertise and advanced Excel/Power Query skills. The role focuses on data extraction, transformation, and modeling to enable accurate reporting for AFWCF audits and financial compliance.

The candidate will build scalable dashboards and data workflows, ensuring traceability and data integrity across multiple DoD legacy systems.

Qualifications

• Demonstrated advanced DMLSS expertise.
• Proficiency in Microsoft Excel (advanced array functions, VBA).
• Power Query (M code) proficiency.
• Experience supporting DoD or Federal financial audits, specifically AFWCF.

Responsibilities

• Perform advanced extraction, querying, and analysis of logistics and supply chain data from DMLSS.
• Develop data models to track inventory, procurement, and readiness.
• Serve as SME for DMLSS data architecture and reporting capabilities.
• Provide analytics and evidentiary support for AFWCF audit and ensure audit readiness.

Skills

DMLSS

Excel VBA

Power Query

Audit support

Data modeling

SQL

Tools

Power BI

BCS

Job description

About Saliense

At Saliense, we are committed to fostering a culture of continuous learning and professional growth. Our employees are encouraged to take on challenging and meaningful work, with ample opportunities for career advancement. We offer competitive compensation and benefits, including:

• 20 Days PTO + 40 Hours of Paid Sick & Safe Time
• 11 Federal Holidays + 2 Corporate Holidays
• Health, Vision, Dental, and Life Insurance
• 401(k) with Tiered Match & 100% Vesting
• Parental Leave for Birthing and Non-Birthing Parents
• Professional Development Reimbursement Program

We believe in empowering our team members to achieve their professional goals while contributing to impactful projects that make a difference. Join us at Saliense and be part of a growing organization dedicated to innovation, collaboration, and excellence. Visit www.saliense.com to learn more.

There are many more - connect with us to get a preview of the full benefits package.

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 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.

This role requires an onsite presence 3 days a week in either Frederick, MD; Falls Church, VA; or San Antonio, TX.

What You’ll Do

• Defense Medical Logistics Standard Support (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.