Senior Data Analyst

Guidehouse • Tysons, VA

7d • $98,000 - $163,000

About The Position

Guidehouse is seeking a Data Analyst to support the NIH DataForce Service Program. The role maintains program and workforce data, develops trackers and reports, monitors participant progress, and provides insights to help NIH manage recruitment, onboarding, and participant lifecycle activities. The analyst collaborates with program managers, coordinators, mentors, and Government stakeholders to keep program information accurate, current, and useful for decision-making.

The position analyzes recruitment, onboarding, participant, workforce, and performance data; maintains participant lifecycle trackers; monitors onboarding requirements; and tracks recruitment and selection activities. It develops dashboards, reports, and briefing materials, prepares monthly operations and performance reports, and supports quarterly analyses of participant progression, workforce utilization, task alignment, and program outcomes. The analyst also identifies data-quality issues and operational risks, maintains reporting definitions and procedures, supports workflow documentation, responds to information requests using verified data, and protects sensitive information. Government-approved tools include Microsoft Excel, Power BI, SharePoint, and Teams. Electronic products must meet applicable Section 508 accessibility requirements.

Success in the role means maintaining accurate and current records, communicating trends clearly, delivering timely reports supported by validated data, consistently applying metric definitions, identifying risks early, and providing reliable information that supports Government decisions and practical improvements to program operations.

Requirements

• Bachelor’s degree.
• Minimum of four years of professional experience.

Nice To Haves

• Experience in data analysis, program analysis, workforce analytics, performance measurement, program evaluation, or operations reporting.
• Advanced Microsoft Excel skills, including formulas, pivot tables, lookup functions, charts, and data validation.
• Experience developing dashboards and reports using Microsoft Power BI, Tableau, or a similar business-intelligence tool.
• Experience collecting, cleaning, reconciling, and analyzing information from multiple sources.
• Experience developing and maintaining operational trackers, performance measures, or management reports.
• Ability to identify data-quality issues, operational trends, risks, and reporting gaps.
• Strong written and verbal communication skills.
• Ability to explain data and analytical findings to technical and nontechnical audiences.
• Strong attention to detail and ability to manage recurring monthly and quarterly deliverables.
• Experience handling sensitive workforce, applicant, participant, or program information.
• Ability to collaborate with program managers, coordinators, mentors, and Government stakeholders.
• Proficiency with Microsoft SharePoint, Teams, and other Microsoft 365 tools.
• Bachelor’s degree in data analytics, statistics, business analytics, information systems, public health, economics, mathematics, computer science, program evaluation, or a related field.
• Master’s degree in a quantitative, analytical, public health, information systems, or program-evaluation field.
• Experience supporting NIH, HHS, or another Federal agency.
• Experience supporting a fellowship, internship, recruitment, workforce development, training, or rotational program.
• Experience analyzing recruitment pipelines, onboarding completion, participant progression, workforce utilization, or program outcomes.
• Experience using Power Query, Microsoft Lists, Power Pivot, or Microsoft Forms.
• Working knowledge of SQL, Python, or R for data preparation, analysis, automation, or visualization.
• Experience conducting trend analysis, forecasting, root-cause analysis, or process-performance analysis.
• Familiarity with Federal privacy, security, records-management, and data-governance requirements.
• Experience developing Section 508-compliant reports, dashboards, and presentation materials.

Responsibilities

• Collect, organize, validate, and analyze recruitment, onboarding, participant, workforce, and program performance data.
• Maintain participant lifecycle trackers covering application status, onboarding, mentor assignments, training, milestones, deliverables, and administrative actions.
• Monitor onboarding requirements, including background investigations, credentialing, badging, required training, and system access.
• Track recruitment activities, application processing, interviews, mentor matching, and selection coordination.
• Develop dashboards, charts, reports, and briefing materials that communicate program status and trends.
• Prepare monthly program operations and performance reports.
• Support quarterly analyses of participant progression, workforce utilization, mentor-recommended task alignment, and program outcomes.
• Identify missing information, inconsistent records, delayed activities, operational risks, and opportunities for process improvement.
• Maintain data dictionaries, metric definitions, reporting templates, and data-quality procedures.
• Support documentation of recruitment, onboarding, selection, and participant lifecycle workflows.
• Respond to requests for program and workforce information using verified data.
• Protect sensitive applicant and participant information in accordance with applicable Federal and NIH requirements.
• Use Government-approved tools and platforms, including Microsoft Excel, Power BI, SharePoint, and Teams.
• Ensure reports, dashboards, and other electronic products meet applicable Section 508 accessibility requirements.

Benefits

• Medical, prescription, dental, and vision insurance.
• Personal and family sick time and company-paid holidays.
• Parental leave.
• 401(k) retirement plan.
• Group term life and travel assistance.
• Voluntary life and AD&D insurance.
• Health Savings Account and health care and dependent care Flexible Spending Accounts.
• Transit and parking commuter benefits.
• Short-term and long-term disability.
• Tuition reimbursement, personal development, certifications, and learning opportunities.
• Employee referral program.
• Corporate-sponsored events and community outreach.
• Care.com annual membership.
• Employee Assistance Program.
• Supplemental benefits via Corestream, including critical care, hospital indemnity, accident insurance, legal assistance, and identity theft protection.
• Position may be eligible for a discretionary variable incentive bonus.
• Competitive compensation and a flexible benefits package.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior