Data Analyst; SME

Key Responsibilities

• Data Engineering & ETL:
  Analyze, plan, and develop custom SQL scripts, packages, and stored procedures. Execute ETL processes to integrate Contract Data Requirements List (CDRL) and Army Vantage data files into the Fixed Wing data warehouse.
• Business Intelligence:
  Design and maintain custom Power BI dashboards and paginated reports to monitor performance-based logistics and fleet readiness. Manage periodic report subscriptions for leadership.
• Data Integrity:
  Perform regular data cleansing and validation on data warehouse tables to ensure high-quality reporting and analysis.
• Application Development:
  Develop and revise low-code solutions using Power Apps and Power Automate to streamline project office workflows.
• Collaboration Infrastructure:
  Manage and maintain Microsoft Teams channels and SharePoint sites for the Logistics Division to ensure seamless information sharing.
• Advisory:
  Provide expert technical guidance to the Division Chief regarding data-driven fleet management and readiness strategies.

• Requires a Bachelor’s degree and 9 years of experience.
• US Citizenship with an active Secret clearance.
• Certification:
  Active CompTIA Security+ certification.
• Technical Proficiency:
  Demonstrated experience with:
• Microsoft SQL Server Management Studio (SSMS) & Data Tools (SSDT).
• Microsoft Power BI Desktop & Power BI Report Builder.
• Microsoft Power Platform (Power Apps, Power Automate).
• Microsoft 365 Apps for Enterprise.

• Background in Army logistics or aviation fleet management.
• Experience handling Army Vantage or large-scale military data sets.
• Strong understanding of performance-based logistics (PBL) metrics.

EOE/Minorities/Females/Vet/Disabled