Spectrum Comm Inc
Mission focused | Delivering Exceptional Solutions | Operations and Digital Support | Management Consulting
Data Analyst
Location
District of Columbia + 1 moreAll locations: District of Columbia, Virginia
Posted
13 days ago
Salary
Not specified
Bachelor Degree5 yrs expExperience acceptedEnglishAzureCloudPandasPythonSQLTableau
Job Description
• 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.
Job Requirements
- Experience supporting DoD or USAF organizations, knowledge of supplier or supply chain data management.
- Proficiency in Qlik Sense or another similar Business intelligence 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.
- Must have an ACTIVE DoD Secret Clearance
- Bachelor's Degree preferred but expereince may be used in lieu of degree.