Senior PeopleSoft HCM Reporting Analyst / Consultant

novalink-solutions; Austin (TX); On-site; USD 85,000 - 115,000; Full time

Job summary

Novalink Solutions seeks a Senior PeopleSoft HCM Reporting Analyst to support the CAPPS Program in Austin, Texas. The role requires extensive experience in reporting for PeopleSoft, particularly in HR/Payroll modules, ensuring compliance with state policies and WCAG standards.

The ideal candidate will have a solid background in Texas public sector operations, extensive data analysis skills, and proven UAT methodology. Successful applicants will work closely with government agencies to deliver accurate and compliant reporting.

Qualifications

• 8+ years of Texas public sector experience, ideally for a Texas state agency.
• 8+ years of experience in PeopleSoft HR/Payroll reporting.
• 8+ years of knowledge regarding Texas state policies.
• 8+ years of creating WCAG 2.1-compliant materials.
• 8+ years of designing structured UAT and regression tests for reporting.
• 8+ years of experience interpreting contracts in daily workflows.
• 8+ years of experience with data integration and SDLC processes.
• 8+ years of developing cross-module reports from HR, Payroll, etc.
• 3+ years supporting CAPPS activities for multiple agencies.
• 3+ years familiarity with ITIL for IT service management.
• 4+ years of participation in Fiscal Year-End processes for CAPPS.
• 4+ years of customer-facing work related to CAPPS expansion.

Responsibilities

• Provide consultative services for the CAPPS Program.
• Develop and maintain reports using PeopleSoft tools.
• Translate business requirements into technical specifications.
• Collaborate with analysts to validate reporting accuracy.
• Optimize report performance and ensure data security.
• Document report designs and participate in testing activities.
• Provide end-user support and training across agencies.
• Participate in major incidents and disaster recovery activities.

Skills

Texas public sector experience

PeopleSoft HCM reporting

Knowledge of State of Texas policy

WCAG 2.1 compliance

UAT and regression testing

Data integration and quality

Cross-module reporting

PeopleSoft data structures

ITIL principles

Job description

Senior PeopleSoft HCM Reporting Analyst / Consultant

Austin, United States | Posted on 06/22/2026

Position Requirements

The CPA Work includes, but is not limited to, the following:

