Data Analyst- Public Service
Role summary
The City of Charleston's Environmental Services Department is seeking a Data Analyst to collect, analyze, and disseminate data to identify trends and changes affecting service issues. This role is crucial for enhancing the department's efficiency and effectiveness. Responsibilities include acquiring, filtering, and cleaning data, troubleshooting queries, resolving data integrity issues, preparing reports and charts, performing complex analyses including geographical mapping, and coordinating with other departments. A Bachelor's degree in a related field with strong statistical coursework, a driver's license, and extensive knowledge of Microsoft Office Suite, SQL, and GIS software are required. Experience managing large datasets and performing statistical analyses is preferred.
This job will be accepting job applications until the position is filled.
Annual Salary:
$61,152.00 - $64,837.50
Hourly:
$31.36 - $33.25
Department:
Environmental Services, Public Service
Division:
Environmental Services Administration
FLSA:
Non-Exempt
Job Description:
This role will collect, analyze, prepare, and disseminate a variety of data and identify the patterns, trends, and changes affecting service issues. The Data Analyst will be providing critical support in increasing the department’s efficiency and effectiveness.
Examples of Duties:
- Acquires, filters and cleans data for reporting and analysis through database design and query building.
- Troubleshoots query issues and recommends changes in data gathering.
- Identifies data integrity issues and provides solutions to resolve them.
- Prepares and distributes reports, charts, publications and related material to track, display and explain findings and report Public works issues
- Performs a variety of complex professional analyses, including geographical mapping analyses, of relative route information
- Collects, analyzes, prepares and disseminates information relative to route and repair patterns to assist operational personnel in the City of Charleston’s Public Works Department.
- Coordinates analysis activities with other City departments and outside agencies.
- Responds to requests regarding for analysis information relating to specific information
- Performs other duties as assigned.
Basic Qualifications:
- Bachelor’s degree (BA/BS) or equivalent in computer science, mathematics, statistics or related field with strong statistical coursework.
- Valid state issued driver’s license.
- Extensive knowledge of Microsoft Office Suite including Access, SQL, and ArcMap or similar GIS software.
Preferred Qualifications:
- Practical experience or training managing large data sets, generating queries, and performing statistical analyses
The City of Charleston is firmly committed to Equal Employment Opportunity ( EEOC) as a fundamental policy to be implemented and observed in our daily operation. Our full EEOC statement can be found on our website:
www.charleston-sc.gov [charleston-sc.gov]