Description

You will manage the analysis, documentation, and remediation of Focus programs and WebFocus reports for the PALM project, converting mainframe queries to T-SQL and migrating data sources.

This role is on-site.

Responsibilities

• Analyze existing Focus programs and WebFocus reports to document specifications and develop remediation strategies.
• Convert WebFocus and Mainframe Focus queries into T-SQL queries.
• Update Focus programs and WebFocus reports to incorporate Florida PALM chart of account changes.
• Migrate Focus mainframe programs from flat file data sources to database tables.
• Collaborate with DBAs to create database views, stored procedures, and administer the WebFocus environment.

Required Skills

• Minimum of 2 years of experience in Tibco Mainframe Focus or WebFocus.
• Experience developing programs in mainframe Focus and processes in WebFocus.
• Strong SQL skills and experience with IBM DB2 relational database management systems.
• Familiarity with IBM mainframe and Job Control Language (JCL).
• Experience creating financial reports involving general ledger, purchasing, or revenue data.
• Knowledge of data governance best practices and ability to implement solutions using multiple data sources.
• Bachelor's degree in technology or finance, or equivalent years of professional experience.

Preferred Skills

• Experience with MS Power BI, IBM Cognos, or Tableau.
• Knowledge of SCRUM Framework, Data Warehousing, Data Lakes, or Master Data Management.

Key Skills

Education

Bachelor's degree