Power BI Specialist

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. Applications without a cover letter will not be considered. Candidates from all backgrounds are welcome to apply for our open positions and to join our bench of talented professionals. Salary Range: $90,000 - $105,000, based on experience and qualifications. Overall 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 Qualifications/Skills: 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 Experience delivering Power BI solutions in a federal or government-contracting environment strongly preferred 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 We're looking for someone who is: 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 Education: Bachelor's degree in Business, Information Systems, Data Analytics, or a related field preferred, or an equivalent combination of education and experience 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 Location: The position is based in Washington, D.C. Candidates will be expected to work a hybrid work schedule with time both in office and remote. Candidates will be provided with a computer; however, they must have a steady internet connection and a phone. Accommodation: Avid Core is committed to the full inclusion of all qualified individuals. As part of this commitment, we provide reasonable accommodation as needed. Contact careers@ to request an accommodation to participate in the job application and/or interview process. Avid Core is an award-winning small woman-owned business headquartered in Northern Virginia with employees throughout the Washington, D.C. metro area. We provide effective professional services and communications support to public and private sector clients. Avid Core is an equal-opportunity employer and operates a drug-free workplace.

Created: 2026-03-10