DoD - Senior Power BI & SharePoint Business Intelligence Analyst
Montcure, LLC West Falls Church, Virginia, United States · $75K–$95K/yr
Business Consulting and Services · 11-50 employees
About the role
Design and maintain enterprise-level Power BI dashboards and automated data workflows to support federal category management and spend analytics. Collaborate with technical teams to ingest data from federal sources and ensure accurate, scalable reporting through robust data modeling.
What they look for
Requirements
Requires a bachelor's degree in a quantitative field or equivalent experience, along with 1-3 years of experience in Power BI, DAX, and data modeling. Candidates must hold an active Secret clearance and possess strong communication skills for stakeholder engagement.
Full 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
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.
