Business Intelligence Analyst

ITility is seeking a highly skilled Business Intelligence Analyst to join our team in support of Department of Defense.

At ITility, we help our customers command the future by thinking beyond perceived limits to create new, unexpected ways to protect and defend our nation. We inspire and empower people to create significant solutions that secure what matters to our customers and communities, here and around the globe.

We Value:

• The Drive to Perform Beyond Perceived Limits.
• The Desire to Find Significance in All We Do.
• The Passion and Compassion That Powers Both, 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.”

• 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.