Business Intelligence Analyst (SECRET)

Summary

Job Description Job Description

Position: Business Intelligence Analyst (SECRET)

Functional Labor Category: Enterprise Knowledge Management

Location: Tampa, Florida 33621; multiple locations domestic and international

Minimum Security Clearance:

RedSky is seeking a highly skilled Business Intelligence Analyst (SECRET) to join our team in support of Department of Defense. At RedSky, we pride ourselves on exceeding client expectations, and this role will be pivotal in driving our continued success. As a valued member of our collaborative and innovative team, you will contribute directly to our mission of delivering exceptional results.

We offer a comprehensive benefits package, including medical, dental, life insurance, and tuition reimbursement, along with additional perks such as a 401K plan, paid government holidays, and personal leave.

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

Job Description

Job Description Job Description

Position: Business Intelligence Analyst (SECRET)

Functional Labor Category: Enterprise Knowledge Management

Location: Tampa, Florida 33621; multiple locations domestic and international

Minimum Security Clearance:

RedSky is seeking a highly skilled Business Intelligence Analyst (SECRET) to join our team in support of Department of Defense. At RedSky, we pride ourselves on exceeding client expectations, and this role will be pivotal in driving our continued success. As a valued member of our collaborative and innovative team, you will contribute directly to our mission of delivering exceptional results.

We offer a comprehensive benefits package, including medical, dental, life insurance, and tuition reimbursement, along with additional perks such as a 401K plan, paid government holidays, and personal leave.

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