To Apply for this Job Click Here
Job Title: Application Development Analyst- WebFOCUS
Location: REMOTE
Job Type: Contract
Referral Fee:
Employment Eligibility: Gravity cannot transfer nor sponsor a work visa for this position. Applicants must be eligible to work in the U.S. for any employer directly
Duties and 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.
Required Experience and 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
- 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