Senior Data Analyst

Guidehouse; Oregon; Hybrid; USD 98,000 - 163,000; Full time

Benefits offered by this job

Health Insurance

401(k) Retirement Plan

Tuition Reimbursement

Paid Holidays

Parental Leave

Life Insurance

Disability Insurance

Commuter Benefits

Employee Assistance Program

Job summary

Guidehouse seeks a Data Analyst to support the NIH DataForce Service Program. This role maintains program and workforce data, develops trackers and reports, monitors participant progress, and provides insights to help NIH manage recruitment, onboarding, and lifecycle activities.

You will collaborate with program managers, coordinators, mentors, and Government stakeholders to ensure data accuracy and usefulness for decision-making.

Qualifications

• Bachelor’s degree and four+ years of professional data experience.
• Experience in data analysis, program analysis, workforce analytics, or operations reporting.
• Strong ability to develop dashboards and reports for stakeholders.

Responsibilities

• Collect, organize, validate, and analyze recruitment, onboarding, participant, workforce, and program data.
• Maintain lifecycle trackers and monitor onboarding requirements and milestones.
• Develop dashboards, charts, reports, and briefing materials communicating program status.
• Prepare monthly and quarterly operations reports with insights.
• Identify data quality issues and opportunities for process improvement.
• Protect sensitive information per Federal and NIH requirements.
• Use Microsoft Excel, Power BI, SharePoint, and Teams for reporting and collaboration.

Skills

Data analysis

Program analysis

Workforce analytics

Performance measurement

Operations reporting

Education

Bachelor's degree

Master's degree (quantitative / public health / info systems / program evaluation)

Tools

Power BI

Microsoft Excel

SharePoint

Teams

Job description

Job Family: Data Science & AnalysisTravel Required: Up to 10% Clearance Required: Ability to Obtain Public Trust

We are seeking a Data Analyst to support the NIH DataForce Service Program. This role will maintain program and workforce data, develop trackers and reports, monitor participant progress, and provide insights that help NIH manage recruitment, onboarding, and participant lifecycle activities. The Data Analyst will collaborate with program managers, coordinators, mentors, and Government stakeholders to ensure program information is accurate, current, and useful for decision-making.

What You Will Do

• 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 clearly 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.

What You Will Need

• Bachelor’s degree
• Minimum of FOUR (4) years of professional experience
• Experience in data analysis, program analysis, workforce analytics, performance measurement, program evaluation, or operations reporting is highly preferred.

What Would Be Nice to Have

• 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 the 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 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.

What Success Looks Like

• Program and participant records are accurate, complete, and current.
• Recruitment, onboarding, milestone, and workforce trends are clearly communicated.
• Monthly and quarterly reports are delivered on time and supported by validated data.
• Data definitions and calculations are applied consistently across reports and dashboards.
• Missing information, delayed activities, and operational risks are identified early.
• Program leaders receive clear, reliable information to support Government decision-making.
• Sensitive applicant and participant information is handled appropriately.
• Analytical findings lead to practical improvements in program operations and reporting.

The annual salary range for this position is $98,000.00-$163,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

What We Offer

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Parental Leave
• 401(k) Retirement Plan
• Group Term Life and Travel Assistance
• Voluntary Life and AD&D Insurance
• Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
• Transit and Parking Commuter Benefits
• Short-Term & Long-Term Disability
• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Care.com annual membership
• Employee Assistance Program
• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
• Position may be eligible for a discretionary variable incentive bonus

About Guidehouse: Guidehouse is an Equal Opportunity Employer Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco. If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or . Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process. If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact . Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s dealings with unauthorized third parties. Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.