Financial Business Analyst

Job ID: FL-PR520425-R91351

Hybrid/Local Financial BA (SCRUM Master/Product Owner) with BPR, workflow, PM, QA/testing, Visio, accounting systems/FLAIR, budgeting, mainframe programming, data cleansing, UML experience

Location: Tallahassee, FL (FDOT)
Duration: 22 Months
Position: 1

4 Scope of Services
Background: As a result of the Department s efforts to re-engineer and modernize core financial systems, there have been over 1,500 computing assets identified as performing some level of financial planning, analysis, and management functionality that are impacted by the State of Florida s accounting system. The Florida Planning, Accounting, and Ledger Management (PALM) project is a multiyear endeavor to replace the State of Florida s accounting and cash management systems with a modern financial management solution. The Florida PALM Project is targeted to replace Central, Payroll, and Departmental FLAIR functionality, with go-live scheduled for January 6, 2026.
The 1,500+ computing assets are comprised of interfaces, enterprise applications, databases, automated processes, and reporting programs within FDOT that will require remediation due to:
Adoption of the Florida PALM Standardized Business Process Model
Transition to the Florida PALM Chart of Accounts values
Replacement of Central, Payroll and Departmental FLAIR functionality
Redevelopment of agency incoming and outgoing interfaces to the statewide accounting system
Implementation of Information Warehouse data to support agency specific reporting requirements.
The computing asset modifications to complete the FDOT PALM System Transition (FPST) will take place over the course of three years in alignment with the Florida PALM Project scheduled timeline.
Problem Statement: Modifications to the Department s computing assets are necessary to align with the Florida PALM solution and are essential to the continuity of FDOT business. The selected candidate will be assigned initially to analyzing and documenting the Department s payroll distribution process and the Florida PALM project s
reengineering of journal vouchering processes impact on critical business functions, supporting business processes, and related computing assets. Additional focus will be on analyzing related financial planning and analysis systems and dependent business processes owned by the Department and assisting in re-engineering in areas impacted by the Florida PALM Standardized Business Process Model and redeveloped interfaces. As part of this effort, a fit-gap determination must be made comparing the Department s computing assets functional scope with the Florida PALM Standardized Business Process Model to recommend those assets that may be decommissioned and addressed with the functionality within the Florida PALM solution.
The selected candidate will be given access to existing documentation and staff and be required to identify functional gaps, develop, and document business rules and processes supporting critical functions. Documentation
will be completed with advice from Department staff in a desk procedure template or other formats conducive to communicating the information.

5 Education
Bachelor s Degree in Computer Science, Information Systems, or financial related field and two years professional work experience. Work experience can substitute on a year for year basis for the degree. Special consideration will be given to candidates with Six Sigma certification or similar business analysis and engineering certifications.

6 Experience
Candidate must have a minimum of 2 years experience in business process reengineering and documentation. This experience must also be in a professional environment in a financial discipline. Candidate will be expected to describe multiple past experiences with business process tools and how they were deployed for a successful outcome. Candidate must have experience with Structured Query Language (SQL) and querying databases effectively.

7 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:
1. Participate in efforts to define the impact on Department computing assets from the implementation of Florida PALM standard business process model, chart of accounts, and PeopleSoft solution. Produce deliverables including, but not limited to business process diagrams and narratives, business requirements, program specifications, and supporting business processes, data conversion and technical impact analyses.
2. Use subject matter expertise, industry methodologies and best practices, and automated tools to analyze and make recommendations on behalf of the Department for required changes to complex financial-related business processes to align with the Florida PALM solution.
3. Detail data element inputs and outputs for Department computing assets interfacing with Department of Financial Services FLAIR. Inputs may include, but not limited to, manual data entry, direct access via scripting solutions, and batch uploads. Outputs can include data extracts, outgoing interfaces, and reports.
4. Prepare specifications to communicate Department specific functional requirements for the FPST transition efforts and address dependencies with other interfacing computing assets and external stakeholder interfaces. Oversee the development of testing strategies, data scenarios, and test plans to ensure functional requirements are addressed.
5. Assist in the business process redesign and documentation as needed to support ongoing FPST efforts in the enterprise environment.
6. Work with functional and enterprise system support staff during technical assessments of the Department s internal financial-related systems and interfaces from/to the Florida PALM solution.
7. Document business cases and feasibility studies. Facilitate work sessions to elicit and prioritize remediation requirements. Identify any functionality seen as needed, but missing, in Department maintained systems. Include analysis of outstanding remediation requests.
8. Translate high level business requirements into detailed business documents and/or functional specifications.
9. Coordinate the development of project schedules, implementation plans, and documentation for computing asset remediation. Present to management, customer, and technical staff.
10. Assist with User Acceptance Testing and Florida PALM cycle testing; Confer with Central Office and District personnel to ensure Department financial-related systems are performing as required.
11. Evaluate critical information gathered from multiple resources. Summarize detailed data into executive level formats as well as breaking down aggregate information into meaningful pieces.
12. Develop standardized desk procedures that include the purpose, prerequisites, process flows and narratives of business processes.
13. Help manage user stories, the project backlog, and sprint backlogs.
14. Prepare proposed business rules, develop, monitor, and implement knowledge transfer activities.
15. Participate in SCRUM meetings including daily stand-ups, sprint planning, and sprint retrospectives.
16. Write SQL queries to be used in the creation of database views that will be used as the data source for financial reports.

8 Job Specific Knowledge, Skills, and Abilities (KSAs)
The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:
1. Knowledge of financial management best practices which can be translated to transportation financial practices.
2. Ability to produce legible and complete functional documentation in a way that thoroughly captures business processes and inputs/outputs of the applications.
3. Ability to analyze and accurately and completely define processes and workflows to design efficient information solutions, including missing or duplicate functionality in existing applications.
4. Ability to work effectively with users and a project team, to identify and document requirements for the maintenance, enhancement, or development of computer application systems, including technical overviews and context diagrams.
5. Ability to develop and manage business and information systems technical documentation in accordance with the Department s standards.
6. Knowledge of relational database theories and concepts.
7. Skill in testing complex applications and interpreting whether requirements and designs were met in the product.
8. Ability to plan, organize, coordinate, and prioritize work assignments for him/herself or lower-level analysts.
9. Skill in accurately preparing schedule estimates for requirements analysis and computer programming tasks in a computer application maintenance environment.
10. 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.
11. Ability to prepare complex computer program specifications.
12. Ability to prepare computer program test plans and to create test databases and test environments.
13. Ability to interpret and communicate technical information related to computer programming and data processing, both verbally and in writing.
14. Advanced skills with Microsoft products: Word, Excel, PowerPoint, and Visio.
15. Experience working on accounting and financial computing applications and monitoring complex interfaces with external systems.
16. Knowledge of Agile Project Management methodologies and practices.
17. Knowledge of the SCRUM Framework.
18 . click apply for full job details