OPS Data Analyst: Forecasting & Data Automation

My Florida CFO; Tallahassee (FL); Hybrid; USD 70,000 - 100,000; Full time

Job summary

The Florida Division of Emergency Management in Tallahassee is seeking an OPS Data Analyst to oversee, plan, develop, engineer, and coordinate all Bureau of Mitigation systems. The role emphasizes automating data pipelines, dashboards, and cost trackers to support multi-year budgets and disaster responses.

Within a fast-paced environment, you will collaborate with finance, IT, audit, and program teams, provide system training, and assist during SEOC activations, including extended hours when

Qualifications

• Proficiency in Python, SQL, Power Automate, Excel VBA, and Power BI.
• Knowledge of financial reporting, forecasting, and data governance practices.
• Ability to build and maintain automated data pipelines and dashboards.

Responsibilities

• Automate data pipelines using Python, SQL, and Power Automate, integrating FLAIR, FOCUS, and other systems into SharePoint/OneDrive.
• Build and maintain secure databases, store scraped and ingested financial data, enabling automated payment tracking and reducing risk of late fees.
• Design, develop, and manage Power BI dashboards and Excel VBA tools for accurate forecasting of billion-dollar budgets.
• Create and maintain State Management Cost trackers with burn rates, churn analysis, and multi-year budget projections.
• Standardize and clean large datasets using custom Python scripts to ensure accuracy and real-time synchronization.
• Generate automated financial reports and ad hoc queries, reducing manual workload and enhancing financial visibility.
• Develop and manage a Contract Routing Tracker to identify bottlenecks and improve compliance.
• Implement automated alerts and dashboard systems to flag delays in routing.
• Collaborate with finance, IT, audit, and program teams to align systems, resolve issues, and strengthen data governance.
• Provide technical assistance, system training, and reporting support to internal and external stakeholders.
• Perform duties in support of the SEOC during activations, including extended hours and weekends.

Skills

Python

SQL

Power Automate

Excel VBA

Power BI

Data governance

Education

Bachelor's degree or higher in Data Science/IS/Public Administration/Finance

Tools

FLAIR

SharePoint/OneDrive

Job description

The Florida Division of Emergency Management in Tallahassee is seeking an OPS Data Analyst to oversee, plan, develop, engineer, and coordinate all Bureau of Mitigation systems. The role emphasizes automating data pipelines, dashboards, and cost trackers to support multi-year budgets and disaster responses.

Within a fast-paced environment, you will collaborate with finance, IT, audit, and program teams, provide system training, and assist during SEOC activations, including extended hours when