Remote Customer Master Data Analyst Jobs in Texas

Remote - United States
I. DESCRIPTION OF SERVICES
SCOPE OF SERVICES.
Services Overview. The 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 Candidate must be adaptable and able to learn and integrate new systems and platforms as needed, such as CGI Advantage.
CAPPS System Defined. CAPPS Financials is the State of Texas Enterprise Resource Planning (ERP) system, built on Oracle PeopleSoft Financial Supply Chain Management (FSCM) version 9.2, Image 53. The system includes General Ledger, Accounts Payable, Purchasing/Requisition, Asset Management, Commitment Accounting, Travel & Expense, Project Costing, Contracts, Grants, Inventory, Cash Receipts and AR/Billing.
The selected candidate must exhibit extensive knowledge of the CAPPS Financials reporting tools, with proficient knowledge of PeopleSoft's integration with all other deployed modules and ancillary tools and systems.
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.
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 CAPPS Accounts Receivable (AR) and Cash Receipts (CR) module subject matter expertise, including, but not limited to:
o Module Coordination and Expertise
o Production Support and Issue Resolution
o Configuration and Maintenance
o Business Process Leadership
o Change Management and Enhancements
o Testing (Functional and UAT coordination)
o Integrations with other Modules
o Compliance and Policy Alignment
o Training and User Support
o Reporting and Analytics
o Release Management and Patch Release
• Responsible for functional configuration skills, including, but not limited to:
o Setting up AR Business Units
o Defining Customer Master Data and Customer Groups
o Configuring Payment Methods and Payment Terms
o Setting up Entry Types, Entry Reasons, and Distribution Codes
o Configuring Accounting Rules and ChartField Defaults
o Defining Aging IDs and Collection Rules
o Setting up Item Groups and Item Types
o Configuring Receivable Update and Posting Options
o Defining Write-Off and Adjustment Rules
o Configuring Collection Processes
o AR Security Roles and User Access knowledge
o Loading CAPPS - Cash Receipts
o Process Receipts
o CR Definition setup, Fee Codes Reference Types and Fee Codes Maintenance
o Integration with Cash receipts, Accounts Payable, Purchasing, Asset Management, and Project Costing
• Responsible for technical skillsets for applicable tools, including, but not limited to:
o Understanding Application Designer (records, fields, pages, components)
o SQR and BI Publisher report customization
o SQL Proficiency
o Understanding of PeopleSoft security, inclusive of State of Texas multitenancy requirements
o Planning, designing, developing, implementing, supporting, and maintaining the information technology security measures to safeguard system information.
• Responsible for monitoring all CAPPS AR batch jobs, including, but not limited to:
o Tracking job schedules
o Monitoring job execution
o Detecting and responding to failures
o Validating output
o Managing dependencies
o Performance tuning
o Documentation
o Proper communication and escalation
o Ensuring compliance when schedules must be altered
• Responsible for tools and environment knowledge, including, but not limited to:
o PUM (PeopleSoft Update Manager) and Change Assistant
o Fluid UI changes and page navigation
o Lifecycle management and selective adoption
o Elasticsearch/Search Framework
o Data migration and compare reports
• Responsible for cross-functional collaboration, including, but not limited to:
o Strong problem-solving and troubleshooting
o Requirements gathering for applicable break/fix or system enhancements
o Documentation and testing (UAT, regression testing)
o Incident management in systems like ServiceNow and BOSSDesk, with the ability to keep multiple systems synchronized with timely updates
o 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 (USAS, TINS, 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:
o Expansions that include additional module implementations or enhancements for agencies
o Understanding and accounting for interdependence on legacy systems (USAS, TINS, etc.).
o Cyclic processes such as fiscal year-end.
o State of Texas legislative changes, federal mandates, and third-party integrations.
o 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 coordination of the Fiscal Year-End, including but not limited to:
o Planning, scheduling, and communicating
o Reconciliations and Verifications
o System Configurations and Maintenance
• Responsible for the CAPPS Financials 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 overseeing and acting as the first line of support to ensure 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 as requested.
• 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.
ADDITIONAL REQUIREMENTS:
• Have experience in gathering business requirements for large projects
• Work independently in a diverse team environment with on-site and remote team members.
• Have strong written, verbal, and interpersonal communication skills.
• Have knowledge of project management methodologies.
• Have knowledge of technical and functional attributes of Oracle PeopleSoft.
• Have problem-solving skills and the ability to multitask with readiness to put in extra efforts when necessary.
• Have experience with Agile and other SDLC methodologies.
• Have experience with ITIL methodologies.
• Have experience with or knowledge of information security frameworks (i.e., NIST).
II. CANDIDATE SKILLS AND QUALIFICATIONS
Minimum 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
15
Required
Extensive knowledge and experience performing system configuration changes.
12
Required
Extensive knowledge and understanding of State of Texas applicable policies.
12
Required
Extensive technical skillsets needed with App Designer, Integration Broker, assorted SQR/SQL, BI Publisher, SAP Business Objects, etc. to support functional responsibilities.
12
Required
Experience working with the Accounts Receivable/Billing non-core module of PeopleSoft FSCM version 9.2
10
Required
Extensive knowledge supporting and providing oversight with batch jobs, i.e., Run My Jobs (RMJ)
10
Required
Extensive knowledge of security best practices, NIST standards, and multi-tenancy applicability for a statewide ERP instance.
10
Required
Extensive Texas public sector experience, directly working for or supporting a large network (30 or more) of Texas state government agencies
10
Required
Extensive experience creating and managing a strategic roadmap by combining strong planning skills, functional insight, and effective cross-functional communication
10
Required
Extensive familiarity with support tools such as PUM, Fluid and Elastic Search
10
Required
Experience performing functional project management activities in support of CPA's CAPPS program
10
Required
Experience providing Tier 2 Service Desk Support for a large network (30 or more) of agencies with a Managed Services vendor providing Tier 3.
10
Required
Experience supporting Priority 1 and Priority 2 incidents in coordination with the Major Incident Management (MIM) process.
10
Required
Experience participating in Disaster Recovery exercises.
10
Required
Experience preparing and presenting executive-level presentations.
10
Required
Extensive experience supporting the CAPPS Financials tower in PeopleSoft FSCM version 9.2
10
Required
Experience developing requirements, analyzing, designing, developing, testing, and implementing components of two or more of CPA's statewide systems: CAPPS, TINS, SPA, and USAS
10
Required
Experience planning and coordinating the Fiscal Year Process at a statewide level
8
Required
Experience gathering and presenting applicable data in support of a variety of audits and open records requests.
8
Required
Experience in interpreting contractual language and integrating it into daily workflows, while consistently holding vendors accountable to contractual requirements
8
Required
Experience preparing WCAG 2.1-compliant materials for distribution.
8
Required
Experience working with the General Ledger/Commitment Control core module of PeopleSoft FSCM version 9.2
8
Required
Experience working with the Asset Management core module of PeopleSoft FSCM version 9.2
5
Required
Experience working with the CAPPS Financials Accounts Receivable/Billing module
5
Required
Experience working with the CAPPS Financials Cash Receipts module
3
Required
Knowledge of 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
12
Preferred
Experience working with the Accounts Payable core module of PeopleSoft FSCM version 9.2
12
Prefe