Data Analytics Specialist Senior chez Charlottenc

Date Opened: Wednesday, October 01, 2025 12:00 AM

Close Date: Thursday, October 16, 2025 12:00 AM

Department: Fire Department

Data Management & Analytics

Salary: $79,245.00 - $99,057.00 Commensurate with Experience

Welcome to the City of Charlotte

Charlotte is America’s Queen City, opening her arms to a diverse and inclusive community of residents, businesses and visitors alike. Here you will find a safe, family-oriented city where people work together to help everyone thrive. The mission of the City of Charlotte is to deliver quality public services and promote the safety, health, and quality of life for all residents.

Our guiding principles include:

• Attracting and retaining a skilled and diverse workforce

• Valuing teamwork, openness, accountability, productivity, and employee development

• Providing all customers with courteous, responsive, accessible, and seamless quality services

• Taking initiative to identify, analyze, and solve problems

• Collaborating with stakeholders to make informed decisions

SUMMARY

The Data Analytics Specialist Senior is housed in the Charlotte Fire Department’s Strategic Planning Division. This role designs and implements data, research, and analytics projects that improve the Charlotte Fire Department’s services using a broad range of methods, tools, and software. Researches, validates, and compiles data and information for key decisions related to the CFD’s service delivery, such as fire staff utilization and deployment, community risk reduction, and the prioritization of capital improvement projects. Develops and leads others in the development of resources to communicate about data, including SQL reports and dashboards as well as graphics and written reports. Cultivates and advances the use of data to support collaborative problem-solving across the organization. Implements business process improvement projects related to reporting, data analysis, and data sharing.

MAJOR DUTIES AND RESPONSIBILITIES

• Applies a broad range of analytic techniques and approaches to support collaborative problem-solving across CFD – e.g., data analysis, data visualization, dashboarding, GIS, SQL, statistical analysis, business process modelling, program evaluation, behavioral science.

• Provides analytical services for CFD’s research and analytics projects, including providing data that is accurate and reliable and integrating and preparing large, varied datasets from internal and external sources for analysis and visualization.

Analysis, Reporting, Data Visualization

• Performs predictive incident response modeling and analysis that helps CFD optimize performance of existing apparatus, predict impacts of future growth, identify optimal new station locations, and justify new station and apparatus requests; maintains, updates, and manages predictive incident modeling software to ensure modelling is as accurate to real-world as possible.

• Develops automated reports using SQL Server Reporting Services (SSRS); maintains and troubleshoots reports. Manages permissions for CFD reports

• Develops methodologies and processes for analyzing and reporting data more efficiently, accurately, and transparently.

• Performs ad-hoc data analysis and/or compiles data for analysis from stakeholders and, SMEs when information cannot be garnered from existing reports

• Provides data analysis and research, to support program evaluation and outcome measurement related to the performance and operation of the department, including:

  • Benchmark metrics;

  • Departmental program performance;

  • Service demand and performance, including forecasting; and/or

  • Cross-departmental problem-solving and policy analysis.

• Analyzes data and provides data and information for Accreditation and ISO; supports the development of continuous quality improvement processes.

• Automates tasks and improves processes using Python and SQL programming to minimize staff time on repetitive tasks

• Creates datasets that are supplemental to existing datasets and help improve the quality and functionality of reports and dashboards.

Research, reports (written), presentations

• Transforms data into actionable information and knowledge for CFD, its stakeholders, and city leadership. Prepares written reports, presentations, and summaries of data from complex records and multiple data sources including GIS data, for various audiences.

• Researches, analyzes, and evaluates proposals, projects, and departmental activities, processes, and programs in terms of staffing requirements, needs, priorities, costs, and funding sources; reviews external consultant reports to ensure they’re logically and factually sound and are appropriately informed by industry standards and fire service knowledge.

• Designs and executes special projects that combine data and processes into insights that improve decision-making ability; generates new data from special projects, to help CFD fill gaps in information and improve quality of analyses

Quality Management

• Ensures appropriate and meaningful data collection, analysis, and reporting.

  • Develops processes, SQL queries, reports, and departmental policies for the QA/QI/QC of CFD data, especially emergency response data

  • Collaborates with IT divisions and software vendors and makes recommendations for software and application changes to improve the quality of data collected by the department

  • Performs end-of-year QA/QI work to identify and exclude CFD responses that do not meet response time reporting criteria, document correct coordinates for incidents missing point data, etc.

• Advances the use of data internally and externally by identifying and pursuing improvements to communicate data for impact and help CFD tell its story; identifies effective strategies for communicating with internal and external audiences; implements effective, appropriate, and unique methods for visualizing and communicating about data

Collaboration; Data Sharing; Open Data; Partnerships

• Supports the efforts of other Strategic Planning team members by providing data for special projects, validating and/or writing SQL queries, and identifying opportunities to improve analyses and processes

• Works with City Planning and similar departments to understand and estimate the impact of future development on the Fire Department

• Participates in innovation and analytics projects; partners with other city departments and public safety agencies in research and planning activities; and represents the Fire Department in cross-department and community efforts related to data analysis, process facilitation, and problem solving.

