Fire Department Data Analyst

Data Analyst – FireIt is an exciting time to work for the City of Aurora, we're growing and looking for dedicated and collaborative individuals to join our team of talented and valued employees. Excellent organizations have a set of principles, or core values, that are used to implement their mission and vision. Those values represent the touchstone for the organization, guiding the decisions of the individuals and the organization. At the City of Aurora, we demonstrate our excellence by modeling the CORE 4 Values of: Integrity, Respect, Professionalism, and Customer Service, and we welcome all who share these values to apply.Why Work for Aurora?Make a difference in the lives of real people every dayDiverse communityCompetitive total compensation packageWell-Funded General Employees Retirement PlanLight rail station minutes awayOn-site fitness center and overall employee well-being programs Internal educational programs to assist with career advancementAccess to innovation workspacesOverview of RoleThe Data Analyst – Fire acquires, manages, integrates, analyzes, and reports Aurora Fire Rescue (AFR) operational data to support department operations, performance measurement, regulatory reporting, and informed decision-making. The position performs data ingestion, validation, quality assurance, transformation, and integration across multiple public safety systems; develops recurring and ad hoc reports, dashboards, and analyses; and supports statistical, geospatial, and predictive analytics initiatives.Primary Duties & ResponsibilitiesData Systems Management & Quality Assurance:Maintain and support AFR data and reporting functions within public safety information systems, including CAD, RMS, NERIS, and related databasesTroubleshoot and resolve data issues (e.g., missing or incomplete reports) by applying data validation rules or adjusting system configurations to maintain data integrity and meet required standardsEnsure data accuracy and reliability for leadership decisions and regulatory compliance (e.g., NERIS incident reporting)Data Integration & Compliance Reporting:Develop and maintain data integrations between systems (CAD, RMS, NERIS) to ensure consistent, high-quality data across all sourcesCompile, validate, and submit incident data reports to meet local, state, and federal requirements (including timely NERIS reporting)Collaborate with operational personnel and subject-matter experts to define data requirements, validate analytical assumptions, and ensure reports and analyses accurately reflect AFR operationsData Analysis & Reporting:Generate regular and ad-hoc reports and dashboards to meet identified operational needsUse SQL and business intelligence tools to extract, combine, and analyze data from multiple sources, identifying trends and patternsPresent clear findings and visualizations that provide stakeholders with timely, accurate information for decision-making, performance monitoring, and service improvementsDevelop and maintain documentation for data definitions, queries, validation rules, reporting methodologies, integrations, and recurring analytical processesOperational Analytics Support:Perform statistical and trend analyses on data to identify operational patterns, risks, and areas for improvementSummarize data insights and assist the Data Analytics Supervisor in developing data-driven recommendations for crews, command staff, and executive leadershipSupport the development, testing, validation, and application of predictive and forecasting tools used to evaluate incident demand and operational trendsGIS and Special Projects:Provide updates and analysis of AFR GIS dataAssist in evaluating and implementing new data-related technologies and toolsOther Duties:Perform other job-related duties as assignedThis job description is not intended to cover or contain a comprehensive listing of all activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new additions may be assigned at any time with or without notice.Minimum Qualifications & Working ConditionsAn equivalent combination of education, training, and experience that demonstrates required knowledge, skills, and abilities may be considered.Education:Bachelor's degree in Data Science, Statistics, Computer Science, Information Systems, Business Analytics, Public Administration with an emphasis in quantitative analysis, or a closely related fieldExperience:Three (3) years of progressively responsible experience in data analysis, data management, business intelligence, or a closely related field, including experience working with large datasets and integrating or analyzing data from multiple sourcesPreferred Qualifications:Experience with data analysis in public safety, fire service, or emergency managementFamiliarity with public safety data systems (e.g., CAD, RMS) and geographic information systems (GIS) is highly desirableKnowledge of:Principles, best practices, and statistical methods used in data analysis and performance measurementData quality assurance, validation, governance, and integrity practicesRelational database concepts, data structures, and SQLPrinciples and methods of data visualization and dashboard developmentData integration concepts and methods for combining information from multiple systemsApplicable fire and emergency response data standards and reporting requirements, including NERISPrinciples and practices of geospatial analysis and GISData privacy, confidentiality, and appropriate handling of sensitive or restricted informationSkills in:Querying, extracting, transforming, validating, and analyzing data using SQL and related analytical toolsIdentifying and resolving data quality issuesDeveloping and maintaining reports, dashboards, visualizations, and other analytical productsAnalyzing large and complex datasets from multiple sourcesApplying statistical and trend-analysis techniques to operational dataUsing spreadsheet and business intelligence tools to organize, analyze, validate, and present informationTranslating complex data into clear, accessible visualizations and narratives for technical and nontechnical audiencesPreparing and delivering clear written and oral presentations of analytical findingsTroubleshooting data, reporting, and integration issuesAbility to:Establish and maintain effective working relationships with department personnel, City staff, other governmental agencies, vendors, and other stakeholdersInterpret operational needs and translate business questions into appropriate data and analytical approachesManage multiple assignments, priorities, and deadlines with appropriate attention to accuracy and detailExercise sound judgment when working with sensitive, confidential, or restricted informationCommunicate technical concepts and analytical findings clearly to technical and nontechnical audiencesWork independently while collaborating effectively with operational and technical subject-matter expertsLearn and apply emerging analytical technologies, tools, and methodologiesLicenses and Certifications Required:Valid Colorado driver's license and ability to operate a city vehicle, or otherwise demonstrate ability to meet the transportation requirements of the positionEssential Personnel:When a local announcement of emergency or disaster is declared by the city, all City of Aurora employees may be required to work as essential personnel.Physical Demands:Light physical work requiring the ability to lift 20 pounds with or without assistanceOccasional walking, standing, lifting, and carryingAbility to review and interpret reports and other written documents with or without reasonable accommodationAbility to communicate with employees, opposing council, and other stakeholders with or without reasonable accommodationWork Environment:Works primarily in an indoor office setting with regular computer and phone useOccasionally off-site or outdoor work (e.g., at emergency scenes or training events) with potential exposure to noise, weather, smoke, dust, or odorsEquipment Used:Uses