IT Business Systems Analyst

Govserviceshub; Dallas (TX); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading technology solutions provider is looking for an experienced IT Business Systems Analyst. The role requires strong SQL skills and direct experience with the UCPath system. Responsibilities include supporting HR and Payroll systems, conducting testing, and analyzing business processes. The ideal candidate will have a solid understanding of HR/Payroll functions and experience in a relevant analytical environment. This position offers remote flexibility and opportunities to partner with cross-functional teams.

Qualifications

• Must have UCPath experience.
• Strong SQL skills are essential.
• Background in HR or payroll systems is preferred.

Responsibilities

• Design process and system solutions.
• Develop specifications and requirements.
• Plan and execute testing phases.

Skills

Very strong SQL proficiency

HR and Payroll functional knowledge

Data validation and troubleshooting

Ability to document processes

System testing experience

Tools

Oracle Cloud

PeopleSoft HCM

UCPath System

Job description

Dallas, United States | Posted on 12/05/2025

Working Title: IT Business Systems Analyst

Location: Remote

Position Summary

We are seeking an IT Business Systems Analyst with very strong SQL skills and direct UCPath experience. These two qualifications are required for success in this role. The analyst will support HR, Payroll, and related business systems by performing data validation, troubleshooting integrations, executing testing, and analyzing business processes. The role serves as a critical liaison between HR, Payroll, and IT teams.

Key Requirements

Must-Have Skills

• Very strong SQL proficiency
• Ability to validate HR and Payroll data, troubleshoot integrations, and navigate complex table relationships.
• Direct work with the UCPath system at a University of California campus, including understanding of:

• Data model
• Funding structures & uploads
• Benefits files
• Payroll validations

Additional Preferred Experience

• HR and Payroll system background (e.g., PeopleSoft HCM, Oracle HCM)
• Functional experience supporting HR, Payroll, Workforce Administration, or Benefits
• Ability to:

• Gather and analyze business requirements
• Document processes and workflows
• Perform system and integration testing
• Support production issues
• Partner cross-functionally with HR, Payroll, and IT teams

Requirements

What Will NOT Work

• Candidates without UCPath experience
• Candidates with only surface-level SQL ability
• Candidates lacking HR/Payroll functional knowledge
• Candidates requiring extended time off or near the start date

Job Function Summary

This role involves technology-based analysis of business practices, processes, and challenges. Responsibilities include:

• Designing process and system solutions
• Developing specifications and requirements
• Validating requirements and ensuring alignment with business needs
• Planning and executing unit, integration, and user acceptance testing
• Assisting with training materials for system implementations
• Leading or participating in cross-functional teams to resolve significant business or system issues

The position functions with a high degree of autonomy and often requires problem-solving for unique or unprecedented issues.

Custom Scope

As a key member of the IT Functional Team, the Business Systems Analyst provides analytical, technical, and operational support for Oracle Cloud and associated boundary systems. Responsibilities include:

• Partnering with HR, Payroll, and campus stakeholders to understand business processes
• Defining and documenting system requirements
• Supporting configuration, data integrity, and system maintenance across ERP functions
• Analyzing new business requirements and creating functional specifications
• Facilitating process improvement initiatives
• Conducting system testing, including integration and UAT
• Resolving routine to complex production issues