Senior Data Analyst

Guidehouse; Washington (District of Columbia); Sur place; USD 98 000 - 163 000; Plein temps

Avantages offerts par ce poste

Medical Insurance

401(k) Retirement Plan

Paid Holidays

Tuition Reimbursement

Résumé du poste

Guidehouse is seeking a Data Analyst to support the NIH DataForce Service Program. You will collect and analyze recruitment, onboarding, participant, and workforce data, and develop trackers and dashboards to clearly communicate trends and program status.

You will produce monthly reports, support quarterly analyses, and collaborate with program managers and government stakeholders to ensure data accuracy and actionable insights while protecting sensitive information in accordance with federal

Qualifications

• Bachelor’s degree required or equivalent.
• 4+ years of professional data analysis or program analytics experience.
• Advanced Excel skills (formulas, pivot tables, charts, data validation).
• Experience creating dashboards/reports with BI tools (Power BI/Tableau).
• Experience handling multiple data sources and data quality issues.

Responsabilités

• Collect, organize, validate, and analyze recruitment, onboarding, participant, and workforce data.
• Develop and maintain trackers and dashboards communicating program status and trends.
• Prepare monthly operations and performance reports; support quarterly analyses.
• Identify data quality issues, risks, and opportunities for process improvement.

Connaissances

Data analysis

SQL

Python or R

Communication

Formation

Bachelor’s degree

Master’s degree (preferred)

Outils

Power BI

Tableau

Power Query

Microsoft Lists

Description du poste

Job Family:Data Science & AnalysisTravel Required:Up to 10%Clearance Required:Ability to Obtain Public TrustWe 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 DoCollect, 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 NeedBachelor’s degreeMinimum of FOUR (4) years of professional experienceExperience in data analysis, program analysis, workforce analytics, performance measurement, program evaluation, or operations reporting is highly preferred.What Would Be Nice to HaveAdvanced 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 LikeProgram 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 InsurancePersonal and Family Sick Time & Company Paid HolidaysParental Leave401(k) Retirement PlanGroup Term Life and Travel AssistanceVoluntary Life and AD&D InsuranceHealth Savings Account, Health Care & Dependent Care Flexible Spending AccountsTransit and Parking Commuter BenefitsShort-Term & Long-Term DisabilityTuition Reimbursement, Personal Development, Certifications & Learning OpportunitiesEmployee Referral ProgramCorporate Sponsored Events & Community OutreachCare.com annual membershipEmployee Assistance ProgramSupplemental 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 bonusAbout GuidehouseGuidehouse 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 1-571-633-1711 or via email at [e-mail]. 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 [e-mail]. 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 [e-mail]. 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.