Systems Analyst 3

Lumen Solutions Group, Inc.

Austin, TX

Apply

JOB DETAILS

SKILLS

Accounting, Analysis Skills, Asset Management, Auditing, Background Investigation, Business Intelligence, CGI (Common Gateway Interface), Certified Public Accountant (CPA), Communication Skills, Computer Security, Contract Analysis, Contract Requirements, Cross-Functional, Cross-Training, Customer Relations, Customer Support/Service, Data Quality, Data Sets, Design Document, Disability Accommodations, Disaster Recovery, Documentation, ERP (Enterprise Resource Planning), FMLA (Family and Medical Leave Act of 1993), Federal Laws and Regulations, Financial Management, Financial Systems, Government, HRIS/HRMS, Human Resources, Human Resources Software, Hyperion SQR, IT Service Management (ITSM), ITIL (IT Infrastructure Library), Identify Issues, Incident Management, Information Technology & Information Systems, Information/Data Security (InfoSec), JCL (Job Control Language), Language Interpreter, Legal, Mainframe Computer, Maintain Compliance, Online Communications, Oracle, Organizational Skills, PS Query, Payroll Accounting, Payroll Software/Services, PeopleSoft HRMS (Human Resource Management System), Peoplesoft, Performance Management, Procedure Development, Process Development, Process Management, Production Support, Production Systems, Project/Program Coordination, Project/Program Management, Purchase Orders, Requirements Management, SAP BusinessObjects, SQL (Structured Query Language), Software Design, Software Development Lifecycle (SDLC), Staff Policies, State Government, System Integration (SI), Systems Administration/Management, Systems Analysis, Talent Management, Team Player, Technical Support, Technical/Engineering Design, Test Data, Testing, Time Management, Training/Teaching, User Groups, User Interface/Experience (UI/UX), Vendor/Supplier Management, Vendor/Supplier Selection, Web Content Accessibility Guidelines (WCAG), Web Programming, Web Services

LOCATION

Austin, TX

POSTED

2 days ago

I. DESCRIPTION OF SERVICESTexas Comptroller of Public Accounts requires the services of 1 Systems Analyst 3, hereafter referred to as Candidate(s), who meets the general qualifications of Systems Analyst 3, Applications/Software Development and the specifications outlined in this document for the Texas Comptroller of Public Accounts.

All work products resulting from the project shall be considered "works made for hire" and are the property of the Texas Comptroller of Public Accounts and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Texas Comptroller of Public Accounts will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

