Integrated Master Schedule Data Jobs

1 job found

7d ago

Data Analyst / Dashboard Developer (Secret Clearance)

System One Hampton, VA

Hampton, VA

7d ago

Full time Analyst Analytical Skills Analytics

Apply Now

Job Description

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

View full job page →

Get Integrated Master Schedule Data Jobs alerts

New Integrated Master Schedule Data Jobs, daily.