WebFocus developer

ducation:

Bachelor's Degree in a field of study related to technology or finance. Work experience can be substituted on a year-for-year basis for the degree.

Experience

Candidate MUST have a minimum of 2 years experience in Tibco Mainframe Focus or Web Focus. Experience with MS Power BI is preferred.

Primary Job Duties/ Tasks

The submitted candidate must be able to perform the following duties and/or tasks. Duties of the selected candidate will include, but not be limited to:

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

Job Specific Knowledge, Skills, and Abilities (KSAs)

· 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 KSAs:

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

General Knowledge Skills and Abilities (KSAs):

The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:

· Communication: Ability to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings (i.e., project team