Job Title: Web Focus Engineer
Term: Contract
Remote Status: Onsite
Hours: 40 Hour/ Week
Top Skills:
Candidate MUST have a minimum of 2 years' experience in Tibco Mainframe Focus or WebFocus. Experience with MS Power BI is preferred.
- Experience developing programs in mainframe Focus
- Experience developing processes and reports in WebFocus
- Familiarity with IBM mainframe and Job Control Language (JCL)
- Strong SQL skills and experience with the IBM DB2 relational database management system
- Well versed in data governance best practices
- Experience creating reports presenting financial data such as general ledger data, purchasing data, or revenue data
- Analytical thinking for creating relevant data reports based on end user requirements
- Understanding of how to implement solutions with multiple data sources
Responsibilities:
- Analyze current Focus programs and WebFocus reports and document the specifications for these programs and reports.
- Work with management to develop an overall remediation strategy for all Focus programs and reports.
- Analyze existing reports and work with business users to determine how these reports can be improved based on current business needs.
- Read and document WebFocus and Mainframe Focus queries and convert them to T-SQL queries.
- Work with database administrators from the Office of Information Technology to create database views and stored procedures that will facilitate the remediation of WebFocus reports.
- Update Focus programs to encapsulate chart of account changes mandated by Florida PALM.
- Update WebFocus Reports to encapsulate chart of account changes mandated by Florida PALM.
- Convert Focus mainframe programs using mainframe flat files as a data source to use database tables instead.
- Analyze financial data and make recommendations to improve the data model of financial systems.
- Provide administration of the WebFocus environment for the dedicated PALM remediation environment.
- Perform knowledge transfer with technical staff of the office of the Comptroller.