Data Analyst​/Dashboard Developer; Secret Clearance

Data Analyst/Dashboard Developer

The Data Analyst / Dashboard Developer builds, maintains, and continuously improves the live Performance Dashboard that serves as the authoritative source for all contract performance data. Integrate data feeds from training systems, token management platforms, help desk operations, and workflow development pipelines into a unified dashboard accessible to the Contracting Officer's Representative (COR) and ACC leadership without requiring manual reports from the Program Manager.

This is not a periodic reporting role. Build a real-time performance intelligence system that enables proactive decision-making, identifies emerging risks before they become performance failures, and demonstrates mission value through documented metrics. Works directly determines whether ACC leadership trusts the data they see—or whether they question every number.

Required Qualifications:

• 3+ years of DoD or federal government data analytics and dashboard development experience
• Proven track record building executive-level dashboards with automated data integration from multiple source systems
• Experience supporting performance-based contracts with KPI-driven QASP surveillance
• Familiarity with DoD data governance, security classification, and PII handling requirements
• CompTIA Security+ (DoD 8140.03 baseline) – Required

Technical Proficiency (Required):

• Power BI/ Power Automate proficiency – Required (must have hands-on experience building dashboards with automated data refresh, calculated fields, and drill-down capabilities)
• Advanced proficiency with Microsoft Excel (Power Query, Power Pivot, DAX formulas, pivot tables, advanced charting)
• SQL query writing for data extraction and transformation
• Experience with DAF
  365 and SharePoint environments – Strongly Preferred
• Familiarity with Power Automate for workflow automation and data pipeline orchestration

Analytical

Competencies:

• Strong statistical analysis and data visualization skills
• Ability to translate complex data into executive-level narratives and actionable insights
• Understanding of performance measurement frameworks (KPIs, OKRs, Balanced Scorecard)
• Experience with trend analysis, variance analysis, and predictive modeling
• Attention to detail in data validation and quality assurance

Essential Job Functions:

Live Performance Dashboard Development & Maintenance:

• Build and deploy the live Performance Dashboard within 60 days of contract award on Power BI hosted on FedRAMP-authorized or DAF
  365 platforms
• Integrate data feeds from multiple source systems including:
• Token and License Management System (TLMS) – token allocation, utilization, compliance status by wing and directorate
• Learning Management System (LMS) – training completions, assessment scores, proficiency tracking
• Help Desk Ticketing System – response times, resolution rates, recurring issue categories
• Integrated Master Schedule (IMS) – task completion, schedule performance, milestone tracking
• Workflow Development Pipeline – prototype status, transition timelines, ROI documentation
• Ensure dashboard displays all six PWS-required KPI categories:
• Training completions prior to access grant
• Token and license utilization by wing and directorate
• AI and RPA workflow development and transition status
• Help desk response and resolution rates
• Travel execution against approved wing visit schedules
• Quarterly performance trends and year-over-year comparisons

Data Integration & Quality Assurance:

• Establish automated data pipelines from source systems to the dashboard with daily refresh cycles (or more frequent where technically feasible)
• Validate data accuracy through cross-referencing with source system reports and manual audits
• Identify and resolve data quality issues including missing records, duplicate entries, and classification mismatches
• Coordinate with the Token/Resource Administrator, Help Desk Analysts, and Program Analyst to ensure source data integrity
• Document all data transformation logic, calculation methodologies, and business rules in technical specifications
• Maintain a data dictionary defining every metric, dimension, and KPI displayed on the dashboard

Quarterly Performance Brief Data Packages:

• Generate…