OPS Data Analyst - 31902352

State of Florida; Tallahassee (FL); On-site; USD 70,000 - 95,000; Full time

Job summary

The Florida Division of Emergency Management seeks an OPS Data Analyst in the Fiscal Operations Unit to design, engineer, and coordinate data systems supporting multi-year budgets and billion-dollar forecasts.

You will automate data pipelines with Python, SQL, and Power Automate, build secure databases, and develop Power BI dashboards and Excel VBA tools to improve financial visibility and compliance during emergency operations.

Qualifications

• Minimum four years of professional data analysis, financial reporting or related experience.
• Experience with Florida Accounting Information Resource (FLAIR) or similar systems.
• Experience with federal grant reporting or data submissions to a federal agency such as FEMA.
• Proficiency in Python, SQL, Power Automate, Excel VBA, and Power BI; ability to learn FDEM enterprise systems.

Responsibilities

• Automate data pipelines using Python, SQL, and Power Automate; integrate systems and manage access requests.
• Build and maintain secure databases; store financial data and enable automated payment tracking.
• Design, develop, and manage Power BI dashboards and Excel VBA tools for forecasting budgets.
• Create and maintain state management cost trackers with burn rates and multi-year projections.
• Standardize and clean large datasets; ensure real-time synchronization and data integrity.
• Generate automated financial reports and ad hoc queries; reduce manual workload.
• Develop and manage a Contract Routing Tracker to improve efficiency and compliance.
• Implement automated alerts and dashboards to flag delays and improve accountability.
• Collaborate with finance, IT, audit, and program teams; provide training and reporting support.
• Support the State Emergency Operations Center during activations; may require extended hours.

Skills

Python

SQL

Power Automate

Excel VBA

Power BI

Education

Bachelor's degree in Data Science, Information Systems, Business Administration, Public Administration, Finance, or related field

Tools

FLAIR

Job description

Select how often (in days) to receive an alert:

Select how often (in days) to receive an alert:

The State Personnel System is an E-Verify employer. For more information click on ourE-Verify Website .

Requisition No:874109

Agency: Division of Emergency Management

Working Title: OPS Data Analyst - 31902352

Florida Division of Emergency Management

This position is located in Tallahassee, FL

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. Duties include, but are not limited to:

• 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.

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.

Knowledge, Skills, and Abilities:

• 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.

Minimum Qualifications:

• 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.

Special Notes:

Equal Opportunity Statement: The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer and does not tolerate discrimination or violence in the workplace.

FDEM is committed to successfully recruiting and onboarding talented and skilled individuals into its workforce. FDEM appreciates the service and sacrifices made by veterans and their family members and recognizes the immeasurable value veterans bring to the workplace and is committed to increasing the number of veterans that serve in its workforce.

FDEM is committed to increasing recruitment and hiring of individuals with disabilities and improving employment outcomes. An individual with a disability is qualified if he or she satisfies the skills, experience, and other job-related requirements for a position and can perform the essential functions of the position with or without reasonable accommodation. Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must contact the FDEM Human Resources Office at [phone]. FDEM requests applicants notify the Human Resources Office in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with section 112.0455, F.S., Drug-Free Workplace Act.

Successful completion of background screening will be required for this position.

The State of Florida and FDEM participate in E-Verify. This federal law requires all employers to verify the identity and employment eligibility of all persons hired to work in the United States.

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 nights, 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.

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act.

For assistance, call the People First Service Center at [phone] Monday - Friday, 8:00 a.m. to 6:00 p.m., Eastern time. Pursuant to Florida Law, 110.211 F. S., the State of Florida is an EEO employer.