Microsoft 365 Analyst

Kavaliro; United States; On-site; USD 110,000 - 120,000; Full time

Job summary

A prominent consulting firm is looking for a skilled Microsoft 365 Business Analyst for an on-site role at Camp Smith, Hawaii. This position requires strong expertise in SharePoint, Power BI, Power Apps, and Power Automate. The selected candidate will develop solutions to enhance operational efficiency and manage data workflows in support of defense missions. An active TS/SCI security clearance is required, along with experience in handling DoD data systems. This is a full-time position that emphasizes collaboration and data-driven decision-making.

Qualifications

• Strong expertise in SharePoint and Microsoft 365.
• Hands-on experience with Power BI for data visualization.
• Ability to analyze and improve business processes.

Responsibilities

• Maintain and optimize SharePoint Lists for reporting.
• Build and update Power BI dashboards.
• Develop workflows with Power Automate.

Skills

SharePoint

Power BI

Power Apps

Power Automate

Data analysis

Communication

Education

Experience working with DoD data

Valid U.S. Passport

Active DoD TS clearance with SCI eligibility

Tools

Microsoft 365

Job description

This range is provided by Kavaliro. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$110,000.00/yr - $120,000.00/yr

Kavaliro is seeking a highly skilled Microsoft 365 Business Analyst to support a mission-focused customer at Camp Smith. This role requires strong expertise in SharePoint, Power BI, Power Apps, Power Automate, and end-to-end workflow management—specifically the Request for Information (RFI) lifecycle. The ideal candidate will leverage Microsoft 365 capabilities to drive operational efficiency, enhance data accuracy, and support high‑visibility assessments across a dynamic DoD environment.

Responsibilities

• Maintain, manage, and optimize SharePoint Lists and Microsoft 365 data sources used for operational and performance reporting.
• Build and update Power BI dashboards that visualize trends, metrics, and mission‑critical insights.
• Develop lightweight Power Apps and Power Automate workflows to streamline data collection, approvals, and the full RFI workflow process.
• Capture, maintain, and enhance the RFI workflow to ensure accurate tracking and reporting across the enclave.
• Assist in developing tools, dashboards, and databases within the enclave using Power BI and related Microsoft technologies.
• Collaborate with analysts, operators, and leadership to gather requirements and convert them into actionable Microsoft 365 solutions.
• Validate all data inputs, ensure data quality, and maintain accuracy in recurring reports and assessments.
• Support high‑visibility assessments through structured data analysis and refined reporting products.
• Assist with SOP development, documentation, knowledge management, and user training.
• Work with technical stakeholders to troubleshoot issues related to data access, workflows, SharePoint/List configurations, and permissions.
• Ensure all solutions comply with DoD information security and classification requirements.

Required Education/Experience

• Experience working with DoD data, systems, or mission partners.
• Strong proficiency in SharePoint (Lists, Views, Permissions).
• Hands‑on experience with Power BI for dashboards, data modeling, and visualization.
• Experience developing Power Apps (canvas apps) and Power Automate workflows.
• Demonstrated ability to analyze business processes and recommend improvements.
• Experience validating data, troubleshooting issues, and ensuring consistent reporting quality.
• Strong written and verbal communication skills with the ability to translate operational needs into technical requirements.
• Excellent organizational, planning, and time‑management abilities. Valid U.S. Passport.
• Active DoD TS clearance with SCI eligibility (TS/SCI).

Preferred Experience

• Experience supporting intelligence or operational missions in a military or government setting.
• Previous support to DoD, counter‑drug, and law enforcement missions.
• Familiarity with Command and Control of the Information Environment (C2IE).
• Experience capturing, maintaining, and optimizing RFI workflows.
• Power BI experience in developing tools and databases within a secure enclave.

Location

• Camp Smith, Hawaii
• This position is onsite and there is no remote availability.

Clearance Requirement

• Candidates must have an active TS/SCI security clearance.
• Applicant must hold permanent U.S. citizenship for this position in accordance with government contract requirements.

Kavaliro provides Equal Employment Opportunities to all employees and applicants. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Kavaliro is committed to the full inclusion of all qualified individuals. In keeping with our commitment, Kavaliro will take the steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please respond to this posting to connect with a company representative.

Seniority level

• Mid‑Senior level

Employment type

• Full‑time

Job function

• Information Technology

Industries

• Government Administration