OPS Data Analyst - 31902352

State of Florida

2d•$32•Onsite

About The Position

The Florida Division of Emergency Management (FDEM) plans for and responds to both natural and man-made disasters. These range from floods and hurricanes to incidents involving hazardous materials or nuclear power. FDEM is the liaison between federal, state, and local agencies. FDEM prepares and implements a statewide Comprehensive Emergency Management Plan, routinely conducts extensive exercises to test state and county emergency response capabilities, provides technical assistance to local governments as they prepare emergency plans and procedures, as well as conducts emergency operations trainings for state and local government agencies. FDEM serves as the lead agency for the State Emergency Response Team (SERT), whose primary goal is the coordination of the state’s efforts during disaster response and recovery. This coordination is conducted within the State Emergency Operations Center (SEOC) in Tallahassee. Additionally, FDEM manages the State Watch Office; the 24-hour a day operation tasked with providing situational awareness to stakeholders statewide. After a disaster, FDEM conducts damage assessment surveys and advises the Governor of the State of Florida on whether to declare an emergency and seek federal relief funds. It is against this backdrop that FDEM strives to demonstrate its mission of, “Coordinate, collaborate, and communicate with our community stakeholders for a resilient Florida”, along with our vision of “Leading the Profession in building prepared and resilient communities”. Position Overview and Responsibilities: This position serves as an OPS Data Analyst in the Fiscal Operations Unit, and will oversee, plan, develop, engineer, and coordinate all Bureau of Mitigation systems. In response to emergency events, FDEM employees may be required to work irregular hours, to work more than 8 hours per day, to work extended periods (including weekends and holidays), to work at locations other than their official headquarters, and to perform duties in addition to those outlined in the employee’s position description. Employees must be able to deploy to emergency sites with limited advance notice.

Requirements

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.
Strong background in statistical modeling, forecasting, and trend analysis.
Experience with Florida Accounting Information Resource (FLAIR) or other financial accounting systems.
Strong problem-solving skills with ability to identify and resolve data integrity issues.
Ability to communicate complex technical concepts to non-technical audiences.
Strong written and verbal communication skills.
Ability to learn new systems and tools.
Ability to document processes and complete process maps.
Ability to work independently and collaboratively in a fast-paced environment.
Ability to support emergency operations, including occasional travel and extended work hours during activations.
A minimum of four years’ professional experience in data analysis, financial reporting, or a related field. A post-secondary degree from an accredited institution in Data Science, Information Systems, Business Administration, Public Administration, Finance, or a related field may substitute for the required experience on a year-for-year basis, up to two years.
Experience with Florida Accounting Information Resource (FLAIR) or other financial accounting systems.
Experience with federal grant reporting or data submissions to a federal agency, such as FEMA.
Experience using Microsoft Office Suite (Excel, Word, Outlook), Python, SQL, Power Automate, Excel VBA, and Power BI with the ability to learn and navigate FDEM enterprise business systems.

Responsibilities

Automate data pipelines using Python, SQL, and Power Automate, integrating FLAIR, FOCUS, and other systems into SharePoint/OneDrive. Evaluate and process system access requests.
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, real-time synchronization, and elimination of redundancy.
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, cutting approval delays by 30% and improving compliance.
Implement automated alerts and dashboard systems to flag delays in routing, improving accountability and workflow oversight.
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 State Emergency Operations Center (SEOC) during activations, which may include extended hours and weekends.
Perform other duties as assigned.