• Promotes CFD’s use of shared data and works with partners to strengthen the internal data community and promote the use of CFD data with community and external stakeholders.

KNOWLEDGE, SKILLS, AND ABILITIES

Knowledge of:

• English grammar, spelling, and punctuation

• Modern office procedures, methods and computer equipment

• Software/technology that aid in data collection, analysis, and presentation (e.g., ArcGIS, Excel, Power BI, Tableau, SPSS/SAS/R, etc)

• Statistics

• Programming languages (SQL, XML, Python)

• Quantitative and Qualitative research design and intermediate statistical methods and analyses

• Network analysis and other forms of spatial analysis and spatial statistics

• Various source systems and data retrieval processes

• Business process documentation

• Municipal operations, departmental business needs and programs, and city strategy/community goals 

Skill in:

• Interpersonal skills necessary to develop and maintain effective and appropriate working relationships at all levels of the organization.

• Excellent written and verbal communication skills

• Demonstrated initiative and good professional judgment.

• Balancing a variety of duties, often changing from one task to another of a different nature.

• Performing basic mathematical functions such as addition, subtraction, multiplication, division, percentages, and ratios.

• Excellent time management to effectively meet deadlines and adjust when needed for competing priorities

Ability to:

• Ability to work independently and collaboratively with all levels of the organization, especially senior leadership.

• Understand and carry out oral and written directions.

• Systematically organize, document, and maintain paper documents and electronic files.

• Communicate effectively, both orally and in writing

• Interpret user groups’ needs and see path from idea to identifying project outcomes

• Develop and implement tutorials and how-to documentation

ADA and Other Requirements:

Positions in this class typically require grasping, talking, hearing, seeing, and repetitive motions.

Physical Requirements:

• Essential and marginal functions may require maintaining physical conditions necessary for sitting, standing, climbing, or walking for extended periods of time.

• Light to moderate lifting and carrying; some crouching, stooping, squatting, crawling, reaching, pushing, and pulling when performing tasks.

• Adequate vision, hearing, and speech required.

Sensory Requirements:

Concentrated and attentive use of one or more senses (visual, audio, and other sensory modalities) for proofreading, data entry, and tabulating data.

• Ability to operate in an environment with frequent interruptions from people and/or noises, which in return could result in some level of stress, fatigue, or strain.

• Comprehensive written information in work-related documents.

• Ability to hear, understand, and distinguish speech.

Working Conditions:

Work is performed in an indoor and outdoor environment with moderate exposure to atmospheric conditions; moderate exposure to environmental conditions and frequent exposure to computer screens, files, and phone.

PREFERRED QUALIFICATIONS

• At least four years of relevant college-level course work or Bachelor’s degree from an accredited college or university in Information Technology, Computer Science, Geography, or a related field 

• One (1) to three (3) years of experience in data warehousing, report and dashboard development, with business analysis and process improvement   

• At least three years of experience with fire service data

• Any equivalent combination of training, education, and experience that provides the required skills, knowledge and abilities 

MINIMUM QUALIFICATIONS

High School Graduate or Equivalent and five years related work experience

OR

Associate's Degree and three years related work experience

OR

Bachelor's Degree and one year related work experience

CONDITIONS OF EMPLOYMENT

The City’s Background Check Policy requires background checks to be conducted on final internal or external candidate(s) applying for any position with the City of Charlotte. The type of information that will be collected as part of a background check includes, but is not limited to: reference checks, social security verification, education verification, criminal conviction record check, and, if applicable, a credit history check, sex offender registry and motor vehicle records check.

Background checks must be in compliance with all federal and state statutes, such as the Fair Credit Reporting Act (FCRA). The checks must be consistent with the guidelines set forth by these laws requiring organizations to obtain a candidate’s written authorization before obtaining a criminal background report, motor vehicle records check or credit report; and to properly store and dispose of information derived from such reports.

Final candidates must pass a pre-employment drug-screening test and physical examination. During the selection process, candidates may be asked to take a skills test, and/or participate in other assessments.

The City of Charlotte is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race, religion, color, sex, national origin, marital status, age, disability, sexual orientation, political affiliation or on the basis of actual or perceived gender as expressed through dress, appearance, or behavior.

Our culture is to serve the community honorably.

HOW TO APPLY

Apply online.

Federal law requires employers to provide reasonable accommodations to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job.

You are welcome to visit the City of Charlotte Human Resources Department lobby, where self-service application kiosks are available. They are located in our office at 700 East 4th Street, Suite 200, Charlotte, NC 28202. We are open Monday through Friday, from 9:30 a.m. to 3:30 p.m. (EST), excluding official City holidays.

For questions about your application or the hiring process, please email [email protected].

The City of Charlotte is committed to making our services and programs accessible to all. Upon request, auxiliary aids, written materials in alternate formats, language access, and other reasonable accommodations or modifications will be provided. To make a request, please fill out the Innovation & Technology ADA request form or call 704.336.4120.

BENEFITS

The City of Charlotte provides a comprehensive benefits package to eligible employees.

Click here to learn more about the City of Charlotte’s benefits.

The City of Charlotte is a drug and alcohol-free workplace.

Postuler maintenant