MANAGEMENT ANALYST - DATA SOLUTIONS (UNCLASSIFIED)

General Statement of Duties

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.

Minimum Qualifications (KSAs)

(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.

Required Education and Experience

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.

Working and Physical Conditions

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.

The below information is solely intended as a summary of the benefits available and is subject to change. Not all benefits listed are available for every position. Benefits can vary depending on applicable labor agreements and/or salary plan. For specific questions, contact the HR Contact indicated on the Job Posting.

The City of Cincinnati offers its employees competitive salaries and a comprehensive benefit package designed to actively attract and retain quality employees' to add additional value to the City of Cincinnati's workforce. A summary of these benefits for full-time employment is listed below. This is a general listing of benefits for all employees and is not intended to be a comprehensive listing for all bargaining units.

The City offers a variety of training programs, ranging from job-specific skills such as computer and equipment instruction, to helping supervisors improve their management techniques.

Equal Employment Opportunity

The City of Cincinnati is dedicated to providing equal employment without regard to race, gender, age, color, religion, disability status, marital status, sexual orientation or transgendered status, or ethnic, national or Appalachian origin, or on the basis of any other category protected under federal, state and local laws.

Holidays

The City of Cincinnati has 11 paid holidays annually that include:

New Year's Day
Martin Luther King Day
President's Day
Memorial Day
Juneteenth
Independence Day
Labor Day
Veterans' Day
Thanksgiving Day
Day after Thanksgiving
Christmas

Health Insurance

The City of Cincinnati 80/20 offers 3 medical plans to all full time City of Cincinnati employees and eligible dependents: the 80/20 PPO medical plan, the HDHP medical plan with an HSA contribution, and a Health Reimbursement Arrangement for those enrolled on another non-city eligible group plan.

Eligible dependents include:

Legal Spouse or Equal Partner
Child (natural child, adopted child, and/or child who the group has determined is covered under a "Qualified Medical Child Support Order")
Step-child
Child for whom the employee or employee's spouse/equal partner is a legal guardian

Basic Life Insurance

A $50,000 Basic Life Insurance policy is paid for by the City for certain eligible employees. Full time employees not eligible for the City-paid basic life insurance policy are generally provided a similar benefit through their union group.

Supplemental Life, Long Term Disability, Accident & Critical Illness Insurance

Most full time City employees are eligible to participate in a supplemental life insurance program, a long term disability plan, and accident and critical illness insurance programs at their own expense. Premiums are determined by age, amount of coverage, and various additional factors.

Flexible Benefits Plans

Healthcare Flex Spending Account

City employees can participate in the Healthcare Flex Spending Account that can be used to pay out-of-pocket medical, prescription, dental, and vision care expenses for employees and family members.

Dependent Care Flex Spending Account

City employees can participate in a Dependent Care Flex Spending Account that can be used to pay work-related dependent care expenses. Participants can set aside money each year through pre-tax payroll deductions to pay for these expenses.

Transportation Expense Reimbursement Account

City employees can participate in a Transportation Expense Reimbursement Account (TERA) that can be used to reimburse expenses related to traveling to and from work. Participants can set-up a pre-tax payroll deduction up to an IRS regulated amount.

Healthy Lifestyles Program

City employees can voluntarily participate in a wellness incentive program that encourages and rewards employees and their spouses/equal partners for making positive choices for better health. The City of Cincinnati will contribute up to $300/year to a Health Reimbursement Account for each the employee and their spouse/equal partner for meeting specified program goals. These dollars can be used to offset qualified out-of-pocket medical expenses.

Integrated Health Reimbursement Arrangement (HRA)

This is a voluntary program that serves as an alternative healthcare option to traditional medical plans. If you have alternate group health coverage available to you through a spouse, equal partner, another job, or a non-city retirement plan, you may be eligible for this plan which reimburses you for the difference in premiums between the plans and your covered out of pocket expenses on the other plan.

Retirement Plan

The City provides a defined benefit pension plan for part-time and full-time employees. New hires and re-hired employees are required to participate in the City of Cincinnati's Retirement System (CRS), regardless of previous participation in an Ohio State pension system or any another state or federal pension system. CRS is funded by employer and employee contributions, and investment returns from plan assets. CRS provides retirement and health care benefits subject to eligibility requirements. The following groups are excluded from participation in CRS: Mayor and Members of City Council; Sworn Police & Fire; Police Recruits; and Rehired Ohio Police & Fire Retirees.

Deferred Compensation

As an Ohio government employer, the City offers employees the ability to participate in a 457(b) tax-deferred retirement savings plan. The City makes an annual match to your 457(b) of up to $750, or as otherwise specified in applicable regulations and union contracts.