Data Analyst/Dashboard Developer

About the role

Koniag IT Systems LLC, a Koniag Government Services company, is seeking a Data Analyst/Dashboard Developer with an active Secret security clearance (must upgrade to TS/SCI) to support KITS and our government customer at Langley Air Force Base, VA. This position is onsite. We offer competitive compensation and an extraordinary benefits package including health, dental and vision insurance, 401K with company matching, flexible spending accounts, paid holidays, three weeks paid time off, and more.

Responsibilities

• Build and deploy the live Performance Dashboard within 60 days of contract award on Power BI hosted on FedRAMP-authorized or DAF365 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
• 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 to feed the training feedback loop
• 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 High-demand wings requiring additional resource allocation Cost-sharing opportunities across participating wings 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
• Develop predictive models forecasting training completion rates, token demand, and workflow development throughput

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
• 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 DAF365 and SharePoint environments – Strongly Preferred
• Familiarity with Power Automate for workflow automation and data pipeline orchestration
• 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

Skills

• Power BI / Power Automate proficiency
• Advanced proficiency with Microsoft Excel
• SQL query writing
• DAF365 and SharePoint environments
• Power Automate for workflow automation and data pipeline orchestration

Benefits

We offer a competitive compensation and an extraordinary benefits package including health, dental and vision insurance, 401K with company matching, flexible spending accounts, paid holidays, three weeks paid time off, and more.

Pay

Competitive compensation package.

Schedule

Core Hours: 0800-1700 EST, Monday-Friday), with occasional extended hours to meet mission deadlines or support operational events

On-Call

No telework eligibility for unclassified administrative tasks; all classified work must be performed on-site in approved facilities

Security Environment

Work with classified information up to Top Secret/SCI levelCompliance with OPSEC, CUI handling, and classification protocolsSubject to security inspections, audits, and continuous evaluationAdherence to base access, badge, and facility security requirements

Equal Employment Opportunity

The company is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race, color, religion, creed, ethnicity, sex, sexual orientation, gender or gender identity (except where gender is a bona fide occupational qualification), national origin or ancestry, age, disability, citizenship, military/veteran status, marital status, genetic information or any other characteristic protected by applicable federal, state, or local law. We are committed to equal employment opportunity in all decisions related to employment, promotion, wages, benefits, and all other privileges, terms, and conditions of employment. The company is dedicated to seeking all qualified applicants. If you require an accommodation to navigate or apply for a position on our website, please get in touch with Heaven Wood via e-mail at accommodations@koniag-gs.com or by calling 703-488-9377 to request accommodations.

Shareholder Preference

Our Equal Employment Opportunity Policy The company is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race, color, religion, creed, ethnicity, sex, sexual orientation, gender or gender identity (except where gender is a bona fide occupational qualification), national origin or ancestry, age, disability, citizenship, military/veteran status, marital status, genetic information or any other characteristic protected by applicable federal, state, or local law. We are committed to equal employment opportunity in all decisions related to employment, promotion, wages, benefits, and all other privileges, terms, and conditions of employment. The company is dedicated to seeking all qualified applicants. If you require an accommodation to navigate or apply for a position on our website, please get in touch with Heaven Wood via e-mail at accommodations@koniag-gs.com or by calling 703-488-9377 to request accommodations. Koniag Government Services (KGS) is an Alaska Native Owned corporation supporting the values and traditions of our native communities through an agile employee and corporate culture that delivers Enterprise Solutions, Professional Services and Operational Management to Federal Government Agencies. As a wholly owned subsidiary of Koniag, we apply our proven commercial solutions to a deep knowledge of Defense and Civilian missions to provide forward leaning technical, professional, and operational solutions. KGS enables successful mission outcomes for our customers through solution-oriented business partnerships and a commitment to exceptional service delivery. We ensure long-term success with a continuous improvement approach while balancing the collective interests of our customers, employees, and native communities. For more information, please visit www.koniag-gs.com. Equal Opportunity Employer/Veterans/Disabled. Shareholder Preference in accordance with Public Law 88-352.