Job Title: MAINFRAME Developer / WebFocus Developer

Job Location: Tallahassee, FL (hybrid-3 days onsite)
Job Duration: 12-month contract
Job Overview:

• 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.

Required Experience:

• MUST have a minimum of 2 years' experience in Tibco Mainframe Focus or WebFocus.
• 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.

Preferred Experience:

• Knowledge of modern reporting tools such as MS Power BI, IBM Cognos, and Tableau
• Knowledge of the SCRUM Framework
• Knowledge of financial systems such as an ERP
• Familiarity with data management concepts such as Data Warehousing, Operational Data Stores, Data Lakes, and Master Data Management