4+ years of experience in business intelligence or data analytics within DoD or federal government
Proficient in Power BI Desktop and Service, including report creation and data modeling
Experience designing star schema and dimensional data models
3+ years of proficiency in DAX for advanced calculations
3+ years of experience with Power Query for data transformation
Ability to gather requirements from non-technical stakeholders and present findings effectively
CompTIA Security+ certification preferred
Responsibilities
Design and develop data visualization and analytics solutions for USSOCOM
Build Power BI dashboards and reports for real-time insights
Ensure accurate and visually compelling information delivery to decision-makers
Serve as a bridge between operational data and leadership
Facilitate immediate access to curated data for senior leaders and program managers
Translate operational questions into actionable data models and visualizations
Communicate complex data concepts to diverse audiences
Benefits
Collaborative work environment
Opportunity to support critical defense operations
Engagement with senior military leaders
Professional development opportunities
Work with cutting-edge data visualization tools
Full Job Description
ITility is seeking a highly skilled Business Intelligence Analyst to join our team in support of Department of Defense.
Responsibilities:
The Business Intelligence Analyst is to design, develop, deploy, and maintain data visualization, reporting, and analytics solutions that transform raw data into actionable intelligence for United States Special Operations Command (USSOCOM) leaders, staff, and knowledge management professionals. This position serves as the bridge between operational data and decision-makers - building Power BI dashboards, reports, and datasets that deliver real-time, role-based insight across USSOCOM Headquarters, its Components, and Theater Special Operations Commands (TSOCs). The BI Analyst ensures that senior leaders, program managers, KM officers, and operational staff at every echelon have immediate access to the curated, accurate, and visually compelling information they need to achieve decision superiority without manual data compilation or "hand jam."
Required Skills/Qualifications:
Active Secret clearance
Four (4+) years of business intelligence, data analytics, or reporting experience in a Department of Defense (DoD) or federal government environment
Four (4+) years demonstrated proficiency in Power BI Desktop and Power BI Service - report and dashboard creation, data modeling, DAX measures, Power Query transformations, workspace management, and scheduled refresh configuration.
Four (4+) years experience designing star schema and dimensional data models for analytical reporting. Understanding of fact tables, dimension tables, relationships, cardinality, and filter context.
Three (3+) years of demonstrated proficiency in DAX - ability to write measures, calculated columns, time intelligence functions, iterator functions, and context-transition expressions.
Three (3+) years of demonstrated proficiency in Power Query for data extraction, transformation, merging, appending, pivoting/unpivoting, and parameterized queries.
Three (3+) years of pragmatic experience connecting Power BI to multiple data source types - SQL Server, SharePoint Online, Dataverse, Excel, REST APIs, and OData feeds.
Three (3+) years of demonstrated ability to gather requirements from non-technical stakeholders, translate operational questions into data models and visualizations, and present findings to senior leaders
Three (3+) years of displayed experience of excellent written and verbal communication skills. Ability to explain data concepts, metrics, and dashboard insights to audiences ranging from analysts to general officers
CompTIA Security+ certification
Work Environment:
Ability to sit or stand for extended periods and perform computer-based work using standard office equipment.
Requires frequent verbal communication, active listening, and visual acuity to perform job responsibilities effectively.
Must follow site-specific safety, security, and dress standards.
