DoD - Senior Power BI & SharePoint Business Intelligence Analyst

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., * 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.

• Candidates must have the above clearance level and, at a minimum, be able to maintain this clearance during their employment with Montcure., 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

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