Data Analyst / Dashboard Developer (Secret Clearance)

The Data Analyst / Dashboard Developer will design, implement, and maintain a live Performance Dashboard with automated data integration to support ACC leadership. This onsite role in Hampton, VA requires a Secret clearance and the ability to obtain TS/SCI.

Responsibilities

• Build and deploy the live Performance Dashboard within 60 days of contract award on Power BI hosted on FedRAMP authorized or DAF365 platforms
• 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
• 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
• 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
• Generate comprehensive Quarterly Performance Brief data packages for PM and COR review 5+ business days before scheduled briefs
• Produce executive summary slides showing KPI trends, QASP standard compliance, and performance variance analysis
• Develop drill-down appendices with wing-level breakouts, directorate comparisons, and time-series trend charts
• Coordinate with the Stakeholder Engagement & KM Specialist to package metrics into governance-ready narratives
• Prepare data visualizations optimized for executive audiences (clear, concise, actionable)
• Document all data sources, assumptions, and calculation methods for COR transparency
• Conduct monthly service desk trend analysis identifying Top 10 recurring issue categories requiring knowledge base articles or training updates
• Response and resolution time performance against QAP standards
• Ticket volume trends by wing, directorate, and platform
• Knowledge gaps indicating curriculum deficiencies
• Platform issues requiring vendor escalation or technical advisory engagement
• Deliver service desk analysis reports to the Deputy PM within 5 business days of each month close
• Track time from knowledge gap identification to updated training deployment as a mandatory KPI
• Measure knowledge base utilization impact on ticket volume reduction over time
• Analyze token and license utilization patterns to identify underutilized allocations suitable for reallocation
• Analyze token and license utilization patterns to identify high-demand wings requiring additional resource allocation
• Analyze token and license utilization patterns to identify cost-sharing opportunities across participating wings
• Analyze token and license utilization patterns to identify compliance gaps where users received tokens without completing training
• Generate monthly utilization reports for the Token/Resource Administrator showing allocation efficiency and compliance status
• Produce cost-per-user and cost-per-wing analytics supporting ACC budget planning
• Forecast future resource requirements based on training completion trends and wing expansion plans
• Respond to ad hoc data requests from the PM, COR, and functional leads within 2 business days
• Conduct root cause analysis when KPIs fall below QASP thresholds, identifying contributing factors and corrective action recommendations
• Support RAID log population with data-driven risk assessments and impact quantification
• Perform comparative analyses across wings to identify best practices and adoption barriers
• Develop predictive models forecasting training completion rates, token demand, and workflow development throughput
• Dashboard operational within 60 days of contract award with all six PWS KPI categories integrated
• Daily data refresh cycles maintained with 99% plus uptime (excluding planned maintenance)
• Quarterly performance brief data packages delivered 5+ business days before scheduled briefs with zero data accuracy issues requiring correction
• Monthly service desk trend analysis delivered within 5 business days of month close
• Ad hoc analysis requests completed within 2 business days of PM/COR request
• Data quality audits conducted quarterly with findings documented and corrective actions implemented within 10 days

Technologies

• Power BI
• Power Automate
• Microsoft Excel (Power Query, Power Pivot, DAX)
• SQL
• DAF365
• SharePoint
• LMS
• TLMS

Schedule and Availability

• Core Hours: 0800-1700 EST, Monday-Friday
• Flexibility: Occasional early morning or evening meetings to accommodate wing schedules across time zones
• Surge Periods: Increased hours during major milestones, events, or exercises with advance notice

Security Environment

• Work with classified information up to Top Secret/SCI level
• Compliance with OPSEC, CUI handling, and classification protocols
• Subject to security inspections, audits, and continuous evaluation
• Adherence to base access, badge, and facility security requirements

Performance Expectations

• Dashboard operational within 60 days of contract award with all six PWS KPI categories integrated
• Daily data refresh cycles maintained with 99% plus uptime (excluding planned maintenance)
• Quarterly performance brief data packages delivered 5+ business days before scheduled briefs with zero data accuracy issues requiring correction
• Monthly service desk trend analysis delivered within 5 business days of month close
• Ad hoc analysis requests completed within 2 business days of PM/COR request
• Data quality audits conducted quarterly with findings documented and corrective actions implemented within 10 days