Project Lead – Reporting and Workforce Management

The Project Lead – Reporting and Workforce Management leads workforce reporting, staffing analysis, and capacity planning to align personnel availability with operational requirements in a regulated federal client environment. This role develops recurring and ad hoc reports that translate staffing trends, coverage gaps, and utilization measures into actionable recommendations for leadership.

The Project Lead coordinates analytical deliverables, maintains staffing forecasts and capacity models, and partners with management to support scheduling and resource allocation decisions. The role strengthens reporting accuracy and timeliness by validating workforce records, standardizing analytical methods, and improving repeatable reporting processes.

Key Responsibilities

• Lead the day-to-day delivery of workforce reporting and staffing analysis, establishing priorities, coordinating contributors, and monitoring completion against client requirements and reporting schedules.
• Develop and maintain recurring and ad hoc reports that explain staffing trends, identify coverage gaps, and quantify the operational implications of resource allocation decisions.
• Build and update short- and long-term staffing forecasts using historical trends and documented assumptions, compare projections with actual results, and revise forecasts as operating conditions change.
• Maintain capacity models that compare projected workload, available personnel, productivity assumptions, and coverage requirements to identify resource shortfalls or excess capacity.
• Define and monitor workforce metrics, including headcount, vacancies, attrition, utilization, and staffing coverage, using consistent calculation methods and reporting periods.
• Use advanced Excel capabilities to reconcile workforce records, analyze variances, create visualizations, and improve the efficiency of repeatable reporting processes.
• Validate source data, resolve reporting discrepancies with stakeholders, and maintain traceable inputs, assumptions, and supporting documentation.
• Present findings and staffing recommendations to leadership, coordinating with resource managers and operational teams to support coverage adjustments and workforce planning improvements.

Required Qualifications

• Bachelor’s degree in Information Technology, Cyber Security, Business, Engineering, Management, or a related field, or equivalent relevant experience; an associate degree with five years of relevant experience may substitute for the bachelor’s degree.
• Four to six years of relevant experience in workforce analysis, operational reporting, resource planning, or related project delivery, including coordination of deliverables and contributors.
• Advanced proficiency in Microsoft Excel, including PivotTables, lookup functions, conditional aggregations, complex formulas, and charts used to analyze staffing trends and reconcile workforce records.
• Demonstrated ability to develop staffing forecasts and capacity models, monitor workforce metrics, and translate analytical findings into practical resource planning recommendations.
• Familiarity with workforce management platforms and scheduling concepts sufficient to interpret personnel availability, evaluate coverage gaps, and recommend adjustments aligned with operational requirements.
• Strong organizational, communication, and team leadership skills, including the ability to prioritize analytical requests, coordinate reporting schedules, and communicate findings to technical and nontechnical stakeholders.
• S. citizenship and the ability to obtain and maintain the required Public Trust determination.

Preferred Qualifications

• Experience using Power Query and Power Pivot to combine workforce datasets, establish data relationships, and automate refreshable reporting workflows.
• Experience supporting workforce reporting or project delivery in a regulated federal client environment.
• Progress toward Project Management Professional certification or attainment of Certified Associate in Project Management certification.
• Experience applying Agile project management methods to coordinate reporting enhancements and process improvements.

Compensation Ranges

Compensation ranges for ASM Research positions vary depending on multiple factors; including but not limited to, location, skill set, level of education, certifications, client requirements, contract-specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM's overall compensation and benefits package for employees.

EEO Requirements

It is the policy of ASM that an individual's race, color, religion, sex, disability, age, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.

All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, disability, or age. All decisions on employment are made to abide by the principle of equal employment.

Physical Requirements

The physical requirements described in "Knowledge, Skills and Abilities" above are representative of those which must be met by an employee to successfully perform the primary functions of this job. (For example, "light office duties' or "lifting up to 50 pounds" or "some travel" required.) Reasonable accommodations may be made to enable individuals with qualifying disabilities, who are otherwise qualified, to perform the primary functions.

Disclaimer

The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.