Human Capital Management Analyst
Columbus, Ohio, United States
* Utilized Pivot Tables, Pivot Charts, IF formulas, Data Validation, Conditional Formatting, Cell Referencing, and other Excel techniques daily to maintain agile, custom-built spreadsheets for tracking candidates' progression through the recruitment progress* Co-produced an up-to-date retention spreadsheet that auto-generates eligibility requirements. This required combining a year's worth of data, standardizing it into a single spreadsheet, performing VLOOKUPs, and utilizing TODAY() and DATE() functions to keep records live* Utilized Oracle BI (Business Intelligence) to download candidate data from Taleo into Excel and run recruitment analytics* Downloaded reports from Cognos to deduce current and past employee information* Navigated Tableau to determine layoff lists throughout the State* Posted requisitions through Oracle's "Taleo" software, managing 10+ assignments at once* Screened applicants for roles in Fiscal Management, Vocational Rehabilitation, Disability Determination, IT, and other departments* Determined whether candidates' applications meet legislatively-determined Minimum Qualifications* Lead interviews regularly, representing OOD HR* Facilitated the onboarding process for selected candidates, including: correspondence, background-check completion, and authorization through both OOD and State of Ohio software* Maintained a multi-page, continually-updated Word Doc to organize and complete daily tasks* Collaborated through Microsoft Office products, such as Outlook, OneNote, Planner, and Teams* Completed LeanOhio Camo Belt "Boot Camp" * Consulted by my Supervisor on a data-based presentation that was prepared for the OOD Executive team* Received an Excellence in Service Award as a member of the Talent Acquisition Team