ON-SITE POSITION: Power BI/Data Analytics/Dashboard Specialist – DCAA Financial Common Operating Picture (FCOP) Phase III

Position Overview

Redwood Strategy Group is searching for a Power BI/Data Analytics/Dashboard Specialist to 
provide advanced analytics, reporting, and dashboard development in support of the Defense Contract Audit Agency’s (DCAA) Financial Common Operating Picture (FCOP) Phase III initiative. This position will play a critical role in enabling data-driven decision-making, enhancing the transparency of financial and operational performance, and supporting audit readiness and program success through intuitive visualization and actionable insights.

Redwood is a specialized management consulting firm that engages experienced professionals and consultants to support the federal government with strategic project execution, financial process optimization, automation, and advanced data analytics. Through innovative solutions, they develop and implement strategies to optimize operations for defense and federal agencies, delivering critical improvements to financial oversight and operational effectiveness.

The Power BI/Data Analytics/Dashboard Specialist will serve as the primary resource for developing, maintaining, and optimizing Power BI dashboards and analytics solutions in direct support of the DCAA FCOP Phase III program. The incumbent will partner closely with program leadership, functional subject matter experts, and stakeholders to design and implement data solutions that drive insight, improve reporting accuracy, and facilitate efficient program management.

• Additional program-specific responsibilities as required by the DCAA FCOP Phase III

Performance Work Statement (PWS):

• Develop, configure, and maintain Power BI dashboards, reports, and data models tailored to the

needs of the DCAA FCOP Phase III initiative.

• Collaborate with program managers, financial analysts, and change management leads to gather

reporting requirements and translate them into effective analytics solutions.

• Integrate multiple data sources, including financial, operational, and audit-related data, to create unified reporting environments.

• Leverage advanced analytics techniques to uncover trends, highlight risks, and enable proactive

decision-making across the FCOP program.

• Optimize and automate recurring reporting processes to increase efficiency and ensure timely,

accurate delivery of program deliverables.

• Support data quality assurance activities, including data cleansing, validation, and

documentation.

• Provide subject matter expertise in the visualization of complex data sets, ensuring outputs are

clear, actionable, and tailored for federal stakeholders.

• Document dashboard/report specifications, update user guides, and provide ad hoc user support

and training as needed.

• Ensure compliance with all security, program, and deliverable requirements as outlined in the

PWS.

• Participate in recurring meetings, workshops, and working sessions; prepare and submit meeting minutes and action items when required.

• Expertise in Power BI, including DAX, Power Query, and advanced data modeling

• Experience integrating data from ERP, financial, or audit management systems

• Familiarity with federal reporting requirements and standards, especially in defense or audit

environments

• Proficiency in data visualization best practices and user-centric dashboard design

• Strong problem-solving skills with the ability to translate business requirements into technical

solutions

• Excellent written and verbal communication skills

• Ability to provide training and support to non-technical users and stakeholders