Offer summary

Qualifications:

Minimum of 8 years of experience in data analysis and report writing., Proficiency in PeopleSoft FSCM 9.2, PeopleCode, Application Packages, and SQL., Experience with BusinessObjects, BI Publisher, and Oracle databases., Strong communication skills and ability to work remotely with diverse teams..

Key responsibilities:

Analyze and modify Capps data to create financial reports.

Develop and tune complex SQL scripts and stored procedures.

Collaborate with team members and communicate effectively in a remote environment.

Support application integration and assist with system upgrades.

Job description

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	Required	PeopleSoft FSCM 9.2
8	Required	PeopleCode and Application Packages
8	Required	Application Engine, COBOL, and SQR
8	Required	Integration Broker (REST, SOAP, JSON, XML)
8	Required	Advanced SQL and PL/SQL
8	Required	Development of reports using BusinessObjects
8	Required	Development and tuning of complex SQL scripts, stored procedures, and package development in large-scale database projects.
8	Required	Testing and implementation of standard and ad hoc reports
8	Required	Oracle11g/12c (with one or more of these versions)
8	Required	BI Publisher Reports and PS Queries
8	Required	AWE
8	Required	Analyzing functional design requirements
8	Required	Creating technical design documents
5	Required	Microsoft O365 applications (Word, Excel, PowerPoint, Teams, Visio)
5	Required	Common design practices/standards/technologies associated with application accessibility (e.g. WCAG, , ADA, Section 508)
4	Required	Developing complex BOBJ queries and reports using the CAPPS Financials system
4	Required	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.

Required profile