Sr. Business Intelligence Developer

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

Benefits offered by this job

Medical

Dental

Vision

401K

Job summary

Cherokee Federal is seeking a Senior Business Intelligence Developer/Analyst to engineer, automate, and optimize data pipelines and decision-support dashboards for a DoD mission. You will build and sustain executive-level dashboards in Power BI and Army Vantage, integrating SharePoint data with Army systems to deliver near real-time insights for senior leaders.

Active TS/SCI clearance is required; DoD 8140/8570 baseline certification is expected.

Qualifications

• Active TS/SCI clearance required.
• DoD 8140/8570 baseline certification meeting IAT Level II at time of hire.
• ].,
• Education: Bachelor’s degree in Computer Science, Data Analytics, Information Systems, Statistics, or related quantitative field.

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 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 to support cross-domain decision-making.
• Implement governance and security controls, including row-level security in Power BI and alignment to SharePoint permission structures.
• Monitor, troubleshoot, and tune scheduled refresh and pipeline performance; implement resilient error handling to prevent failures.
• Mentor junior analysts and provide standards-based guidance on development, documentation, and data governance.
• Performs other job-related duties as assigned.

Skills

Power BI

Power Automate

Data modeling

Stakeholder communication

Mentoring

Problem solving

Education

Bachelor's degree in Computer Science, Data Analytics, Information Systems, Statistics, or related field

Master’s degree may substitute for 2 years of experience

Tools

SharePoint Online

Palantir Foundry / Army Vantage

DAX / Power Query (M)

Job description

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.

Estimated Starting Salary Range for Senior Business Intelligence Developer: 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.

Senior Business Intelligence Developer Responsibilities Include:

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

Senior Business Intelligence Developer Experience, Education, Skills, Abilities requested:

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

Cherokee Federal is a military friendly employer. Veterans and active military transitioning to civilian status are encouraged to apply.

• Senior BI Developer
• Senior BI Analyst
• Senior Power BI Developer
• Senior Data Analyst (Power Platform)
• Foundry Data Engineer / Analyst (Army Vantage)
• Power BI (IL5)
• Power Automate
• SharePoint Online Data Integration
• DAX / Power Query (M)

Legal Disclaimer: 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.