Data Analyst

City of Cleveland; Cleveland (OH); On-site; USD 60,000 - 90,000; Full time

Job summary

City of Cleveland is seeking a Data Analyst in the Office of Urban Analytics & Innovation. You will enable reporting and dashboards for internal and external publication on the Open Data Portal, collaborating with City departments and technology teams to provide clear, data-driven insights to leaders.

The role emphasizes business intuition, use of analytical tools, and strong collaboration across City teams to inform decisions and drive improvements for urban projects.

Qualifications

• Bachelor's Degree in Computer Science, Business Administration, or closely related field from an accredited four-year college or university required.
• Two years of experience in Database Management Systems (DMS) required.
• Must be proficient in Windows and Microsoft Office Suite.

Responsibilities

• Leverage data from a variety of sources to analyze business performance and deliver actionable insights to City leaders.
• Partner with stakeholders to identify initiatives and coordinate with analytics teams to deliver sustainable solutions.
• Prepare items for the Open Data Portal with proper design, functionality, and metadata.
• Create performance dashboards for City departments to monitor KPIs and goals.
• Test data and applications to validate data accuracy and quality.

Skills

Data analysis

SQL

Dashboard development

Power BI/Tableau

Education

Bachelor's degree in Computer Science or related field

2 years experience in Database Management Systems

Tools

Windows

Microsoft Office Suite

Job description

Overview

The Data Analyst reports to the Manager, Open Data & Analytics in the Office of Urban Analytics & Innovation (Urban AI) at the City of Cleveland. The Data Analyst is responsible for enabling reporting and dashboards both in collaboration with and on behalf of City departments, for internal business use and for external publication to the Open Data Portal. The Data Analyst will partner with business and operations technology teams to provide easily understood insights and recommendations to City leaders, allowing for data-informed decision-making. This role requires business intuition, an ability to use analytical tools and methods to gain insights from data, organizational skills and the soft skills necessary to be a good partner to various teams across the City of Cleveland.

Description

Data Analyst

The Data Analyst reports to the Manager, Open Data & Analytics in the Office of Urban Analytics & Innovation (Urban AI) at the City of Cleveland. The Data Analyst is responsible for enabling reporting and dashboards both in collaboration with and on behalf of City departments, for internal business use and for external publication to the Open Data Portal. The Data Analyst will partner with business and operations technology teams to provide easily understood insights and recommendations to City leaders, allowing for data-informed decision-making. This role requires business intuition, an ability to use analytical tools and methods to gain insights from data, organizational skills and the soft skills necessary to be a good partner to various teams across the City of Cleveland.

Overview

The Data Analyst reports to the Manager, Open Data & Analytics in the Office of Urban Analytics & Innovation (Urban AI) at the City of Cleveland. The Data Analyst is responsible for enabling reporting and dashboards both in collaboration with and on behalf of City departments, for internal business use and for external publication to the Open Data Portal. The Data Analyst will partner with business and operations technology teams to provide easily understood insights and recommendations to City leaders, allowing for data-informed decision-making. This role requires business intuition, an ability to use analytical tools and methods to gain insights from data, organizational skills and the soft skills necessary to be a good partner to various teams across the City of Cleveland.

Examples of Duties

Typical Tasks: Develops file data specifications including standard names for data elements. Consults with and assists Project Leaders on procedures related to new or existing data file structures. Monitors and analyzes the performance of databases and prepares reports on findings to management including recommendations for improvement. Assists Project Leaders, Systems Analysts, and Programmers with implementation of data files to database. Develops and documents standards for use, control, updating, and maintenance of databases. Interfaces with tech support and computer operations in the reorganization of databases and recovery and backup procedures.

Minimum Qualifications

Bachelor's Degree in Computer Science, Business Administration, or closely related field from an accredited four-year college or university required. Two years of experience in Database Management Systems (DMS) required. (Substitution: Two years of any equivalent combination of education, training and experience may be substituted for each year of college education lacking.) Must be proficient in Windows and Microsoft Office Suite. Must be able to lift and carry a minimum of thirty (30) pounds. Valid State of Ohio Driver's License required.

Supplemental Information

Essential Duties & Job Functions

• Leverage data from a variety of sources to analyze business performance, identify areas of opportunity and deliver actionable insights to operations leaders and front-line personnel.
• Partner with business stakeholders to identify key initiatives and engage data analytics team members across the City of Cleveland to complete delivery of sustainable solutions to business problems, using data analysis, advanced analytics and data engineering standard methodologies.
• Assist other department analysts with preparing items for the Open Data Portal, including but not limited to ensuring that data items have adequate design, functionality, and metadata.
• Create performance management dashboards for City departments to monitor progress against KPIs and goals.
• Test data and/or applications to validate data accuracy/quality.
• Track small to medium-sized projects from conceptualization to completion, including helping to create project roadmaps, project plans and requirements documentation.
• Lead status meetings and manage frequent status communication to business stakeholders, IT teams and senior leadership as required.

Preferred Qualifications

• Bachelor's degree in quantitative field (mathematics, statistics, economics, business analytics, information systems, finance, or related degree).
• Demonstrated ability in analytical role (analysis, information science, data visualization or other relevant quantitative fields).
• Experience working with large datasets and reporting or visualization tools, ability to tell a story using data.
• Experience with analytics software (Power BI, Tableau, or similar) preferred .
• Ability to thrive in a project-based, team environment.

https://www.clevelandohio.gov/city-hall/departments/human-resources/total-rewards

The City's guiding principles are as follows: Placing Clevelanders at the Center, Empowering Employees to Do Purposeful Work, Defining Clear and Pragmatic Objectives, Leading with Trust and Transparency, Striving for Equity in All We Do, and Embracing Change. All City employees are responsible for embracing and carrying out these principles in all that they do.

The City of Cleveland makes available a variety of benefit options depending upon your employment status and any applicable union membership. In general, benefit options include comprehensive medical, dental, vision, prescription medical and life insurance. Specific information regarding benefit eligibility will be discussed and reviewed at the time of hire.