DoD BI Analyst — Secret Clearance, Power BI Dashboards

RedSky; Tampa (FL); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, life insurance

Tuition reimbursement

401K plan

Paid government holidays

Personal leave

Job summary

RedSky seeks a Business Intelligence Analyst (SECRET) to design, develop, deploy, and maintain BI solutions for USSOCOM leaders and KM staff. You will build Power BI dashboards and reports delivering real-time, role-based insight across HQ, components, and TSOCs.

You will gather requirements from non-technical stakeholders, translate questions into data models, and present findings with strong written and verbal communication. DoD experience preferred.

Qualifications

• - Active Secret clearance.
• - 4+ years experience in BI, data analytics, or reporting in a DoD or federal environment.
• - 4+ years proficiency in Power BI Desktop & Service; report/dashboard creation, data modeling, DAX, Power Query, workspace management, and refresh.
• - 4+ years designing star schema and dimensional models for analytical reporting.
• - 3+ years DAX proficiency: measures, calculated columns, time intelligence, iterators, context-transition.
• - 3+ years Power Query for data extraction, transformation, merging, pivoting/unpivoting, parameterized queries.
• - 3+ years connecting Power BI to SQL Server, SharePoint Online, Dataverse, Excel, REST APIs, OData feeds.
• - 3+ years gathering requirements from non-tech stakeholders and presenting findings to executives.
• - 3+ years excellent written and verbal communication.
• - CompTIA Security+ certification.

Responsibilities

• Design, develop, deploy, and maintain data visualization, reporting, and analytics solutions for USSOCOM leaders and KM professionals.
• Build Power BI dashboards, reports, and datasets delivering real-time, role-based insight across USSOCOM HQ, Components, and TSOCs.
• Ensure senior leaders have access to curated, accurate, visually compelling information to achieve decision superiority without manual data compilation.

Skills

Active Secret clearance

Power BI

DAX measures

Power Query

Star schema modelling

Time intelligence

Data modeling

SQL Server

SharePoint Online

Dataverse

Excel

REST APIs

OData feeds

Education

CompTIA Security+ certification

Tools

Power BI Desktop

Power BI Service

DAX

Power Query

SQL Server

SharePoint Online

Dataverse

Excel

REST APIs

OData

Job description

RedSky seeks a Business Intelligence Analyst (SECRET) to design, develop, deploy, and maintain BI solutions for USSOCOM leaders and KM staff. You will build Power BI dashboards and reports delivering real-time, role-based insight across HQ, components, and TSOCs.

You will gather requirements from non-technical stakeholders, translate questions into data models, and present findings with strong written and verbal communication. DoD experience preferred.