Data Analytics Associate Fellowship at Ibility LLC in Columbus, OH

Summary: Ibility is a Service-Disabled Veteran-Owned Small Business and a Woman-Owned Small Business, headquartered in Gaithersburg, MD. The Data Analytics Associate Fellowship is a 9-month, paid program where fellows will work alongside OHARNG leadership to produce data analysis that informs recruiting and retention decisions impacting soldiers. Responsibilities: - Analyze, develop, and maintain personnel, recruiting, readiness, and retention data reports for OHARNG leadership, including recurring briefings, market share analysis, production tracking, and recognition reporting - Design, build, and maintain enterprise Power BI dashboards and automated reporting suites; implement Power Automate workflows and SharePoint-based data pipelines to reduce manual reporting burden - Develop and execute reports and queries across multiple government data systems - Validate and reconcile data across systems to ensure accuracy, consistency, and integrity; submit and track tickets with system owners to resolve data discrepancies - Provide data analysis and visualization support for state retention planning, extension tracking, IRR reporting, and monthly PR2 leadership briefings - Support the Schools Program through eligibility reporting, Order of Merit List maintenance, data system updates, and school budget analysis as directed - Lead reconnection, validation, and rebuild of all Power BI reporting assets as part of the Army-directed enterprise migration to the Army Vantage / Palantir platform - Develop SOPs, training materials, and user-facing tools; facilitate stakeholder office hours and cross-functional working groups to drive adoption of automated reporting solutions - Prepare and deliver executive briefings and presentations for Recruiting Battalion and senior OHARNG leadership on national rankings, demographics, DPRO data, and state comparisons Required Qualifications: - Ability to report in person to Beightler Armory, Columbus, OH (Mon–Fri, 8:00 AM – 5:00 PM EST) - Bachelor's degree completed by June 2025 (or within 3 months of application) in a relevant field - U.S. citizenship and ability to handle sensitive government information - Working knowledge of Microsoft Excel (formulas, pivot tables, data manipulation) - Familiarity with data visualization tools (Power BI, Tableau, or similar) - Strong analytical thinking and problem-solving skills developed through coursework or project work Preferred Qualifications: - Hands-on experience with Microsoft Power BI, Power Automate, or SharePoint (academic projects count!) - Exposure to SQL, Python, or R for data querying and analysis - Prior internship, co-op, capstone, or research experience involving real-world data - Prior National Guard, ROTC, or military-affiliated experience - Familiarity with government or DoD data environments - Familiarity with the Army Vantage / Palantir platform or other enterprise government data environments - Experience with requirements gathering, stakeholder facilitation, and cross-functional working groups - Ability to work with hybrid teams of contractors and government personnel Required Skills: Microsoft Excel, Power BI Important Skills: Power Automate, SQL, Analytical thinking Nice-to-Have Skills: Python, R, Tableau, Stakeholder facilitation, Hybrid team collaboration