Power BI Analyst

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.