Data Analytics Specialist Senior

Welcome to the City of Charlotte

Charlotte is Americas 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

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 CFDs 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 theyre 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 CFDs 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 Bachelors degree from an accredited college or university in Information Technology Computer Science Geography or a related field

• One (1) to three (3) years of experiencein 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 educationand experiencethatprovides the required skills knowledge and abilities

MINIMUM QUALIFICATIONS

High School Graduate or Equivalent and five years related work experience

OR

Associates Degree and three years related work experience

OR

Bachelors Degree and one year related work experience

CONDITIONS OF EMPLOYMENT

The Citys 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 candidates 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 .

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.

Clickhereto learn more about the City of Charlottes benefits.

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