NEOGOV · 1 month ago
Functional Analyst - Human Resources
McKinney, TX
Full-time
Onsite
Mid Level
$70K/yr - $70K/yr
3+ years expCollin County Government is seeking a Functional Analyst for their Human Resources Department to support PeopleSoft systems. The role involves advanced data analysis, system audits, and troubleshooting, as well as creating reports and ensuring data integrity across integrated systems.
GovTechHuman ResourcesInformation TechnologySoftware
Responsibilities
Perform standard recurring system audits
Complete standard recurring data loads and verify success of loaded data once complete
Write and produce ad hoc queries as needed for management decisions and public information requests. This requires a high level of attention to detail, critical thinking, using existing system resources to make decisions on how to accurately put together the information, and independent work without errors, including reconciliation of numbers to ensure accuracy of the data pulled
Write and produce queries to be used for daily tasks by other groups in HR and across other departments. Error on these may impact other groups processes and ability to accurately complete their work including administering FMLA accurately, time reporting issues, and management decisions
Use of expressions, prompts, unions and left outer joins in queries is required
Verify and troubleshoot data across integrated systems
Troubleshoot issues as they occur, investigating whether the issue is replicable in a test database, researching Oracle documentation to determine whether bug reports have been issued related to the item, and whether there are existing documents in the knowledge base on how to troubleshoot or workaround an issue
Document extensive step-by-step processes for testing modifications
Test the entirety of the system during upgrades, including verifying work done by other groups once the UAT testing phase has been reached
Write SQL statements for use in SQL Server to query portions of the system tables and audit data, ensure numbers are as expected, etc
Create nVision reports to include multiple tab outputs, PowerPivots and PowerQueries
Troubleshoot existing PowerQueries when they fail and make edits to report templates as needed
Troubleshoot and update Word and Excel BI reports as needed using the PeopleSoft BI Publisher desktop tool
Research new or not yet implemented system modules as directed to determine whether it will work in our environment, how to configure it for a successful use scenario, needed security updates for the module to work, etc. Document the processes associated with the new feature in a procedure format to provide end users within and externally to HR. Provide training on items as needed
Verify data loads and that they match the expected number of rows, and that the data totals (such as wage movement amounts) match the expected dollar amount. Investigate and resolve any discrepancies
Annual review/updates of approximately 100 procedure documents, as well as 50 – 100 mod scripts
Edit and write Excel Macros and VBA as needed to produce and maintain specialty reports
Other duties as assigned
Qualification
Required
Direct functional experience with PeopleSoft HCM, Benefits Administration, Payroll for North America, Time and Labor, and Recruiting
Experience with troubleshooting, user acceptance testing, system patches and upgrades
Experience creating reports in BI Publisher
Extensive knowledge of PeopleSoft database structure and report generation
Extremely strong critical thinking and computer skills
Basic understanding of relational databases
Experience analyzing and reconciling data
Intermediate to advanced Excel skills
Direct experience using a HRIS (Human Resource Information System) such as WorkDay, ADP, Paycor, Oracle Cloud, Kronos or similar
Education level of an Associate's degree or higher
Three (3) years' experience in a business environment
Benefits
200% retirement match with employee contributions earning 7% interest
100% tuition reimbursement
Affordable medical, dental, and vision plans
10 paid holidays annually
24 days of PTO in your first year of employment with balance rollover from year-to-year
County-provided life insurance
Short-term disability
Long-term disability
Other optional participation benefits
Company
NEOGOV
NEOGOV is the leading provider of workforce management software uniquely designed for the public sector, education, and public safety.
501-1000 employees
Funding
Current Stage
Late StageTotal Funding
$700MKey Investors
Warburg Pincus
2025-07-28Secondary Market· $700M
2025-07-28Acquired
2021-06-02Private Equity
Leadership Team
Shane Evangelist
CEO
Brandon McDonald
Head Of Marketing
Recent News
Canada NewsWire
2025-11-14
2025-11-14
Government Technology US
2025-10-31
Company data provided by crunchbase