Hive Group, a HUBZone-certified SDVOSB and multiple award-winning organization, delivers innovative solutions to address complex, mission-critical program challenges for the federal government. We are seeking a Power BI Analyst / Associate to support the development, implementation, and maintenance of the current DIVE application built using Power BI. In this role, you will play a critical part in delivering impactful data insights, performance reports, dynamic visualizations, and executive dashboards across multiple Transportation Safety Administration (TSA) Deployment and Sustainment Division (DSD) projects. You will integrate data from diverse sources—including Microsoft Excel, Access, and Project—to convert complex data into actionable solutions for leadership and key stakeholders.
Location: Primary Government Site: TSA Systems Integration Facility (TSIF)
Address: 3701 Post Office Road, Arlington, VA
Telework Policy: Off-site telework may be permitted based on current TSA telework policies, TSA approval, and space availability.
Key Responsibilities- Application Maintenance & Development: Lead all aspects of development, optimization, and maintenance for the Power BI-based DIVE application.
- Data Integration: Extract, transform, and integrate data across multiple disparate sources including Microsoft Excel, Access Databases, MS Project, and internal SharePoint/iShare repositories.
- Dashboards & Reporting: Design, build, and maintain executive-level dashboards, interactive visualizations, and performance metrics reports across DSD initiatives.
- Requirements Gathering: Collaborate with diverse stakeholders to capture analytical business requirements and translate them into robust technical reporting solutions.
- Cross-Functional Collaboration: Partner with deployment teams, project leads, and program stakeholders to ensure alignment on metrics and reporting objectives.
- Documentation & Governance: Maintain data documentation, dashboard governance, and reporting protocols in accordance with program standards.
- Experience: 3–5 years of professional experience in data analysis, business intelligence (BI), or reporting roles.
- Technical Mastery: High proficiency in Power BI development, DAX, data modeling, and visualization best practices.
- Data Sources: Proven capability connecting, querying, and transforming data from Microsoft Excel, MS Access Databases, and Microsoft Project.
- M365 Ecosystem: Expertise in Microsoft 365 tools, including Excel, Project, Word, iShare/SharePoint, Teams, OneDrive, and Access.
- Stakeholder Engagement: Strong ability to interface with non-technical stakeholders, gather complex business requirements, and deliver technical solutions.
- Communication: Excellent verbal and written communication skills with strong cross-functional collaboration abilities.
- Certification: Official Power BI Certification (e.g., Microsoft Certified: Data Analyst Associate / PL-300) preferred or at the discretion of the Contracting Officer's Representative (COR).
- Experience working within the federal government environment/DHS/TSA preferred.
- Must be able to obtain and maintain a TSA Fitness Determination / Public Trust Clearance prior to starting work.
- U.S. Citizenship or lawful permanent residency required per DHS/TSA suitability guidelines
Skills Required
- 3-5 years of professional experience in data analysis, business intelligence, or reporting roles
- High proficiency in Power BI development, DAX, data modeling, and visualization best practices
- Experience connecting, querying, and transforming data from Microsoft Excel, Microsoft Access Databases, and Microsoft Project
- Expertise in Microsoft 365 tools, including Excel, Project, Word, iShare/SharePoint, Teams, OneDrive, and Access
- Ability to interface with non-technical stakeholders, gather business requirements, and deliver technical solutions
- Excellent verbal and written communication skills with strong cross-functional collaboration abilities
- Official Power BI certification, such as Microsoft Certified: Data Analyst Associate or PL-300
- Experience working within the federal government, DHS, or TSA environment
- Must be able to obtain and maintain a TSA Fitness Determination / Public Trust Clearance before starting work
- U.S. citizenship or lawful permanent residency per DHS/TSA suitability guidelines
What We Do
Hive Group, an SDVOSB, is a high-energy management consulting company, founded in 2018, with its mission to provide innovative and creative management solutions to achieve federal agencies business operations needs. Our consultants specialize in acquisition solutions, strategic and organizational planning and analysis, governance structures, communication strategies, program management processes, financial analysis and data analytics. Hive is led by seasoned govcon professionals, Kathleen Sober and Will Fortier, with backgrounds supporting federal, defense and intelligence agencies.
