Senior Data & Business 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 Data & Business 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 preferred.
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 position; not contingent or pending award.
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.
