Data Analyst

TIAG; Frederick (MD); On-site; USD 90,000 - 130,000; Full time

Job summary

TIAG is seeking a Data Analyst to support the Defense Medical Logistics Standard Support Program. This role will join our team in analyzing logistics and supply chain data from DMLSS/LogiCole. Onsite at JBSA in San Antonio, TX, with up to 3 days per week in the office.

Eligibility requires US citizenship or naturalization and a government security clearance will be processed. Responsibilities include developing data models to track inventory and procurement, serving as SME for data architecture,

Qualifications

• 5+ years of data analysis and reports development using BI tools.
• 5+ years of DMLSS and JMAR experience.
• 4+ years of administration, oversight of centralized Medical Logistics policy.
• Proficiency with SAS BI, SQL, Tableau and Excel.

Responsibilities

• Develop data models to track inventory, procurement, and readiness.
• Serve as SME for DMLSS/LogiCole data architecture and reporting.
• Support AFWCF audit with evidentiary analytics and reproducible data.
• Design scalable dashboards for leadership with DoD data sources.

Skills

Data analysis

Data modeling

Dashboard design

Auditing support

Tools

SAS BI

SQL

Tableau

Microsoft Excel

Power Query

BCS (BI)

Job description

TIAG is now hiring a Data Analyst to support the Defense Medical Logistics Standard Support Program. This role will join our team supporting the execution of advanced extraction, querying, and analysis of logistics and supply chain data from DMLSS/LogiCole.This role reports onsite at Joint Base San Antonio (JBSA) in San Antonio, TX up to 3 days per week. US or Naturalized Citizenship is a requirement for consideration, as a government security clearance will be processed to start work.Responsibilities for the Data Analyst will include:Ability to formulate data models to track inventory, procurement, and operational readiness.Serve as the Subject Matter Expert (SME) for DMLSS/LogiCole data architecture and reporting capabilities.Air Force Working Capital Fund (AFWCF) Audit Support Responsibilities: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.General Data Engineering & Reporting Responsibilities:Utilize Microsoft Excel and Power Query to build automated, repeatable data transformation workflows.Merge and clean large, disparate datasets from multiple DoD legacy systems.Ability to design scalable reporting dashboards to provide actionable intelligence to leadership.5+ years data of data analysis and reports development, specifically using Business Intelligence Corporate Solutions (BCS) and editing SQL query language.5+ years of DMLSS and JMAR experience.5+ years of hands-on contingency materiel management and medical equipment maintenance and management experience with an additional emphasis of related reporting and analytics4+ years of administration, oversight, and advisement of centralized Medical Logistics policy and procedures.Proficiency with SAS BI, SQL, Tableau, and Microsoft Excel.Ability to report onsite 3 days a weekTIAG is an equal opportunity employer and federal contractor or subcontractor. Consequently, the parties agree that, as applicable, they will abide by the requirements of 41 CFR 60-1.4(a), 41 CFR 60-300.5(a), and 41 CFR 60-741.5(a) and employment decisions shall be based solely on merit and without regard disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations. TIAG takes proactive steps to employ and advance in employment qualified individuals without regard to disability or protected veteran status. The parties also agree that, as applicable, they will abide by the requirements and may be subject and required to take action pursuant to the following laws and accompanying regulations:The Vietnam Era Veterans Readjustment Assistance Act of 1974, as amended (and its implementing regulations at 41 C.F.R. 60-300);Section 503 of the Rehabilitation Act of 1973, as amended (and its implementing regulations at 41 C.F.R 60-741); andExecutive Order 13496 (and its implementing regulations at 29 C.F.R. part 471, Appendix A to Subpart A).