Remote 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

8

PeopleSoft FSCM 9.2

8

PeopleCode and Application Packages

8

Application Engine, COBOL, and SQR

8

Integration Broker (REST, SOAP, JSON, XML)

8

Advanced SQL and PL/SQL

8

Development of reports using BusinessObjects

8

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

8

Testing and implementation of standard and ad hoc reports

8

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

8

BI Publisher Reports and PS Queries

8

AWE

8

Analyzing functional design requirements

8

Creating technical design documents

5

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

5

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

4

Developing complex BOBJ queries and reports using the CAPPS Financials system

4

Supporting application integration using SAP BusinessObjects SDK

1

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.