Data Analytics Specialist Senior

City of Charlotte

1d • $79,245 - $99,057

About The Position

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.

Requirements

• 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).
• Programming languages (SQL, XML, Python).
• Various source systems and data retrieval processes.
• Research design and statistical methods and analyses.
• 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.
• 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: 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
• 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

Nice To Haves

• Bachelor’s degree from an accredited college or university in Information Technology, Computer Science, Geography, or a related field.
• Three (3) years of experience in data warehousing, report and dashboard development, with business analysis and process improvement.
• Any equivalent combination of training, education, and experience that provides the required skills, knowledge and abilities.

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.
• Designs, builds, and maintains enterprise-level data and analytics systems, including SQL-based data pipelines, data warehouses, dashboards, geospatial and situational awareness tools, and automated reporting workflows, while providing technical leadership and strategic guidance to support operations, accreditation/ISO requirements, EMS workload modeling, and long-term enterprise analytics and systems modernization.
• Contributes to the team with a proven ability to develop secure, cloud-enabled analytics and geospatial solutions; automate reporting and accreditation workflows; implement data governance and compliance practices; and provide cross-department leadership while contributing to long-term strategy for RMS modernization, enterprise reporting, and analytics ecosystems.
• 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 a high volume of internal reports that support every division of the department; manages permission for these reports.
• Develops new methodologies for analyzing and displaying data, to better leverage existing data.
• Performs ad-hoc data analysis and/or compiles data for analysis by 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 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.
• 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
• 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.
• 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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level