Dod - Senior Power Bi & Sharepoint Business Intelligence Analyst

Job Description

Job Description

Senior Power BI & SharePoint Business & Data Intelligence Analyst

(Power Platfo 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

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.

Experience

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

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

Salary: $75-$95k

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.