Senior Human Resources Data Analytics and Statistical Analyst

The Senior Human Resources Data Analytics and Statistical Analyst role at Crossroads Talent Solutions supports the Ohio National Guard Human Resources Office by transforming personnel, manpower, and financial information into forecasts, models, dashboards, and leadership briefings. The position includes hands-on statistical analysis and clear communication of findings to Government leaders.

Responsibilities

• Analyze personnel strength, accessions, attrition, promotions, retirements, funding, obligations, and disbursements to identify trends and emerging resource requirements.
• Develop, refine, and maintain statistical, predictive, and optimization models supporting workforce planning, lifecycle forecasting, and talent management.
• Apply appropriate analytical methods, including regression, hypothesis testing, variance analysis, and queueing theory, and document assumptions, data sources, methods, and results.
• Build and maintain dashboards and performance metrics for Human Resources Office workflows, including transaction volumes, processing times, and workforce trends.
• Extract, validate, reconcile, and analyze information from authorized Army and National Guard personnel, financial, and data systems.
• Produce recurring financial and workforce analyses, leadership briefings, technical reports, and short-notice analytical products.
• Evaluate data quality and model accuracy, investigate discrepancies, and recommend improvements to analytical processes.
• Coordinate with Government personnel to understand analytical needs and present findings, providing advisory analysis while Government personnel retain responsibility for official decisions and actions.
• Protect sensitive information and follow applicable requirements for Government system access, privacy, training, and documentation.

Requirements

• At least 15 years of relevant experience in the core functional area or areas covered by this position.
• Demonstrated experience analyzing military personnel, manpower, workforce, or financial data in an Army or National Guard environment.
• Advanced capability to produce statistical analyses, forecasts, models, and clear recommendations from complex datasets.
• Strong Microsoft Excel skills, including complex formulas, and experience with VBA or macros where needed.
• Experience using SQL to extract and manage data, and to develop analytical reports or dashboards.
• Ability to write technical findings and brief senior leaders in clear, practical terms.
• Ability to meet Government suitability, background investigation, installation access, and system access requirements, including a favorable Tier 1/NACI investigation or equivalent as required for the assignment.

Technologies

• Microsoft Excel, VBA, SQL, Power BI, Tableau, Python, STATA
• GFEBS, PBAS, RM Online, FTSMCS, DPRO, IPPS-A, RCMS-G, Army Vantage

Benefits

• Medical/Dental/Vision Benefits Offered
• 401k
• Life Insurance plans
• Employee Health and Wellness program

Relevant Experience

Experience with AGR, MILTECH, and FTS programs; federal budget execution and PPBE; Army and National Guard personnel systems; and tools such as GFEBS, PBAS, RM Online, FTSMCS, DPRO, IPPS-A, RCMS-G, Army Vantage, Power BI, Tableau, Python, or STATA is especially relevant. Candidates should identify the systems and analytical methods they have used directly.