Data Analyst

Red Cedar Consultancy, LLC; Virginia; On-site; USD 70,000 - 100,000; Full time

Job summary

Red Cedar Consultancy, LLC is seeking a Data Analyst to support a nationwide operations center, providing analysis and reporting for senior leadership. The role emphasizes information sharing across incident coordination and integration of data from multiple sources, with a focus on executive briefs and strategic reporting.

The analyst will apply statistical methods, maintain databases, and develop knowledge management content while working typical EST hours and adapting to operational needs.

Qualifications

• Candidate must possess a Secret clearance.
• 5 years of experience in data analysis.

Responsibilities

• Develop or apply mathematical/statistical methods to collect, organize, interpret, and summarize data for usable information.
• Specialize in biostatistics, economic statistics, or related fields as needed.
• Perform duties of statistical analysts and support knowledge management processes including data capture, storage, and dissemination.
• Plan and support strategies for enterprise modernization and integration of applications with data workflows.
• Prepare executive-level reports, briefs, and talking points for leadership.
• Available to work 10:00 AM–6:00 PM EST and flexible for additional hours as required.

Tools

Power BI

Tableau

Job description

Looking for candidates with Active Secret Clearance only

Job Title: Data Analyst

Summary: This program supports a centralized operations center that serves as the primary information and coordination hub for customers nationwide. The center maintains continuous situational awareness of operational activities, incidents, significant events, and natural disasters affecting customer facilities and operations. It integrates information from regional operations, dispatch centers, partner agencies, intelligence units, and proprietary systems to produce consolidated reports, briefings, bulletins, and presentations for senior leadership and stakeholders.

The program also supports virtual emergency operations centers for national-level activities and provides surge capabilities for incident management teams during field deployments. A maintained Common Operating Picture ensures a shared, real-time understanding of operational conditions. Operating in both classified and unclassified environments, the project emphasizes timely information sharing, executive-level reporting, coordinated communication, and strong records management practices to support leadership decision-making and interagency collaboration.

Responsibilities:

• The candidate should develop or apply mathematical or statistical theory and methods to collect, organize, interpret, and summarize numerical data to provide usable information
• The candidate may specialize in fields such as biostatistics, agricultural statistics, business statistics, or economic statistics
• The candidate should perform duties inclusive of mathematical and survey statisticians
• The candidate should conduct activities related to knowledge management processes, to include, but not limited to, content analysis, document management, data capture, portals, shared storage locations, workflow, collaboration, data warehousing, decision support, and information dissemination;
• The candidate should support planning to encompass the strategy, architecture and methodology for an enterprise modernization effort; the candidate should support selection, implementation, and measurement of packaged solutions for enterprise modernization; the candidate should ensure complete integration of applications with target data and defined processes
• The candidate should support development and implementation of the policies, processes, and platforms enhancing effective information sharing and information access across Incident Command and Incident Commander (IC) for hostage recovery, detainee affairs, and other portfolios, as needed
• The candidate should identify mission-critical information sharing and information access requirements for stakeholders and should propose technical solutions to address
• The candidate should design, construct, and populate internal repositories for relevant analytic, policy, program, background, and legislative information associated with Prevention and Security (P and S) portfolios
• The candidate should provide knowledge management and content support to existing information portals
• The candidate should maintain databases
• The candidate should have experienced working with Power BI and Tableau
• The candidate should conduct database mining in response to Requests for Information (RFIs) and should perform limited analysis of data pulled from various Federal Protective Service (FPS) databases
• The candidate should prepare executive-level reports and products, to include Senior Leader Briefs, In Response to Your Question (IRTYQ) memoranda, talking points, and other such documents, as directed by the Senior Watch Officer (SWO)
• The candidate should be available to work from 10:00 AM to 6:00 PM EST and be flexible to work additional hours as needed based on operational requirements.

Requirements:

• Candidate must possess a Secret clearance
• Should have 5 years of experience in data analysis