Data Analyst / Report Writer

The Texas Department of Criminal Justice requires the services of a Data Analyst Report / Writer - PeopleSoft / Capps Financials Developer who meets the general qualifications of Data Analyst Report Writer - 3. The report writer will be part of a dedicated PeopleSoft Financials upgrade project team.

The core duties include analyzing and modifying Capps data and creating financial reports as requested by the business unit, utilizing PeopleSoft Query Manager.

Must demonstrate and excel in communicating and working with a diverse team, using collaboration tools competently in a remote work environment. Must be able to work off-hours at different phases of the project.

Proficiency in Microsoft Office 365 applications, including Word, Excel, PowerPoint, and Visio (minimum of four tools).

Requirements

Years

Required / Preferred

Experience

PeopleSoft FSCM 9.2

PeopleCode and Application Packages

Application Engine, COBOL, and SQR

Integration Broker (REST, SOAP, JSON, XML)

Advanced SQL and PL / SQL

Development of reports using BusinessObjects

Development and tuning of complex SQL scripts, stored procedures, and package development in large-scale database projects.

Testing and implementation of standard and ad hoc reports

Oracle11g / 12c (with one or more of these versions)

BI Publisher Reports and PS Queries

AWE

Analyzing functional design requirements

Creating technical design documents

Microsoft O365 applications (Word, Excel, PowerPoint, Teams, Visio)

Common design practices / standards / technologies associated with application accessibility (e.g. WCAG, , ADA, Section 508)

Developing complex BOBJ queries and reports using the CAPPS Financials system

Supporting application integration using SAP BusinessObjects SDK

Preferred

Texas CAPPS implementation

Benefits

This remote position may occasionally require the contractor to work on-site. The office is 815 11th St, Huntsville, TX 77340. In-person meetings may be required in Huntsville, TX, and advance notice will be given. Travel expenses are not covered or reimbursed by the Agency.

This position may be required to work non-standard hours depending on project needs.

All work must be performed with TDCJ hardware only. A laptop and any required peripherals will be provided.

Must be able to pass a CJIS background check.