BACKGROUND.
CPA s existing vendor contract expires August 31, 2026, with no further renewal options remaining. CPA is seeking to enter into a new contract to continue the Services, as described below, without interruption.
This solicitation supports the following expiring CPA contract(s), identified by the associated CPA Purchase Order (PO) number(s): CPA PO# 304-26-1922.
For information regarding CPA's CAPPS Program, visit: https://fmx.cpa.texas.gov/fmx/erp/.
SCOPE OF SERVICES.
Services Overview. The selected Vendor's Candidate will be part of CPA's Fiscal Management Statewide Fiscal Systems team, supporting the Centralized Accounting and Payroll/Personnel System (CAPPS) Program. The CAPPS Program for this engagement comprises the following components: HR/Payroll (inclusive of Recruit functionality), Financials, STARR, and all ancillary systems. The selected Vendor's Candidate must be adaptable and able to learn and integrate new systems and platforms as needed, such as CGI Advantage.
CAPPS System Defined. CAPPS HR/Payroll is the *** ERP system. It is based on Oracle PeopleSoft Human Capital Management (HCM) version 9.2 Image 53. The system includes the following modules: Human Resources, Payroll, Position Management, Time and Labor, Performance Management, and CAPPS Recruit, utilizing TAM/CG.
Mainframe Defined. The mainframe systems include Human Resource Information System (HRIS) and Standardized Payroll/Personnel Reporting System (SPRS). Both are considered legacy applications primarily coded in COBOL (Common Business Oriented Language).
Annual Professional Training Requirement. In addition to other CPA training requirements, the following professional training requirement applies on an annual basis during the CPA Contract Term, including each renewal term, under the CPA Contract resulting from this solicitation:
For no compensation from CPA, the selected Vendor's Candidate shall be required to complete a minimum of ten (10) hours of professional training in a relevant area of expertise associated with the Services provided under the CPA Contract.
The professional training, as determined by the Vendor and/or the selected Vendor's Candidate, shall be conducted and completed by the selected Vendor's Candidate on personal time. If the professional training is intended to be conducted during the CPA-approved work schedule, the selected Vendor's Candidate must coordinate the associated time off with the CPA Supervising Manager, as applicable.
The Vendor and/or the selected Vendor's Candidate shall be fully responsible for all associated costs, including but not limited to tuition, materials, conference fees, and/or travel expenses. CPA will not approve or make payment for any hours associated with the professional training requirement.
By July 31st of each CPA Contract Term, the Vendor shall provide the CPA Contract Manager (***) with an annual professional training report, documenting the completed professional training hours and courses.
Position Requirements. The CPA Work includes, but is not limited to, the following:
Performing highly advanced (senior-level) consultative services and functional assistance work related to supporting the CAPPS Program.
Responsible for functional HR expertise, including, but not limited to:
Workforce Administration
TAM/CG
HR Security Set-up and row-level security
Interpret and apply state statutes, HR policies, and labor regulations
Responsible for functional configuration skills, including, but not limited to:
Setting up tables (job codes, positions, departments, compensation, etc.)
Understanding HR business units, Set IDs, and Table structures
Configuring workflow (AWE-Approval Workflow Engine)
Creating queries using PS/Query and SAP Business Objects
Responsible for ensuring CAPPS adheres to the Family Medical Leave Act (FMLA), including, but not limited to:
Defining and refining FMLA plans and entitlements
Customizing appropriate leave types
Ensuring module integration with Payroll and the Time and Labor modules
Assisting with compliance reporting and auditing
Responsible for technical skillsets for applicable tools, including, but not limited to:
Understanding Application Designer (records, fields, pages, components)
Integration Broker (Web Services, REST/SOAP Integrations)
SQR and BI Publisher report customization
SQL Proficiency
Understanding of PeopleSoft security, inclusive of *** multitenancy requirements
Planning, designing, developing, implementing, supporting, and maintaining the information technology security measures to safeguard system information.
Responsible for tools and environment knowledge, including, but not limited to:
PUM (PeopleSoft Update Manager) and Change Assistant
Fluid UI changes and page navigation
Lifecycle management and selective adoption
Elasticsearch/Search Framework
Data migration and compare reports
Responsible for Position Management, including, but not limited to:
o Troubleshoot position management issues
o Maintain and update position data
o Analyze downstream impact
o Support workflow troubleshooting
o Validate configuration settings
o Perform data fixes
o Assist with audit and compliance checks
o Support integrations
o User guidance and training support
o Regression testing and upgrades
o Documentation creation and maintenance
Responsible for mainframe support, including, but not limited to:
o Incident resolution
o Analyze abends (application or batch job failures) and determine root causes
o Review logs, Job Control Language (JCL), console messages, SQL codes, and error dumps.
o Job and batch monitoring
o Validate upstream and downstream dependencies.
o Ensure production environments remain stable and performant.
o Application support and analysis
o Understand the business functionality of the mainframe applications.
o Validate that changes to JCL, batch streams, or configurations work as intended.
o Documentation and knowledge management
o Work with cross functional teams during incidents (infra, DBAs, network, app dev all in the CPA Information Technology Division).
o Participating in Fiscal Year-End processes specific to reorganizational changes and legislative mandates for CPA mainframe systems.
o Compiling and analyzing mainframe datasets needed for historical employee information, Per Print file investigation, and staging test data.
o Performing employee- and agency-level entries and table updates in SPRS, including new entitlements or deductions.
o Supporting CPA mainframe systems by serving as the ACR Coordinator for system changes, ensuring proper documentation and coordination.
o Coordinating CPA mainframe environment refreshes, validating post-refresh system integrity, and ensuring proper synchronization across dependent systems.
Responsible for cross-functional collaboration, including, but not limited to:
Strong problem-solving and troubleshooting
Ability to interpret the *** HR policies into system configuration and code modifications
Requirements gathering for applicable break/fix or system enhancements
Documentation and testing (UAT, regression testing)
Incident management in systems like ServiceNow and BOSSDesk, with the ability to keep multiple systems synchronized with timely updates
Communication skills when working with policy personnel, other analysts, 100+ agencies, and our Managed Services Tier 3 vendor.
Understanding and accounting for interdependence on legacy systems (SPRS, HRIS, etc.).
Providing structured cross-training to support junior analyst capability growth.
Providing comprehensive training and support to agency personnel in accordance with established requests and organizational requirements.
Responsible for project-level coordination and participation, including, but not limited to:
Expansions that include additional module implementations or enhancements for agencies
Cyclic processes such as fiscal year-end, *** legislative changes, federal mandates, and third-party integrations.
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 providing functional support for the CAPPS HR/PY applications, and shall be a point of contact for CAPPS agencies as applicable.
Responsible for the CAPPS HR/PY functional design phase, which includes creating and/or reviewing Functional Design Documents (FDDs), performing functional configuration system changes, and other functional activities assigned. Functional configurations include, but are not limited to, PeopleSoft delivered features (e.g., Page and Field Configurator, Drop Zones, Event Mapping, Page Composer, and others).
Performs all duties following CPA s processes, policies, and procedures within project scope and on schedule in accordance with milestones, deliverables, and due dates.
Provides Level 2 Service Desk support, including complex ticket handling, advanced troubleshooting, clear documentation, and basic system configuration, all following established, auditable processes in coordination with a Managed Services vendor responsible for Tier 3 work.
Responsible for ensuring that all digital products and content meet WCAG 2.1 accessibility standards. This includes 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.
Works 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.
Responsible for validating that only accurate data is produced, security, including multi-tenancy, is enforced, that the system performs efficiently, and that all applicable policies are enforced.
Performs 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 participates in CPA s Major Incident Management (MIM) process for P1 and P2 incidents according to module responsibilities.
Participates in Disaster Recovery and Upgrade Testing activities.
Makes presentations at CAPPS User Groups and the CAPPS Steering Committee.
Participates as directed in an annual SOC-1 attestation audit designed 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.
Performing other related Work as assigned.II. CANDIDATE SKILLS AND QUALIFICATIONSMinimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Years Required/Preferred Experience
8 Required Extensive Texas public sector experience, directly working for or supporting a Texas state government agency
8 Required Extensive experience supporting the HR module in PeopleSoft HCM version 9.2
8 Required Extensive knowledge and understanding of *** applicable policy.
8 Required Extensive knowledge of federal labor laws.
8 Required Experience preparing WCAG 2.1-compliant materials for distribution.
8 Required Experience performing functional project management activities in support of CPA s CAPPS program
8 Required Experience in interpreting contractual language and integrating it into daily workflows, while consistently holding vendors accountable to contractual requirements
8 Required Extensive knowledge of/experience with data integration, data quality, and SDLC processes and methodologies
3 Required Experience with CAPPS Central production and expansion functional support activities for more than 100 agencies and 5 Hub instances.
3 Required Experience participating in Fiscal Year-End processes specific to reorganizational changes and legislative mandates for CPA mainframe systems
3 Required Experience compiling mainframe datasets needed for historical employee information, Per Print files investigation, and staging test data
3 Required Experience performing employee and agency-level entry and table updates related to new entitlements or deductions in SPRS
3 Required Experience supporting the CPA mainframe systems by acting as the ACR Coordinator for system changes
3 Required CPA experience coordinating mainframe environment refreshes
3 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 Preferred CPA experience supporting the FMLA module to enter and track FMLA balances for all FMLA plan types in the CAPPS system
4 Preferred CPA experience participating in Fiscal Year-End processes specific to reorganizational changes and legislative mandates for CAPPS
4 Preferred CPA experience supporting CAPPS by loading mass salary actions for agencies
4 Preferred CPA experience performing customer-facing responsibilities in support of the CAPPS expansion efforts for Central and Hub agencies
4 Preferred CPA experience gathering requirements and writing functional specifications to implement legislatively mandated benefit enrollment programs using web services to communicate between different state agencies for CAPPS
4 Preferred CPA experience performing SQL actions needed to keep the CAPPS, and SPRS systems in sync
4 Preferred Experience with and knowledge of CPA s legacy Statewide Financial Systems production support activities

About the Company

Lumen Solutions Group, Inc.

Resume Resources

Free Resume Templates Free Resume Builder