We are seeking an experienced Data Analyst to support the U.S. Army Research Laboratory's Military Engagement Program (MEP). The program supports the development of the nation's future military officers and scientific workforce by connecting cadets and faculty from Senior Military Colleges (SMCs) with Department of Defense research and educational opportunities.

The Data Analyst will be responsible for analyzing applicant and participant information, validating historical data, evaluating recruitment and outreach effectiveness, developing performance metrics, and preparing analytical reports to support program management and Government decision-making.

This position will support multiple MEP initiatives, including the Senior Capstone Immersion Program (SCIP), Senior Military College Faculty Fellowship Program (SMC-FFP), and Army ROTC Cadet Apprentice Program (CAP).

The ideal candidate will possess strong analytical and technical skills, experience working with databases and reporting tools, and the ability to translate complex datasets into actionable insights. The individual must also demonstrate exceptional attention to detail and the ability to manage sensitive information in a federal contracting environment.

Essential Duties and Responsibilities

Data Analysis and Reporting

• Collect, organize, analyze, and interpret applicant, participant, program performance, and outreach data to support Military Engagement Program operations.
• Develop and maintain analytical reports, dashboards, and data visualizations to monitor program effectiveness and performance.
• Establish and track key performance indicators (KPIs) related to applicant recruitment, selection, participation, program completion, and outreach effectiveness.
• Analyze program trends and identify opportunities to improve participant engagement, application processing, and operational efficiency.
• Prepare analytical summaries, presentations, and recommendations for program management and Government stakeholders.
• Support the preparation of the Monthly Financial and Status Report, Annual Program Report, and other required program deliverables.
• Collaborate with program personnel to ensure accurate and consistent reporting across program functions.

Applicant and Selectee Analysis

• Analyze applicant information, including academic backgrounds, grade point averages, academic disciplines, institutional affiliations, and demographic information.
• Prepare the Applicant Analysis Report required under the PWS to evaluate applicant qualifications, research alignment, and outreach effectiveness.
• Analyze applicant distribution across participating Senior Military Colleges and other eligible institutions.
• Evaluate application completion rates, processing timelines, selection outcomes, and participation trends.
• Analyze the effectiveness of recruitment and outreach efforts using available response metrics, applicant data, and historical participation patterns.
• Support the analysis of applicant research interests and technical competencies to assist with alignment to Army Research Laboratory research opportunities.
• Analyze selectee acceptance and declination trends, including voluntarily provided reasons for declining participation.
• Develop analytical findings and recommendations to help improve future program recruitment and applicant engagement.

Data Validation, Quality Assurance, and Historical Data Analysis

• Review and validate historical applicant and participant records for accuracy, completeness, consistency, and reliability.
• Identify duplicate records, missing information, discrepancies, and data-quality issues requiring correction.
• Perform data reconciliation and validation activities supporting the migration of historical program information into the contractor-hosted database platform.
• Collaborate with the Web & Database Administrator to verify the accuracy and completeness of migrated records.
• Develop and maintain data-quality checks, reporting definitions, and validation procedures.
• Identify and communicate discrepancies or inconsistencies in program records to appropriate personnel.
• Support the validation of information provided to Government stakeholders and ensure analytical reports accurately reflect underlying program data.
• Assist with data verification and reconciliation during contract transition and closeout activities.

Dashboard Development and Performance Metrics

• Design and maintain dashboards and visual reports using Microsoft Excel, Power BI, Tableau, or comparable analytical tools.
• Define reporting requirements, performance measures, and analytical methodologies for program operations.
• Monitor applicant recruitment, selection, onboarding, participation, and completion metrics.
• Analyze outreach effectiveness and identify trends across academic institutions, research disciplines, and recruitment cycles.
• Develop visual summaries that communicate program outcomes, operational trends, and areas requiring management attention.
• Collaborate with the Web & Database Administrator to ensure appropriate database connections, accurate reporting inputs, and reliable data availability.

Participant and Event Performance Analysis

• Analyze participation data associated with the Senior Capstone Immersion Program, Faculty Fellowship Program, and Army ROTC Cadet Apprentice Program.
• Evaluate participant trends, program engagement, and placement outcomes.
• Analyze attendance, registration, survey responses, and participant feedback associated with program events.
• Support analysis of the annual Army Research Technical Exchange (ARTE), including attendee satisfaction surveys and event effectiveness.
• Analyze available performance information from Senior Military College outreach events, networking activities, and webinars.
• Prepare summaries identifying program successes, challenges, lessons learned, and opportunities for improvement.
• Support annual program assessments and after-action reporting through quantitative and qualitative analysis.

Data Management, Security, and Compliance

• Maintain accurate analytical datasets and supporting documentation in accordance with applicable federal contract requirements.
• Ensure Personally Identifiable Information (PII), Controlled Unclassified Information (CUI), and other sensitive program information are handled securely.
• Follow established data-access controls, confidentiality requirements, and Government-approved information handling procedures.
• Maintain documentation of reporting methodologies, data definitions, analytical assumptions, and validation results.
• Support the preparation and validation of program datasets and historical reports required for contract transition.
• Coordinate with technical personnel to maintain accurate and consistent program information across approved systems.
• Assist with Government-requested analytical reporting and data reviews while ensuring appropriate authorization and information protection.

• Bachelor's degree in Data Analytics, Statistics, Mathematics, Information Systems, Economics, or a related field.
• Minimum of three (3) years of relevant professional experience in data analysis, business intelligence, program reporting, or a closely related analytical function.
• Demonstrated proficiency in Microsoft Excel, including advanced formulas, data analysis, and reporting capabilities.
• Experience utilizing SQL to query, manipulate, validate, and analyze structured datasets.
• Experience developing reports and visualizations using Power BI, Tableau, or a comparable business intelligence platform.
• Demonstrated experience validating and reconciling records, identifying data discrepancies, and maintaining accurate datasets.
• Experience defining performance metrics, analyzing program outcomes, and identifying trends in operational or program data.
• Strong analytical, quantitative, and problem-solving skills.
• Excellent attention to detail and ability to manage multiple analytical assignments and reporting deadlines.
• Strong written and verbal communication skills, including the ability to explain analytical findings to technical and nontechnical audiences.
• Demonstrated ability to maintain confidentiality and protect sensitive information.

Preferred Qualifications

• Previous experience supporting federal Government contracts, Department of Defense programs, or federally funded research and educational initiatives.
• Experience analyzing internship, fellowship, student recruitment, academic research, or workforce development programs.
• Familiarity with Army Research Laboratory programs, Senior Military Colleges, ROTC initiatives, or similar military education programs.
• Experience developing dashboards and reporting solutions for Government stakeholders.
• Familiarity with historical data migration, data cleansing, and database reconciliation processes.
• Experience developing and maintaining KPI reporting frameworks, data dictionaries, and standardized reporting procedures.
• Experience conducting recruitment funnel analysis, demographic analysis, program performance evaluations, or survey analysis.
• Experience preparing analytical findings for executive leadership, program managers, or Government contracting personnel.
• Knowledge of federal information protection requirements involving PII and CUI.
• Strong organizational skills and the ability to collaborate with multidisciplinary program and technical teams.