• Perform highly advanced (senior-level) consultative services and functional assistance work related to supporting the CAPPS Program.
• Develop, modify, and maintain Reports using PeopleSoft reporting tools, such as Query Manager / Query Viewer, BI Publisher (XML Publisher), PS/Query expressions and complex joins.
• Develop, modify, and maintain reports using CPA-provided tools such as SAP Business Objects.
• Translate business requirements into technical specifications, ensuring reports align with statewide policy, regulatory requirements, and agency-specific needs.
• Work closely with functional analysts and business owners to gather report requirements, validate logic, and ensure accuracy of data sourced from PeopleSoft tables and views.
• Create and maintain report templates, layouts, and bursting setups (BI Publisher), ensuring consistency with statewide branding and accessibility standards.
• Analyze PeopleSoft data structures, including table relationships, keys, and effective-dating rules, to ensure correct data extraction.
• Optimize report performance, including tuning queries, indexing recommendations, and improving runtime for high-volume statewide datasets.
• Support reporting during upgrades, patches, and project releases, including impact analysis, remediation of broken reports, and migration coordination through environments.
• Ensure data security and compliance, making sure reports respect row-level and role-based security, sensitive data handling rules, and statewide privacy standards.
• Produce documentation, such as report inventories, design specifications, data dictionaries, run instructions, and test plans.
• Participate in system testing, including UAT and regression testing, focused on data integrity and report output accuracy.
• Provide end-user support, training, troubleshooting, and resolution for reporting issues across agencies or statewide users.
• Collaborate with Managed Services Tier 3 support staff on integration points, data fixes, audit reports, and cross-module reporting needs.
• Plan, design, develop, implement, support, and maintain the information technology security measures to safeguard system information.
• Responsible for project-level participation, including expansions that include additional module implementations or enhancements for agencies; cyclic processes such as fiscal year-end, calendar year-end, State of Texas legislative changes, federal mandates, and third-party integrations; and performs all duties following CPA’s processes, policies, and procedures within project scope and on schedule in accordance with milestones, deliverables, and due dates.
• Responsible for the CAPPS HR/PY functional design phase, creating and/or reviewing Functional Design Documents (FDDs), performing functional configuration system changes, and other functional activities assigned.
• Provide Level 2 Service Desk support, including complex ticket handling, advanced troubleshooting, clear documentation, and basic system configuration, following established auditable processes in coordination with a Managed Services vendor responsible for Tier 3 work.
• Ensure that all digital products and content meet WCAG 2.1 accessibility standards, maintaining perceivable, operable, understandable, and robust experiences for all users, regularly reviewing content for compliance, and implementing updates or remediation whenever accessibility issues are identified.
• Work under minimal supervision, relying on experience and judgment to plan and accomplish goals, independently performing a variety of complicated tasks; established processes and procedures must be followed.
• Validate that only accurate data is produced, security, including multi-tenancy, is enforced, that the system performs efficiently, and that all applicable policies are enforced.
• Perform all work in accordance with Information Technology Infrastructure Library (ITIL) principles and practices for IT activities such as IT service management (ITSM) and IT asset management (ITAM) that focus on aligning IT services with the needs of the business.
• Actively participate in CPA’s Major Incident Management (MIM) process for P1 and P2 incidents according to module responsibilities.
• Participate in Disaster Recovery and Upgrade Testing activities.
• Make presentations at CAPPS User Groups and the CAPPS Steering Committee.
• Participate as directed in an annual SOC-1 attestation audit to ensure that controls are effectively designed and operated to ensure the accuracy and security of all information contained/processed via CAPPS; any enhancements, process changes, or system fixes consider security, availability, processing integrity, confidentiality, and privacy as solutions are suggested, approved, and implemented.
• Perform other related work as assigned.

Candidate Skills and Qualifications

Candidates that do not meet or exceed theminimumstated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

• 8 Years Required: Extensive Texas public sector experience, directly working for or supporting a Texas state government agency.
• 8 Years Required: Extensive experience in reporting support for the HR/Payroll modules in PeopleSoft HCM version 9.2.
• 8 Years Required: Extensive knowledge and understanding of State of Texas applicable policy.
• 8 Years Required: Experience preparing WCAG 2.1-compliant materials for distribution.
• 8 Years Required: Experience designing, executing, and documenting structured UAT and regression testing for reporting impacts during upgrades, PUM cycles, or patch deployments.
• 8 Years Required: Experience in interpreting contractual language and integrating it into daily workflows, while consistently holding vendors accountable to contractual requirements.
• 8 Years Required: Extensive knowledge of/experience with data integration, data quality, and SDLC processes and methodologies.
• 8 Years Required: Experience developing or supporting cross module reports that incorporate data from HR, Payroll, Time & Labor, Position Management, or related modules.
• 8 Years Required: Extensive experience analyzing PeopleSoft HCM data structures, including effective dating rules, table relationships, and multi-row logic, to support complex statewide reporting requirements.
• 3 Years Required: Experience with CAPPS Central production and expansion functional support activities for more than 100 agencies and 5 Hub instances.
• 3 Years Required: Knowledge of Information Technology Infrastructure Library principles and practices for IT activities such as IT service management (ITSM) and IT asset management (ITAM) that focus on aligning IT services with the needs of the business.
• 4 Years Preferred: CPA experience participating in Fiscal Year-End processes specific to reorganizational changes and legislative mandates for CAPPS.
• 4 Years Preferred: CPA experience performing customer-facing responsibilities in support of the CAPPS expansion efforts for Central and Hub agencies.