Data Analyst - G126 - Fire/EMS

Columbus Consolidated Government•Usa, GA

1d•Onsite

About The Position

The Data Analyst works under the general direction of the Business Analyst but resides within the EMS Division. This is a civilian (non-sworn) position within the Fire-EMS Department. The Data Analyst is responsible for using information systems and data analysis methods and techniques to query, analyze, and present data to assist the Fire-EMS Department in reporting and developing periodic reports, strategic plans, and standards of cover documents. The Data Analyst will have broad visibility in all areas of department operations with the goal to provide data analysis and interpretation to enhance organizational operations. General responsibilities include the development, implementation and management of programs and systems that support high performance strategies to meet the organizational needs, promote organizational mission, vision and values throughout the department, and facilitate the execution of the vision and direction of the Fire Chief and the best interests of the Fire-EMS Department and the Columbus Consolidated Government (CCG). The Data Analyst will work closely across divisions to transform raw information into actionable intelligence that improves operational efficiency, strategic planning, and community outcomes. This position directly supports leadership decision-making and enhances service delivery through evidence-based practices.

Requirements

Two to four years of professional experience in data analysis, business intelligence, or performance analytics, preferably in a public safety, healthcare, or government environment.
Demonstrated experience working with large datasets and/or real-time data including CAD (Computer-Aided Dispatch), RMS (Records Management Systems), EMS/transport data, or similar operational data sources.
Proficiency in data analysis and business intelligence tools such as Power BI and SQL; ability to build, maintain, and interpret dashboards, reports, and data visualizations for both technical and non-technical audiences.
Demonstrated experience managing and executing complex planning, research, and analytical projects from inception through delivery, with minimal supervision.
Excellent verbal and written communication skills, including the ability to present data-driven findings clearly to department leadership, elected officials, and the public.
Strong attention to detail with a commitment to data accuracy, integrity, and consistency.
Proficiency in Microsoft Office Suite, including advanced Excel skills, Word, PowerPoint, and Outlook.
Bachelor’s degree from an accredited college or university with major coursework in computer science, information systems, statistics, data science, or a closely related field.
Applicant must be either a U.S. citizen or resident alien eligible to work in the United States.
Must successfully pass a drug screening and extensive background check.
Proficient in the use of information systems and data analysis methods and techniques to query, analyze, and present data to assist the fire and emergency services organization in reporting and developing periodic reports, strategic plans, and standards of cover documents.
Familiarity with analyzing information; specifically identifying, processing, querying, and visualizing data to assist the fire and emergency services organization in providing information required by external and internal agencies and for analytical and decision-making purposes; a pursuit of data integrity and sustainable data management for reliable, efficient, and long-term use.
The ability to demonstrate formal training or workplace experience using datasets and data sources, as well as understanding their respective properties; investigate, organize, and present data as a comprehensible analysis; and produce documentation regarding data considerations and analytical processes.
Verify data needs, parameters, and analytical limitations, given a request for information, so that the scope, data requirements, and estimated level of effort required to perform the analysis are defined.
Access one or more data sources, given a set of data parameters and appropriate access to data, so that the information is able to be assessed.
Extract data, given an established connection to data sources, so that a dataset is available for use independent of the system of origin.
Inspect the output dataset, given a dataset and data systems, so that potential issues are identified and documented.
Evaluate data quality issues, given appropriate data review tools and a dataset with known issues, so that scope of the issues is determined and corrective actions are documented.
Perform data wrangling, given a need to resolve anomalous and erroneous data, so that data analysis is valid and reliable.
Communicate any limitations in the dataset, given anomalous and erroneous data, so that the causes and remedies are annotated and can be addressed by the owners of the data.
Verify repairs to a dataset were successful, given a repaired database, so that inconsistencies in the data are addressed.
Standardize data type and format, given a dataset and agency data conventions, so that data are put into a compliant type and format per agency requirements.
Structure data for analysis, given data from one or more sources, so that data from multiple sources can be used within the available analysis program.
Determine the analysis methods and techniques, given the available data and type of request, so that a systematic and objective approach is used and supports the project goals.
Perform data analysis, given a request, access to applicable datasets, and analysis tools, so that the result(s) and process(es) satisfy the request.
Perform quality assurance (QA), given data analysis results, so that the results meet the objectives of the original request.
Design a method to communicate information, given presentation requirements and data artifacts from an analysis, so that the information is accessible and specific to the targeted audience.
Communicate the results, given the results of an analysis, presentation tools, and an audience, so that the original request is addressed, any additional relevant information is outlined, and questions are addressed.
Produce technical notes, given details about data access, repairs, and data reliability, so that data considerations are documented for future reference, repeatability, and continued analysis.
Compile analysis instructions, given the original request and technical notes, so that the organization has access to a transparent and reproducible record of the entire analysis process.

Nice To Haves

Prior experience working in a Fire Service, EMS, or public safety environment.
Experience supporting or preparing documentation related to Fire Service accreditation processes, such as CPSE/Commission on Fire Accreditation International (CFAI) standards.
Experience with ArcGIS (ESRI) or other GIS platforms, including spatial data analysis, mapping, and geographical incident reporting.

Responsibilities

Analyze response times, turnout times, incident types, and unit availability to identify inefficiencies and recommend deployment adjustments.
Forecast call volume trends to support demand-based station siting, peak staffing needs, and fleet management.
Use spatial and historical data to identify high-risk populations, properties, and areas.
Evaluate the impact of CRR initiatives (i.e., Mobile Integrated Healthcare (MIH) programs).
Develop dashboards and heat maps for targeted prevention strategies.
Monitor patient care trends, high utilizers, transport times, and clinical metrics to support EMS QA/QI.
Analyze MIH program data to demonstrate ROI and impact on system load.
Build and maintain interactive dashboards, scorecards, and automated reports using tools like Power BI and ArcGIS.
Integrate data from CAD, NERIS, RMS, EPCR, GIS, and HR systems for a comprehensive performance view.
Enhance situational awareness during large-scale events or special operations through real-time data feeds.
Justify funding requests with data-backed performance metrics and outcome projections.
Track and report on grant-funded initiatives, ensuring compliance and demonstrating success.
Support partnerships with partner agencies by sharing interoperable data.
Contribute to public transparency by providing clear, digestible visuals of department performance.
Attend and participate in a variety of meetings (staff meetings, accreditation consortium meetings, CCG meetings, stakeholder meetings) representing the interests of the Fire Department.
Interact and work collaboratively with internal/external stakeholders to further the mission, vision, values and initiatives of the department on a regular basis.
Consistently engage in proactive efforts to identify innovative and progressive ways to engage organizational challenges and opportunities.
Craft and deliver letters, memos, reports, and other correspondence to members of the department’s executive team, the CCG, or the public.
Review and evaluate reports for accuracy and completeness.
Provide regular and consistent information to internal/external stakeholders pertaining to organizational initiatives.
Identify, visualize and monitor performance metrics for the different divisions of the Fire Department.
Work closely with the organization’s accrediting entities and managers ensuring compliance with annual reporting requirements as well as re-accreditation efforts.
Utilizes available technology to develop & maintain organizational dashboards to support program management, review and modification.
Ensures developed tools support executive staff efforts to maintain situational awareness of operational and organizational efforts in real-time.
Perform other related duties as assigned.