Air Force Data Analytics Specialist | SQL & Qlik Sense

Spectrum Comm Inc; Newport News (VA); In loco; USD 90.000 - 130.000; Tempo pieno

Descrizione del lavoro

Spectrum Comm Inc. is seeking a Data Analyst to collect, validate, and transform supplier and company data for USAF decision support. You will build dashboards in Qlik Sense and maintain Azure-hosted SQL Server data stores.

The role requires strong SQL, Python (Pandas), Excel expertise, and the ability to briefing leadership with actionable insights, while ensuring DoD policy compliance. 5+ years of experience and an active DoD Secret clearance are expected.

Competenze

• Experience supporting DoD or USAF organizations, knowledge of supplier or supply chain data management.
• Proficiency in Qlik Sense or another similar BI tool like Power BI or Tableau, alongside experience with Excel, SQL (DB management) Python (Pandas, data automation).
• Familiarity with cloud-based data environments (Microsoft Azure).
• Experience briefing leadership and presenting findings, as well as implementing and exploring strategies to improve capability.
• 5+ years of relevant experience.
• ACTIVE DoD Secret Clearance required.
• Bachelor's Degree preferred but experience may be used in lieu of degree.

Mansioni

• Work with stakeholders to improve and implement air force acquisition data/analysis capability.
• Develop and maintain dashboards and analytical applications using Qlik Sense.
• Collect, clean, and validate supplier and company data from multiple sources.
• Maintain and manage structured data sets to ensure data accuracy and integrity.
• Develop and maintain SQL queries, stored procedures, and database objects.
• Administer and manage a small Microsoft Azure hosted SQL Server environment.
• Perform advanced data analysis using Microsoft Excel (pivot tables, Power Query, formulas, automation).
• General Data manipulation, automation, and exploratory analysis.
• Generate recurring and ad hoc reports to support operational and strategic decisions.
• Identify data discrepancies and implement corrective actions.
• Collaborate with stakeholders to define reporting requirements and deliver actionable insights.
• Ensure compliance with USAF and DoD policies.

Conoscenze

Data modeling

Data analysis

Reporting

Visualization

SQL

Python

Excel

Automation

Data cleaning

Stakeholder communication

Formazione

Bachelor's Degree

Strumenti

Qlik Sense

Power BI

Tableau

Azure SQL Database

Descrizione del lavoro

Spectrum Comm Inc. is seeking a Data Analyst to collect, validate, and transform supplier and company data for USAF decision support. You will build dashboards in Qlik Sense and maintain Azure-hosted SQL Server data stores.

The role requires strong SQL, Python (Pandas), Excel expertise, and the ability to briefing leadership with actionable insights, while ensuring DoD policy compliance. 5+ years of experience and an active DoD Secret clearance are expected.