Business Analyst/Programmer(Need Locals)

Overview

• The Business Analyst/Programmer (BAP) acts as an intermediary between the Florida Department of Commerce and the Florida PALM Project Team.
• The BAP evaluates existing business processes, identifies opportunities for automation and efficiency improvements, develops technical solutions, redesigns business processes, documents requirements, and supports the agency's transition to the Florida PALM environment.
• Department of Commerce is looking for a senior Business Analyst/Process Improvement Consultant who can bridge the gap between business users and technology teams, help modernize legacy MS Access and SQL Server processes, redesign workflows, document requirements, develop reporting solutions, and support the agency's successful transition to Florida PALM.

• The strongest resumes will demonstrate experience in ERP implementations, business process reengineering, data analytics, SQL Server, Tableau, SharePoint, and government financial system modernization projects.

The position combines:

• Business Analysis
• Process Improvement
• Requirements Management
• Data Analysis
• Reporting & Analytics
• System Modernization
• Stakeholder Coordination

Required Qualifications

The RFQ specifies the following qualifications:

Required Knowledge & Experience

Knowledge and experience with Florida PALM.

• Knowledge of Florida PALM Readiness Workplan.
• Experience with:
• Microsoft Access
• SQL Server
• SQL Server Analysis Services (SSAS)
• Alteryx
• SharePoint
• Tableau
• Experience managing and completing complex business and technology projects.

Ideal Candidate Profile

A strong candidate would have:

Business Analysis

• Requirements gathering
• Business process mapping
• Gap analysis
• Functional specification development

Data & Reporting

• SQL Server
• SSAS
• Tableau
• Data analytics
• Reporting modernization

Process Improvement

• Workflow redesign
• Automation initiatives
• Change management
• Business transformation

Government / ERP Experience

• State government systems
• ERP implementations
• Financial systems modernization
• Florida PALM, PeopleSoft, Oracle Financials, Workday, SAP, or similar ERP environments

Preferred Qualification

Required Qualifications

• Experience as a Business Analyst supporting large-scale business or IT initiatives.
• Knowledge of business process analysis, requirements gathering, and process redesign methodologies.

Experience with:

• Microsoft Access
• SQL Server
• SQL Server Analysis Services (SSAS)
• SharePoint
• Tableau
• Alteryx

Experience preparing business requirements documents (BRDs), functional specifications, process maps, and workflow documentation.

Experience working with business stakeholders and technical teams.

Experience supporting complex enterprise-wide projects.

Position Summary / Job Description

Essential Duties and Responsibilities

• Analyze existing business processes, workflows, and operational procedures to identify efficiencies and improvement opportunities.
• Serve as a liaison between agency business units and the Florida PALM Project Team.
• Gather, document, and validate business and functional requirements.
• Translate business requirements into detailed functional specifications.
• Assist in redesigning and documenting business processes impacted by Florida PALM implementation.
• Identify and recommend automation opportunities to reduce manual processes.
• Support migration and modernization efforts involving Microsoft Access and SQL Server-based applications and reports.
• Develop and maintain reporting and analytics solutions utilizing SQL Server Analysis Services (SSAS), Alteryx, SharePoint, and Tableau.
• Facilitate communication among stakeholders throughout project implementation.
• Participate in readiness planning, change management, and transition activities.
• Monitor project impacts on business operations and recommend mitigation strategies.
• Prepare status reports, process documentation, requirements documents, and other project deliverables.
• Participate in project meetings, readiness workshops, and stakeholder sessions.
• Provide ongoing support for Florida PALM readiness and implementation activities.

Scope of Work

Business Process Analysis

The BAP will:

• Analyze Commerce's operational processes.
• Evaluate strengths and weaknesses of current workflows.
• Identify opportunities to automate manual processes.
• Recommend process improvements and system enhancements.
• Support modernization initiatives related to Florida PALM.

Business Process Redesign

The BAP will:

• Redesign business processes impacted by Florida PALM.
• Document current-state and future-state processes.
• Ensure business processes align with new technology.
• Support organizational changes resulting from system implementation.

Requirements Management

The BAP will:

• Gather and analyze business requirements.
• Translate business requirements into functional specifications.
• Maintain requirements documentation.
• Manage changes to functional specifications.
• Ensure solutions meet business objectives.

Technical Solution Development

The BAP will:

• Evaluate technology solutions.
• Recommend process automation opportunities.
• Identify innovative approaches for improving agency operations.
• Utilize knowledge of technology trends to enhance business capabilities.

Data Conversion and Reporting Modernization

A major responsibility of this role includes modernizing existing systems and reports.

The BAP will assist with converting and enhancing existing processes utilizing:

• Microsoft Access
• SQL Server
• SQL Server Analysis Services (SSAS)
• Alteryx
• SharePoint
• Tableau

to ensure mission-critical processes and reporting continue to function successfully after Florida PALM implementation.

Stakeholder Coordination

The BAP will:

• Work with the Commerce Liaison (CL).
• Support the Change Champion Network (CCN).
• Coordinate with business units.
• Facilitate communication between Commerce and Florida PALM Project teams.
• Support readiness and change management activities.

Deliverables

Business Process Requirements, Redesign and Documentation

The RFQ identifies one primary deliverable for the Business Analyst.

Required Deliverables

1. Business Process Assessment

• Evaluate existing business operations.
• Identify process improvement opportunities.
• Assess readiness impacts.
• Analyze operational workflows.

2. Technical Solution Recommendations

• Recommend automation opportunities.
• Propose process improvement solutions.
• Support technology modernization efforts.
• Develop approaches that improve efficiency and effectiveness.

3. Business Process Redesign

• Redesign affected business processes.
• Develop future-state workflows.
• Align processes with Florida PALM requirements.
• Support implementation of redesigned processes.

4. Requirements and Functional Specifications

• Gather business requirements.
• Create functional specifications.
• Document system requirements.
• Manage specification changes.
• Maintain supporting documentation.

5. Communication and Stakeholder Support

• Facilitate communication between business units.
• Support stakeholders throughout implementation.
• Participate in readiness activities.
• Support change management initiatives.

6. Monthly Status Reporting

Provide:

• Detailed monthly activity reports.
• Readiness activity tracking.
• Progress updates.
• Documentation supporting invoiced hours.
• Monthly Summary Reports.

Required Skills

Key Skills

• Business Analysis
• Requirements Management
• Process Improvement
• Process Mapping
• Functional Specifications
• Data Analysis
• SQL Development
• Tableau Reporting
• Stakeholder Management
• Change Management
• Documentation and Reporting
• ERP / Financial Systems Implementation

Candidate Background Screening

Candidates are have to undergo

Level 2 screenings include Livescan fingerprinting of individuals and submission of the fingerprints through the Florida Department of Law Enforcement (FDLE) for a local, State, and National Crime Information Center (NCIC) check of law enforcement records through the Federal Bureau of Investigation (FBI).