DoD - Senior Power BI & SharePoint Business Intelligence Analyst

Montcure, LLC • West Falls Church, VA

7d • $75,000 - $95,000 • Onsite

About The Position

We are seeking a Senior Power BI & SharePoint Business & Data Intelligence Analyst with hands‑on experience in Power BI, Power Platform, and federal data integration to support a major Defense Health Agency (DHA) initiative. This role is ideal for a junior‑to‑mid‑level analyst who is ready to work on enterprise‑level data challenges and build production‑grade dashboards, data models, and automated workflows.

Requirements

• Bachelor’s degree in Data Analytics, Statistics, or Business Analytics, Computer Science or Information Systems, Mathematics or a related quantitative field. Equivalent experience may substitute for degree.
• Approximately 1–3 years of related experience in Power BI dashboard development, Data modeling, DAX, Power Query.
• Experience pulling data from APIs or federal websites.
• Experience supporting federal clients (preferred).
• Experience supporting Government or DoW clients.
• Power BI (expert) — data modeling, DAX, Power Query
• SharePoint Lists / Dataverse for structured data storage
• API integration (REST, JSON, XML)
• Excel (pivot tables, advanced formulas)
• Strong understanding of data visualization best practices
• Ability to explain complex data to non‑technical audiences
• Strong communication and stakeholder engagement
• Ability to work independently and manage multiple priorities
• Attention to detail and commitment to data accuracy
• Curiosity, problem‑solving mindset, and willingness to learn new tools
• Secret clearance required and must be maintained during employment.

Nice To Haves

• Power Platform (preferred) — Dataverse, Power Apps, Power Automate
• SQL (preferred) – for querying and joining relational data

Responsibilities

• Design, build, and maintain enterprise Power BI dashboards supporting federal Category Management, spend analytics, and governance reporting.
• Ingest and transform data from federal websites and APIs (e.g., SAM.gov, FPDS, USAspending, Advana).
• Develop and maintain Dataverse tables and SharePoint‑based data repositories to support Power Apps workflows and enterprise data models.
• Collaborate with SharePoint team to automate pipelines using Power Query, Power Automate, or other tools to unify data from multiple systems.
• Create DAX measures, data models, and semantic layers to ensure accurate, scalable reporting.
• Partner with program managers, acquisition SMEs, and technical stakeholders to translate business requirements into dashboards and data workflows.
• Analyze large, complex datasets to identify trends, anomalies, and opportunities for cost avoidance and operational improvement.
• Document data models, refresh processes, and dashboard logic to support governance and sustainment.
• Support the development of a Category Management analytics platform including spend cubes, vendor normalization, SUM reporting, and sourcing insights.

What This Job Offers

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