Programmer Analyst (WEBFOCUS & COBOL/Mainframe) Position Available In Leon, Florida

Programmer Analyst (WEBFOCUS & COBOL/Mainframe) Tech Army – 5.0 Tallahassee, FL Job Details Contract $55 – $65 an hour 1 day ago Qualifications Power BI DB2 Relational databases Writing skills Data structures Microsoft SQL Server Microsoft Office 3 years Master’s degree

SQL CICS

Analysis skills FOCUS Mainframe Accounting Mentoring COBOL Mainframe development Computer skills ISPF Online course Unit testing Systems analysis Senior level 10 years Full Job Description ExperienceCandidate MUST have: A minimum of 10 years of systems analysis and programming experience. A minimum of 5 years of FOCUS and WebFOCUS programming experience inclusive of FOCUS 4GL, WebFOCUS Application Studio and Report Caster. A Minimum of 3 years of Microsoft Power BI development experience inclusive of Power BI Desktop, Power BI Paginated Reports, and Power BI Dataflows. Structured Query Language (SQL) experience inclusive of SQL syntax, views and stored procedures. A minimum of 5 years of broad IBM Mainframe development experience inclusive of but not limited to

ISPF, JCL, COBOL, DB2

for z/OS or similar relational databases. Primary Job Duties/ Tasks The submitted candidate must be able to perform the following duties and/or tasks: Perform advanced technical assessments and define the impact on reporting and local computing applications as a result. Produce written deliverables including, but not limited to architectural diagrams, technical specifications and narratives, interface requirements, and supporting functional or technical analyses. Review interface offerings, file definitions, and standardized business processes to determine remediation required for Department financial related computing assets. Address dependencies with other interfacing computer applications. Propose potential decommissioning for unused computing assets. Address remediation requests for local computing applications and WEB based inquiries for budget management, program development, cost accounting, funds authorization/reimbursement, and funds approval functions. Coordinate with application owners to identify essential financial related information for complex reconciliation efforts and validation of end results. Provide detailed data element mapping of inputs and outputs with other systems interfacing with FDOT maintained applications impacted by the transition efforts. Inputs can include manual data entry, direct access to other systems, and batch uploads. Outputs can include data extracts, direct access to data from other systems, and reports. Participate in validation of data configuration workbooks and supporting data conversion analyses of Department data to align with revised data structures. Develop data conversion programs to convert data within Department financial related computing assets. Develop testing strategies, data scenarios and test plans to ensure computing asset modifications are tested properly beginning with unit testing and extending through cycle testing phases. Confer with Central Office and District personnel to ensure the Office of Comptroller systems are performing as required. Mentor, advise and assign tasks to junior staff to ensure remediation efforts are completed within the agreed upon timeframe. Job Specific Knowledge, Skills, and Abilities (KSAs)The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas: Skill in developing and maintaining FOCUS and Web FOCUS programs and access methods using FOCUS Masters and SQL Pass-through. Skill in developing and maintaining Power BI Desktop and Paginated Reports. Skill in developing and maintaining SQL (Structured Query Language) statements, Views, and Stored Procedures for MS SQL Server and DB2 databases. Ability to review programs for the afore-mentioned technologies and determine and document program flow, business rules/logic, inputs/outputs, and database actions included. Knowledge of the principles, practices and techniques of documenting, maintaining and testing existing computing applications. Knowledge of relational database theories and concepts. Knowledge of mainframe computer systems and supporting software such as Customer Information Control System (CICS), Time Sharing Option (TSO), Job Control Language (JCL) and Interactive System Productivity Facility (ISPF). Ability to work independently in the technical analysis, evaluation and resolution of custom-written computer application production issues or problems, with little or no assistance, and to make decisions and recommendations to remediate those issues or problems. Ability to plan, organize, coordinate, and prioritize work assignments for him/herself or lower-level analysts. Skill in accurately estimating time requirements for computer programming tasks in a computer application maintenance environment. Ability to work effectively with Project Managers, Business Analysts, Data Analysts, and Technical Architects to build efficient, viable solutions in the maintenance of business applications utilizing all established departmental standards. Skill in mentoring junior developers in WebFOCUS/FOCUS and Power BI. Ability to analyze processes and workflows to design efficient information solutions. Ability to prepare complex computer program specifications. Ability to prepare computer program test plan and to create test databases and test environments. Ability to interact and collaborate directly with customers, technical staff, and management. Skill in interpreting and communicating technical information both verbally and in writing. Ability to develop and manage technical documentation in accordance with the Department’s standards. Strong working knowledge of Microsoft Office. Experience working on accounting and financial computing applications and monitoring complex interfaces with external systems.

Preferred KSAs:

Accounting, Financial, Computer Science or Management Information Systems (MIS) related degree. Skill in data conversion techniques, data cleansing approaches and validating data relationships. Knowledge of the Florida Accounting Information Resource (FLAIR) system, including transaction type details and interfacing methods. Knowledge of the Office of Comptroller’s internal applications, reporting systems, and interfaces. Knowledge of the Office of Work Program and Budget’s internal applications, reporting systems, and interfaces. Knowledge of the new initiative and financial application.

Job Type:

Contract Pay:

$55.00 – $65.00 per hour

Schedule:

8 hour shift

Work Location:

In person