Job Description

Position: BI Reports Developer

Place of Performance: Remote - Tallahassee, FL

Visa: Any, no H1Bs, OPTs & CPTs

Education:

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.

Thanks & Regards

Juhi Sinha

Technical Recruiter

E-Mail:  juhi@exarcainc.com

Job Tags

Similar Jobs