MANAGEMENT ANALYST - DATA SOLUTIONS (UNCLASSIFIED)

This employee performs professional level work which involves a high degree of independent judgment and responsibility in the administration of the City.  Responsibilities include maintaining liaison with various City departments and performing staff work which may involve administrative and operational analysis, budget preparation and administration, management or organizational studies, and other related administrative duties. Performs related duties as assigned.

The Department
 The Office of Performance and Data Analytics is a small, fast-paced team charged with creating data solutions, process design & improvement, and performance management across all City departments. The office focuses on the following key initiatives:
 
Data Solutions – use data processing, data transformation and dashboard/report building to support data driven decisions across City departments and support effective performance management.
 
CincyInsights - an interactive open data dashboard portal, designed to make open data more user friendly and interactive for all users.
 
Open Data Portal - the City's web portal to which datasets are published daily (or more often, for some datasets).
 
Innovation Lab - designed to gather front-line personnel to address some of the City's most challenging operational and customer service issues.
 
Performance Management Agreements - annual agreements between the City Manager and Departments establishing objectives and measures to evaluate performance.
 
Your Role
 This position will be part of our Data Solutions team. The role will provide the technical expertise needed to support data driven operations, improve our public facing dashboards and datasets, support innovation projects and performance management through the development of integrated internal dashboards, and partner with departments to identify opportunities to improve service delivery through data solutions. Successful candidates for the role should have the following demonstrated skills and abilities:
 
Learn quickly. Demonstrably able to learn and quickly master new data transformation and analytical skills on the job.  
 
Build relationships. Fully understand and accurately represent operational realities through data analysis by building relationships with department heads, division managers, frontline employees, and other city employees.
 
Follow up and follow through. Follow-up and persistently follow through to ensure that projects, work deliverables, and office initiatives are accurate and complete.
 
Work collaboratively and take the initiative. Ability to work collaboratively as part of a cross-functional team to create holistic solutions. Take the initiative and work independently on projects and programs while knowing when to engage colleagues.
 
Think Strategically. Develop business intelligence strategies to address problems of moderate complexity focused on a specific program, function, or service area.
 
Manage Time. Demonstrate superior time management skills: ability to effectively balance multiple responsibilities and priorities simultaneously.
 
Balanced Decision-making. Consider and weigh multiple (and sometimes conflicting) elements in the process of making decisions.

(Illustrative only. Any one position may not require all of the listed KSAs nor do the listed examples include all the KSAs which may be required.)

Knowledge of:
 Programming experience in Microsoft SQL Server.

Development of data solutions using visualization software such as PowerBI/ Microsoft Fabric
 Methodologies for conducting data analyses.
 Extract, Transform and Load (ETL) processes, software, and techniques.
 Current trends in data processing and database technology. 
 
Skill to:
 Develop SQL queries to validate data across multiple tables/views.

Perform complex analyses of problems and formulate solutions.
 Quickly understand City department’s data needs and design solutions for those needs.
 Coordinate management of cross-functional projects including working with multiple people with varying levels of technical knowledge.
 Evaluate obtained city data e.g., public safety, public services, internal services.
 
Ability to:
 Prepare clear and concise reports.

Adapt to new processes and technologies and become proficient in their use.
 Provide guidance, support, and technical supervision to other staff in all issues pertaining to applications and databases.
 Assist other users in troubleshooting problems with applications. Maintain positive employee and customer relations.
 Process complex information while maintaining attention to detail.
 Communicate clearly and concisely, both orally and in writing.
 Prioritize work; manage time to meet deadlines.
 Make decisions based on data analysis and observation.
 Maintain confidentiality of City information.
 Interrelate work from one project to another; identify and provide necessary strategies to accomplish programs and projects.
 Develop plans to ensure timely program/project execution.
 Performs other tasks related to the management of programs, policies, and procedures as needed.
 Establish, maintain, and manage relationships with client departments, offices, and external City partners around analytics and data-sharing.

RESUME AND COVER LETTER MUST BE ATTACHED
Each applicant must have a bachelor's degree in Mathematics, Finance, Statistics, Economics, Computer Science, Information Technology, Data Science, Data Engineering, Software Engineering or a related field.

OTHER REQUIREMENTS
A valid Driver's License may be required.

Environmental Conditions:  Mostly indoor environment; exposure to office computer screens; automobile travel within the City may be required.

Physical Conditions:  Duties require maintaining physical conditioning necessary for sitting and standing for prolonged time periods; light lifting and carrying; general manual dexterity required; must be able to operate assigned vehicle if required.

 

Salary : $59,243 - $90,069