DoD - Senior Power BI & SharePoint Business Intelligence Analyst

Montcure, LLC; West Falls Church (VA); On-site; USD 75,000 - 95,000; Full time

Job summary

Montcure, LLC seeks a Senior Power BI & SharePoint Data Intelligence Analyst to support a DHA initiative. You will build enterprise dashboards, data models, and automated workflows using Power BI, Power Platform, and APIs.

The role emphasizes data integration from federal sites, governance reporting, and scalable analytics in a high‑visibility environment. Secret clearance or ability to obtain is desired.

Qualifications

• Education in data analytics or related field.
• Experience with data modeling, DAX, Power Query recommended.
• Experience with federal data sources and APIs preferred.

Responsibilities

• Design, build, and maintain enterprise Power BI dashboards for federal Category Management and governance reporting.
• Ingest and transform data from SAM.gov, FPDS, USAspending, Advana.
• Develop and maintain Dataverse tables and SharePoint-based data repositories.

Skills

Power BI

DAX

Power Query

Power Platform

Dataverse

Power Apps

Power Automate

SharePoint

SQL

API integration

Excel

Data visualization

Communication

Education

Data Analytics / Statistics / Business Analytics

Computer Science / Information Systems

Mathematics or related field

Equivalent experience may substitute for degree

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

DoD - Senior Power BI & SharePoint Business Intelligence Analyst

Full Time Falls Church, Va, Falls Church, VA, US

30+ days ago Requisition ID: 1139

Salary Range: $75,000.00 To $95,000.00 Annually

Senior Power BI & SharePoint Business & Data Intelligence Analyst

(Power Platf o rm / 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.