Enterprise HCM Data Analyst

Job Description

Job Description

Benefits:

• Competitive salary

Location
Austin, TX

Experience Level
Senior Level (8 or more years of experience)

Role Overview
The Senior PeopleSoft HCM Reporting Consultant provides highly advanced functional assistance and report development services for a statewide Enterprise Resource Planning (ERP) platform (PeopleSoft HCM version 9.2). This role focuses on translating complex business requirements into technical specifications, creating custom reporting solutions using native PeopleSoft tools (Query Manager, BI Publisher) and external platforms (SAP Business Objects), and ensuring data security, accessibility, and integrity across high-volume datasets.

Key Responsibilities
Reporting Development & Optimization

• Develop, modify, and maintain custom reports using native PeopleSoft tools, including Query Manager, BI Publisher (XML Publisher), and complex PS/Query expressions with advanced joins.
• Build, optimize, and support enterprise reports using external business intelligence platforms such as SAP Business Objects.
• Analyze complex PeopleSoft HCM data structures (table relationships, keys, effective-dating rules, and multi-row logic) to optimize SQL queries and improve runtime for high-volume datasets.
• Design, format, and maintain BI Publisher report templates, layouts, and bursting configurations in compliance with branding and web accessibility standards.

Functional Support & Application Modernization

• Translate business requirements into comprehensive technical specifications, creating report inventories, data dictionaries, and run instructions.
• Perform functional configurations and support design activities using delivered tools like Page and Field Configurator, Drop Zones, Event Mapping, and Page Composer.
• Provide Level 2 Service Desk support, delivering advanced troubleshooting, complex ticket resolution, and clear functional documentation in coordination with Tier 3 managed services.
• Work closely with functional analysts and business owners to gather data requirements, validate logic, and ensure data integrity.

Testing, Security, & Release Support

• Support reporting operations during system upgrades, PUM cycles, and patch releases through impact analysis, report remediation, and migration coordination.
• Design, execute, and document structured user acceptance testing (UAT) and regression testing to verify data accuracy and output integrity.
• Enforce system security and multi-tenancy requirements, ensuring all reports respect role-based and row-level data access policies.
• Align daily operations with ITIL frameworks, actively participating in disaster recovery exercises, Major Incident Management (MIM), and technical audits (such as SOC-1 attestation).

Required Qualifications

• 8 or more years of experience in public sector environments directly working for or supporting state government agencies.
• 8 or more years of experience developing and supporting reports for HR and Payroll modules in PeopleSoft HCM version 9.2.
• 8 or more years of experience analyzing PeopleSoft HCM data structures, including effective dating rules, table relationships, and multi-row logic to support complex enterprise-wide reporting.
• 8 or more years of experience designing, executing, and documenting structured UAT and regression testing for reporting impacts during upgrades, PUM cycles, or patch deployments.
• 8 or more years of experience developing cross-module reports that integrate data from HR, Payroll, Time & Labor, and Position Management.
• 8 or more years of experience preparing WCAG 2.1-compliant digital materials and reports for public distribution.
• 8 or more years of experience in data integration, data quality management, and standard software development life cycle (SDLC) methodologies.
• 8 or more years of experience interpreting contractual requirements and holding technology vendors accountable to service-level agreements.
• 8 or more years of experience aligned with state-level administrative and reporting policies.
• 3 or more years of experience providing central production and expansion functional support for a large-scale system spanning 100 or more agencies and multiple hub instances.
• 3 or more years of experience utilizing ITIL principles and practices for IT service management (ITSM).

Preferred Qualifications

• 4 or more years of experience participating in fiscal year-end processes, specifically relating to state-level reorganizational changes and legislative mandates.
• 4 or more years of experience performing customer-facing responsibilities to support central and hub agency system expansion efforts.

Core Skills & Attributes

• Advanced logical analysis to solve complex data query, integration, and performance bottlenecks.
• Excellent communication and presentation skills suitable for User Groups, Steering Committees, and executive audiences.
• Strong collaborative ability to coordinate with functional analysts, policy specialists, and Managed Services Tier 3 support teams.
• High-level initiative to perform complicated tasks independently under minimal supervision.

Flexible work from home options available.