Business Analyst/Programmer

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: