Technical System Analyst

Under general direction, the Technical Systems Analyst is responsible for the design, implementation, maintenance, and security of the organization’s network and computing infrastructure. This position performs advanced work in network engineering, systems administration, cybersecurity, and hardware/software integration across diverse platforms. The incumbent collaborates with internal departments, external vendors, and client agencies to support critical systems, resolve complex technical issues, and implement technology solutions aligned with organizational goals. The role may lead or coordinate major technical projects and contributes to system reliability, data integrity, and disaster recovery planning.

The Metropolitan Sewer District is seeking a detail- oriented Technical System Analyst with strong data analysis and reporting skills to support the growing need for reliable, accessible, and meaningful data across the organization. This position plays an important role in helping MSD turn data from multiple systems of record into practical tools, reports, and dashboards, that support daily operations, performance tracking, and informed decision-making.

In this role, the employee will work directly with stakeholders across MSD to understand business needs, operational challenges, and reporting gaps. The employee will gather and analyze data requirements, review existing processes, and develop technical solutions that make information easier to access, understand, and use. A key focus of the position is supporting the creation of a centralized data hub that allows users to answer operational questions without needing to know the details of each underlying system.

Work is performed using modern, database tools, and reporting platforms, including Python, Microsoft Fabric, Power BI, SQL Server Reporting Services, Crystal Reports, and relational database systems. The position also applies principles of database design, statistical analysis, data visualization, business intelligence, system integration, and reporting automation.

This position requires strong independent judgement, technical expertise, attention to detail, and the ability to communicate effectively with employees, supervisors, managers, and technical staff across MSD. The employee is expected to stay current with emerging technology, reporting tools, and analytical methods in order to improve data quality, system efficiency, and the overall usefulness of MSD's reporting and business intelligence resources.

(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:
Modern principles and practices of computer programming, system analysis and networking.
Methods and techniques of data processing, database management and information storage and retrieval.
Principles of budget preparation and control and of cost estimation; basic accounting and marketing.
Principles of supervision, training and performance evaluation; City personnel policies and procedures.
Pertinent federal, state and local laws, codes and regulations.

Ability to:
Supervise, direct and coordinate the work of lower-level staff.
Select, supervise, train, motivate and evaluate staff.
Interpret and explain City policies and procedures.
Prepare clear and concise reports.
Communicate clearly and concisely, both orally and in writing.
Troubleshoot computer hardware and software problems.
Negotiate the obtainment of hardware, software and services from vendors.
Analyze and correct complex problems.
Prepare clear and concise schematics.
Handle personnel matters, grievances and disputes.
Establish and maintain effective working relationships with those contacted in the course of work including City and other government officials, community groups and the general public.
Develop work plans and schedules.
Install, maintain, debug, calibrate and update computer hardware, software and network hardware.
Explain complex computer concepts, software packages and hardware functions.
Work with a variety of computer hardware and software.

PROMOTIONAL: Four years as a Senior Computer Programmer Analyst with the City of Cincinnati.

OPEN: Each applicant must have three years of paid professional experience in hardware installation/management, network administration, security operations, system administration, or software development experience plus a bachelor's degree from an accredited college or university with major course work in GIS, geography, planning, computer science or a related field

OR

Each applicant must have five years of paid professional experience with at least three years of experience in hardware installation/management, network administration, security operations, system administration, or software development experience plus an associate degree from an accredited college or university with major course work in GIS, geography, planning, computer science or a related field.

MILITARY EDUCATION & EXPERIENCE EVALUATIONMilitary education and experience may be substituted for college level course work at the lower and upper division baccalaureate and graduate levels and apprenticeship training at the vocational certificate level on a case by case basis based on the American Council on Education (ACE) Military Guide recommendations.

Environmental Conditions:
Indoor environment; exposure to office computer screens; work alone and closely with others.

Physical Conditions:
Essential and other important responsibilities and duties require maintaining physical condition necessary for sitting or standing for prolonged periods of time; general manual dexterity required.

Examples of Work Performed

(Illustrative only. Any one position within this classification may not include all of the duties listed nor do the listed examples include all of the tasks which may be performed.)

Design, coordinate and schedule a variety of advanced technical projects.
Design and maintain sewer and network configurations with the aim of controlling and improving overall productivity of resources.
Design, code and maintain specialized software: utilities/application interfaces/ message routers/ analysis tools/etc.
Implement and maintain security systems on various computer platforms.
Maintain and exercise plans for recovering data processing capabilities in case of power failure or other system failures.
Review application design specifications in areas of assents, alternatives, requirements and detailed design.
Disseminate information on relevant topics; provide seminars, publish documents on procedures, methods, software changes, known problems, etc.
Maintain an Internet firewall to protect the enterprise network and severs while allowing client access to the Internet.
Maintain Domain Name Services within the enterprise TCP/IP network.
Assist those contacted in the course of duty in an effective, efficient and professional manner.
Perform related duties as assigned.