DoD - Senior Power BI & SharePoint Business Intelligence Analyst

Montcure LLC; Falls Church (VA); On-site; USD 100,000 - 130,000; Full time

Job summary

Montcure LLC is 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 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.

Qualifications

• Bachelor’s level education in analytics or related field or equivalent experience.
• Experience with Power BI, Power Platform, and federal data integration.
• Knowledge of dashboards, data models, and automated workflows.

Responsibilities

• Design, build, and maintain enterprise Power BI dashboards for category management and governance reporting.
• Ingest and transform data from federal websites and APIs (SAM.gov, FPDS, USAspending, Advana).
• Develop Dataverse tables and SharePoint data repositories for Power Apps workflows.
• Collaborate to automate data pipelines using Power Query, Power Automate, and related tools.
• Create DAX measures, data models, and semantic layers for scalable reporting.
• Partner with program managers and SMEs to translate requirements into dashboards and data workflows.
• Analyze large datasets to identify trends and opportunities for cost savings and improvement.
• Document data models, refresh processes, and dashboard logic for governance.

Skills

Strong communication

Stakeholder engagement

Attention to detail

Curiosity

Problem-solving mindset

Explain data clearly

Education

Data Analytics

Statistics

Computer Science or Information Systems

Mathematics or quantitative field

Equivalent experience may substitute for degree

Tools

Power BI

Power Platform

Dataverse

Power Apps

Power Automate

SharePoint / Dataverse

SQL

API integration

Excel

Job description

Senior Power BI & SharePoint Business & Data Intelligence Analyst

(Power Platform / Federal Category Management)

Location: On-Location – Falls Church, VA

Level: Senior

Clearance*: Secret

*Candidates must have the above clearance level and, at a minimum, be able to maintain this clearance during their employment with Montcure.

Montcure, LLC is a Service-Disabled Veteran-Owned Small Business (SDVOSB) founded with a vision to revolutionize consulting and advisory services through innovative, data-driven solutions. The Montcure team recognize the unique challenges faced by organizations and governments in today’s rapidly evolving business environment.

Job Summary:

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.

Key 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.

Qualifications:

Education

• Data Analytics, Statistics, or Business Analytics
• Computer Science or Information Systems
• Mathematics or a related quantitative field
• Equivalent experience may substitute for degree.

Experience

• Approximately 1–3 years of related experience in:
• Data modeling, DAX, Power Query
• Experience pulling data from APIs or federal websites
• Experience supporting federal clients (preferred)
• Experience supporting Government or DoW clients.

Technical Skills

• Power BI (expert) — data modeling, DAX, Power Query
• Power Platform (preferred) — Dataverse, Power Apps, Power Automate
• SharePoint Lists / Dataverse for structured data storage
• SQL (preferred) – for querying and joining relational data
• 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

Soft Skills

• 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

Job Type: This is an active fully-funded role

Montcure, LLC is an Equal Opportunity Employer. Montcure, LLC does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non‑disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business.