Note: The job is a remote job and is open to candidates in USA. CrowdPlat is a Texas state agency seeking a Systems Analyst 3 to join its Fiscal Management Statewide Fiscal Systems team. The role involves providing senior-level consultative services and functional assistance in developing and maintaining complex reports using PeopleSoft and SAP Business Objects reporting tools.
Responsibilities
- Develop, modify, and maintain reports using PeopleSoft reporting tools (Query Manager/Query Viewer, BI Publisher/XML Publisher, PS/Query expressions and complex joins)
- Develop, modify, and maintain reports using 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 information technology security measures to safeguard system information
- Participate in project-level activities including expansions, module implementations or enhancements, cyclic processes (fiscal year-end, calendar year-end, legislative changes, federal mandates, third-party integrations)
- Create and/or review Functional Design Documents (FDDs) and perform functional configuration system changes using PeopleSoft delivered features (Page and Field Configurator, Drop Zones, Event Mapping, Page Composer, etc.)
- Provide Level 2 Service Desk support, including complex ticket handling, advanced troubleshooting, clear documentation, and basic system configuration
- Ensure all digital products and content meet WCAG 2.1 accessibility standards
- Validate that only accurate data is produced, security (including multi-tenancy) is enforced, the system performs efficiently, and all applicable policies are enforced
- Perform all work in accordance with Information Technology Infrastructure Library (ITIL) principles and practices
- Actively participate in Major Incident Management (MIM) process for P1 and P2 incidents
- Participate in Disaster Recovery and Upgrade Testing activities
- Make presentations at user groups and steering committee meetings
- Participate in annual SOC-1 attestation audits
- Complete a minimum of 10 hours of professional training annually in a relevant area of expertise (on personal time, at own expense)
Skills
- 8+ years of Texas public sector experience, directly working for or supporting a Texas state government agency
- 8+ years of experience in reporting support for the financial modules in PeopleSoft Financials version 9.2
- 8+ years of extensive knowledge and understanding of State of Texas applicable policy
- 8+ years of extensive knowledge of Financials Table Entity Relationship Diagrams
- 8+ years of experience preparing WCAG 2.1-compliant materials for distribution
- 8+ years of experience designing, executing, and documenting structured UAT and regression testing for reporting impacts during upgrades, PUM cycles, or patch deployments
- 8+ years of experience in interpreting contractual language and integrating it into daily workflows, while consistently holding vendors accountable to contractual requirements
- 8+ years of extensive knowledge of/experience with data integration, data quality, and SDLC processes and methodologies
- 8+ years of experience developing or supporting cross module reports that incorporate data from GL, AP, PO, AM, IN, T&E, PC, or related modules
- 8+ years of extensive experience analyzing PeopleSoft FSCM data structures, including effective dating rules, table relationships, and multi row logic, to support complex statewide reporting requirements
- 8+ years of experience writing complex reports using SAP Business Objects
- 3+ years of experience with CAPPS Central production and expansion functional support activities for more than 100 agencies and 5 Hub instances
- 3+ years of knowledge of Information Technology Infrastructure Library principles and practices for IT activities such as IT service management (ITSM) and IT asset management (ITAM)
- Experience in gathering business requirements for large projects
- Ability to work independently in a diverse team environment with on-site and remote team members
- Strong written, verbal, and interpersonal communication skills
- Knowledge of project management methodologies
- Knowledge of technical and functional attributes of Oracle PeopleSoft
- Problem-solving skills and the ability to multitask with readiness to put in extra efforts when necessary
- Experience with Agile and other SDLC methodologies
- Experience with ITIL methodologies
- Experience with or knowledge of information security frameworks (i.e., NIST)
- 4+ years of experience participating in Fiscal Year-End processes specific to reorganizational changes and legislative mandates for CAPPS
- 4+ years of experience performing customer-facing responsibilities in support of CAPPS expansion efforts for Central and Hub agencies
Benefits
- Primary work location is remote (telework); remote working location must be within the continental United States at all times
- On an infrequent ad-hoc basis, may be required to be at the agency's on-site location in Austin, Texas based on business need
Company Overview