Senior Human Resources Data Analytics and Statistical Analyst

About the role

Crossroads Talent Solutions is seeking a Senior Human Resources Data Analytics and Statistical Analyst to support the Ohio National Guard Human Resources Office. The analyst will transform personnel, manpower, and financial data into forecasts, models, dashboards, and briefings for senior government leaders.

Key responsibilities

• Analyze personnel strength, accessions, attrition, promotions, retirements, funding, obligations and disbursements to identify trends and emerging resource needs.
• Develop and refine statistical, predictive and optimization models for workforce planning, lifecycle forecasting and talent management.
• Apply regression, hypothesis testing, variance analysis and queueing theory, documenting assumptions, data sources, methods and results.
• Build and maintain dashboards and performance metrics for HR workflows, transaction volumes, processing times and workforce trends.
• Extract, validate, reconcile and analyze data from authorized Army and National Guard personnel and financial systems.
• Prepare recurring financial and workforce analyses, leadership briefings, technical reports and short‑notice analytical products.

Required profile

• At least 15 years of relevant experience, including analysis of military personnel, manpower or financial data in an Army or National Guard environment.
• Demonstrated ability to develop statistical analyses, forecasts and clear recommendations from complex datasets.
• Eligibility to meet Government suitability, background investigation and system access requirements.

Required skills

• Advanced Microsoft Excel (complex formulas, VBA/macros)
• SQL for data extraction and management
• Power BI and Tableau for dashboard creation
• Python and STATA for statistical modeling
• Familiarity with GFEBS, PBAS, RM Online, FTSMCS, DPRO, IPPS‑A, RCMS‑G, Army Vantage

What we offer

• Medical, Dental and Vision benefits
• 401(k) retirement plan
• Life insurance coverage
• Employee health and wellness program