Senior Business Intelligence Developer

Cherokee Federal; Fort Belvoir (VA); On-site; USD 190,000 - 205,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401K

Job summary

Cherokee Federal is looking for a Senior Business Intelligence Developer in Fort Belvoir, Virginia, responsible for engineering and optimizing data pipelines, as well as building executive-level dashboards in Microsoft Power BI and Army Vantage for Department of the Army mission support.

The ideal candidate should have 8-10 years of related experience and hold an active TS/SCI clearance. Compensation ranges from $190K to $205K, with full benefits including Medical, Dental, and 401K.

Qualifications

• 8-10 years of experience in business intelligence or data analysis.
• Active TS/SCI clearance is required.
• DoD compliance certification is mandatory.

Responsibilities

• Design automated workflows using Microsoft Power Automate.
• Build and sustain enterprise dashboards.
• Serve as a BI/Power Platform SME mentoring junior analysts.

Skills

Business Intelligence

Data Analytics

Microsoft Power BI

Power Automate

SharePoint Online

Education

Bachelor's degree in Computer Science or related field

Master's degree may substitute 2 years of experience

Tools

Power BI (IL5)

Palantir Foundry

DAX

Job description

Senior Business Intelligence Developer

Cherokee Federal is seeking a Senior Business Intelligence Developer / Analyst to engineer, automate, and optimize data pipelines and decision-support dashboards supporting a Department of the Army mission. You will serve as the technical SME for extracting and transforming data from complex SharePoint Online environments and integrating those data streams into advanced analytics and visualization solutions. You will build and sustain executive-level dashboards in Microsoft Power BI (IL5) and Army Vantage (Palantir Foundry) to deliver predictive, near real‑time insights to senior military leaders. Active TS/SCI is required.

As required by our governmental client, this position requires an active TS/Sensitive Compartmental Information (SCI) clearance to be considered.

Compensation & Benefits

Estimated Starting Salary Range: 190K-205K

Pay commensurate with experience.

Full time benefits include Medical, Dental, Vision, 401K, and other possible benefits as provided. Benefits are subject to change with or without notice.

Responsibilities

• Design, build, and maintain automated workflows using Microsoft Power Automate to orchestrate data synchronization, transformation, and operational reporting.
• Architect data extraction and integration from custom SharePoint Online lists, libraries, and Power Apps, including solutions that mitigate large list view thresholds (5,000+ items).
• Use Power Query (M) to ingest, cleanse, reshape, merge, and optimize semi‑structured and nested (e.g., JSON) datasets into analytics‑ready models.
• Develop, publish, and sustain enterprise dashboards and interactive reports in Power BI (IL5) and Army Vantage (Palantir Foundry).
• Write advanced DAX measures to enable custom calculations, time‑intelligence, KPI tracking, and behavioral/operational analytics.
• Blend SharePoint‑derived datasets with Army enterprise systems of record within Army Vantage (e.g., IPPS‑A, GFEBS) to support cross‑domain decision‑making.
• Implement and enforce governance and security controls, including row‑level security (RLS) in Power BI and alignment to SharePoint permission structures and inheritance.
• Monitor, troubleshoot, and tune scheduled refresh and pipeline performance; implement resilient error handling (including Power Automate ‘Run After’ logic) to prevent failures.
• Serve as a BI/Power Platform SME, mentoring junior analysts and providing standards‑based guidance on development, documentation, and data governance.
• Performs other job‑related duties as assigned.

Experience, Education, Skills, Abilities

• Security clearance: Active, verifiable Top Secret / SCI (TS/SCI). Candidates without an active TS/SCI will not be considered.
• DoD compliance: Active DoD 8140/8570 baseline certification meeting IAT Level II (e.g., CompTIA Security+ CE, CCNA Security, CySA+) at time of hire.
• Education: Bachelor's degree in Computer Science, Data Analytics, Information Systems, Statistics, or related quantitative field.
• A related Master's degree may substitute for 2 years of experience.
• Experience: 8-10 years progressive experience in business intelligence, data analysis, data engineering, or data science roles.
• Technical knowledge and skills:
• Power Platform (Power BI + Power Automate): 4+ years building enterprise solutions.
• SharePoint Online: metadata management, lookup schemas, custom columns, permissions/inheritance, and API/OData querying.
• Data modeling: strong command of relational design concepts including star schemas, facts, dimensions, and performance optimization.
• Army Vantage / Palantir Foundry: experience building pipelines and/or analytics products (e.g., Object Explorer, Contour, Notepad).
• Abilities:
• Translate operational needs into scalable technical solutions.
• Deliver accurate, repeatable analytics in secure, compliance‑driven environments.
• Communicate clearly with technical teams and senior stakeholders.
• Must pass pre‑employment qualifications of Cherokee Federal.

Company Information

CN Defense Solutions is a division of tribally owned federal contracting companies owned by Cherokee Nation Businesses. As a trusted partner for more than 60 federal clients, Cherokee Federal LLCs are focused on building a brighter future, solving complex challenges, and serving the government’s mission with compassion and heart. To learn more about CNDS, visit cherokee-federal.com.

Similar Searchable Job Titles

• Senior BI Developer
• Senior BI Analyst
• Senior Power BI Developer
• Senior Data Analyst (Power Platform)
• Foundry Data Engineer / Analyst (Army Vantage)

Keywords

• Power BI (IL5)
• Power Automate
• SharePoint Online Data Integration
• DAX / Power Query (M)
• Army Vantage (Palantir Foundry)

All qualified applicants will receive consideration for employment without regard to protected veteran status, disability or any other status protected under applicable federal, state or local law.

Many of our job openings require access to government buildings or military installations.