Power BI Specialist

Avid Core • Washington, DC

12d • $90,000 - $105,000 • Hybrid

About The Position

Do you enjoy turning complex data into clear, decision-ready dashboards? Are you highly experienced with Power BI and comfortable working in a federal client environment with established reporting requirements and security controls?
Avid Core is seeking a Power BI Specialist to support federal clients by designing, developing, and maintaining Power BI dashboards, reports, and data models. This role is intended for a hands-on Power BI professional who can work independently and deliver production-ready reporting solutions with minimal ramp-up.
This position will support clients such as U.S. Customs and Border Protection (CBP) and other federal agencies and will work closely with project managers, analysts, and client stakeholders.
To Apply: Submit resumes and cover letters through this posting.
Candidates from all backgrounds are welcome to apply for our open positions and to join our bench of talented professionals.

Requirements

• 3–5 years of hands-on experience developing dashboards and reports in Power BI
• Demonstrated experience with DAX, Power Query, and Power BI data modeling
• Ability to work independently and deliver complete Power BI solutions with minimal oversight
• Strong understanding of data visualization best practices
• Proficiency with Microsoft Office Suite, particularly Excel
• Strong written and verbal communication skills
• Ability to manage multiple reporting priorities and deadlines
• Existing CBP clearance or ability to obtain and maintain a Public Trust clearance required

Nice To Haves

• Experience delivering Power BI solutions in a federal or government-contracting environment strongly preferred
• Highly proficient in Power BI and focused on dashboard and report development
• Detail-oriented with strong quality-control instincts
• Comfortable working directly with client stakeholders
• Organized and able to manage multiple reporting deliverables
• Clear and professional in written and verbal communication
• Self-directed and reliable in deadline-driven environments
• Team-oriented and solutions-focused

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and visualizations for federal clients
• Translate client requirements and business questions into clear, actionable Power BI reporting solutions
• Build and optimize Power BI data models, including relationships, measures, and calculated columns
• Develop and maintain DAX measures and Power Query transformations
• Connect Power BI to approved data sources, including Excel, SharePoint, SQL-based systems, and other client-approved repositories
• Ensure dashboards follow best practices for usability, performance, and data accuracy
• Maintain and enhance existing Power BI reports and dashboards
• Conduct quality assurance reviews to ensure accuracy, consistency, and compliance with client requirements
• Support documentation of dashboards, data sources, assumptions, and calculations
• Collaborate with project managers and stakeholders to prioritize reporting needs and updates
• Support ad-hoc reporting requests and data visualizations as needed
• Ensure compliance with federal data handling, security, and access requirements
• Participate in client meetings to discuss reporting needs, enhancements, and findings
• Provide limited guidance or knowledge-sharing to team members on Power BI usage and best practices
• Other duties as assigned

Benefits

• Comprehensive health insurance
• Vision, dental, and short-term and long-term disability
• 401K with employer match (after six months of employment)
• Federal and non-federal paid holidays
• Flexible paid time off
• Generous bonus program based on firm and individual performance
• An opportunity to learn and grow in an inclusive and supportive environment with a fun team

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level