Data Analyst at City of Charleston

Cleveland, Ohio, United States -

Full Time

Start Date

Immediate

Expiry Date

06 Jun, 26

Salary

64252.5

Posted On

08 Mar, 26

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Collection, Data Analysis, Database Design, Query Building, Data Integrity, Reporting, Geographical Mapping, Crime Analysis, Statistical Analysis, Microsoft Office Suite, Access, SQL, ArcMap, GIS Software

Industry

Government Administration

Description

This job will be accepting job applications until the position is filled. Annual Salary: $61,152.00 - $64,252.50 Hourly: $31.36 - $32.95 Department: Police, Public Safety Division: Police Technology & Data Management FLSA: Non-Exempt Job Description: In this role, you will collect, analyze, prepare, and disseminate a variety of police data and crime information to identify the patterns, trends, and changes affecting policing in the City of Charleston, 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 on crime analysis activities. Performs a variety of complex professional analyses, including geographical mapping analyses, of relative crime information. Collects, analyzes, prepares and disseminates information relative to crime patterns to assist operational personnel in the police department. Coordinates analysis activities with other City departments and outside agencies. Responds to requests regarding crime analysis information relating to specific investigations. 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. No professional experience is required, however practical experience or training managing large data sets, generating queries, and performing statistical analyses is strongly preferred. Valid state issued driver’s license. Extensive knowledge of Microsoft Office Suite including Access, SQL, and ArcMap or similar GIS software. Other Necessary Requirements: May require evenings, weekends, and holidays as scheduled. In the event of major storms or other emergency situations, this position may be subject to 24-hour shifts or any other emergency schedule that is necessary to meet the City’s needs. 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] The City of Charleston is a progressive and energetic city and our goal is to grant our residents with the best service a city can provide and our visitors with the best vacation or business trip that a city can provide. Charleston is a special and unique city. The combination of our unequaled beauty, warm hospitality, and exceptional public spaces provide a wonderful backdrop for residents and visitors. Through careful conservation, creative and innovative financing, and meticulous planning, Charleston is a city that celebrates a rich history. Charleston was the first city in the country to enact a preservation ordinance. We have an active and ongoing interest in the protection and restoration of our buildings, which tell the story of our past. Keeping an eye to the future, we have set goals that make the livability and quality of life in Charleston the best in the nation. We work diligently to keep our city the best place in the country to work, to live and to play.

Responsibilities

The role involves collecting, analyzing, preparing, and disseminating police data and crime information to identify patterns and trends, providing support to increase departmental efficiency. Duties include acquiring, filtering, and cleaning data, troubleshooting queries, preparing reports, and performing complex analyses like geographical mapping.