This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Power BI Analyst based in United States.
This role offers the opportunity to turn complex program and project data into clear, actionable insights that support critical federal missions.
You will partner with program managers, integrated project teams, and executive stakeholders to translate business needs into effective reporting solutions.
The position focuses on developing sophisticated Power BI dashboards, scorecards, data models, and performance metrics across cost, schedule, quality, risk, and technical performance.
You will work with large, multi-source datasets, improving data quality while identifying trends, anomalies, and opportunities for better decision-making.
The role also provides significant scope for automation using Power BI, Power Query, Power Automate, Excel, SQL, and related technologies.
As part of a collaborative and mission-focused environment, you will help modernize reporting practices and improve transparency across programs and portfolios.
Your work will directly contribute to technology-enabled solutions supporting important U.S. government operations and national missions.
Accountabilities
- Partner with integrated project teams, program managers, and executive stakeholders to gather reporting requirements and translate business needs into actionable Power BI dashboards, reports, scorecards, and performance metrics.
- Compile, integrate, clean, transform, and analyze large datasets from multiple systems and platforms to support project, program, and portfolio reporting.
- Design, develop, enhance, and maintain Power BI dashboards and data models covering cost, schedule, technical performance, quality, risks, issues, and overall program health.
- Develop data transformation logic using Power Query, SQL, Excel, and other approved technologies to prepare data for reporting and analysis.
- Build and optimize Power BI data models, measures, calculated columns, KPIs, and formulas using DAX.
- Configure, monitor, and troubleshoot scheduled data refreshes within Power BI Service and other approved reporting environments.
- Prepare executive dashboards, briefing materials, performance measures, and other reporting products that support strategic decisions and management actions.
- Analyze program and project performance data to identify trends, anomalies, recurring issues, and areas requiring leadership attention.
- Improve data quality by identifying inconsistencies, gaps, duplicate records, validation issues, and discrepancies across source systems and reporting products.
- Recommend visualization approaches that improve reporting transparency, usability, accessibility, and decision support.
- Identify opportunities to automate recurring reports, manual data manipulation, and business processes using Power BI, Power Query, Power Automate, Excel, and related tools.
- Test, validate, and document dashboard logic, data sources, calculations, business rules, and data refresh processes.
- Troubleshoot and resolve issues involving reports, dashboards, data models, user access, and data refreshes.
- Maintain reporting solutions in accordance with applicable data governance, records management, cybersecurity, privacy, and organizational requirements.
Requirements
- Bachelor’s degree required; a degree in Computer Science, Engineering, Data Science, Operations Research, Industrial Engineering, Mathematics, or a related discipline is preferred.
- 3–5+ years of relevant professional experience required, with 5–7+ years preferred.
- Advanced proficiency in Microsoft Power BI, Tableau, Qlik, or comparable business intelligence platforms, including dashboard, workbook, database, and visualization development.
- Demonstrated experience using data analytics to support business decisions and developing engaging dashboards and balanced scorecards that communicate organizational performance.
- Strong experience building, cleaning, transforming, and integrating databases and datasets from multiple sources, including cost and performance information.
- Experience developing queries for recurring data requests, reports, and analytical needs.
- Experience with statistical analysis, data visualization, formulas, and performance metrics.
- Hands-on experience with Power Query and preferably DAX for developing and optimizing Power BI dashboards and data models.
- Experience with SQL is preferred, along with familiarity with data transformation and analytical workflows.
- Proficiency with Microsoft Word, Excel, Outlook, PowerPoint, ServiceNow, and SharePoint.
- Strong ability to understand complex technical concepts and translate them into clear, accessible reporting and analytical solutions.
- Demonstrated initiative and self-direction, with the ability to independently identify opportunities for process and reporting improvements.
- Strong collaboration, communication, organizational, and problem-solving skills, with the ability to work effectively with technical and non-technical stakeholders in a fast-paced environment.
- Ability to work effectively as part of a team while maintaining a positive, solutions-oriented approach.
- Power BI, Tableau, or Qlik certification is a plus.
- A current or fully adjudicated U.S. Customs and Border Protection background investigation is preferred, as is prior experience supporting CBP.
- Master’s degree is preferred.
- Ability to pass a government background investigation covering areas such as financial, criminal, residential, educational, employment, foreign affiliation, and prohibited-substance history.
- U.S. citizenship is required for the applicable government suitability determination.
Benefits
- Target salary range of $76,390–$130,605 per year.
- Fully remote position within the United States.
- Opportunity to work on mission-critical federal programs with meaningful national impact.
- Exposure to large-scale data analytics, business intelligence, program management, and technology modernization initiatives.
- Collaborative environment with program managers, technical specialists, integrated project teams, and executive stakeholders.
- Opportunities to develop and apply advanced Power BI, data visualization, automation, SQL, and analytical capabilities.
- Potential opportunities for professional growth and increased responsibility within a mission-focused technology environment.
- Salary offers may vary based on location, internal equity, business considerations, client contract requirements, education, experience, skills, and applicable security clearances.
How Jobgether works:
We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.
We appreciate your interest and wish you the best!
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1
