Senior Computer Programmer Analyst

City of Cincinnati • Ohio 45202, OH

1d • Onsite

About The Position

The Metropolitan Sewer District is seeking a skilled and motivated Senior Computer Programmer Analyst (SCPA) to join our IT team. This role will be responsible for developing data integrations, automated scripting, and Power BI dashboards; effectively bridging the gap between legacy platforms and emerging technologies. The ideal candidate has strong expertise in Python, APIs, and data stewardship, along with excellent oral and written communication skills. Additional duties will be assigned to support departmental objectives.

Requirements

• Principles of computer data processing.
• Design, installation, and maintenance of enterprise, distributed, client server, and desktop computer systems.
• Principles and practices of computer network systems analysis and design.
• Current trends and new technologies in data processing.
• Desktop software packages and operating systems.
• Principles of effective documentation.
• Principles of providing effective customer service.
• Methods and practices of installation for upgrading of client servers and desktop computer, hardware and software.
• Computer system configurations.
• Operating system structures.
• Local area network hardware and transmission protocols.
• Data communication concepts and principles.
• Internet and intranet architecture.
• Network security policies, techniques, and procedures.
• Network configuration, maintenance, and diagnostic procedures and techniques.
• Licensing Agreement enforcement.
• Standard programming languages.
• Computer operating systems/hardware.
• Program design and analysis.
• Principles and techniques of programming.
• Programming languages (Java, C, C++, Visual Basic, etc.) and utilities.
• Database management systems.
• Database design.
• Database tools.
• Data/file management tools.
• Database utilities.
• Data warehouse and multi dimensions.
• File and data recovery.
• Database security methods and techniques.
• Physical control standards and procedures.
• Database software (Oracle, SQL, etc.)
• In-depth graphic design.
• User interface design.
• Advertising and marketing.
• Information architecture.
• Management of e-commerce.
• Front-end web code such as HTML and JavaScript.
• Business systems analysis.
• Business software packages.
• Desktop GIS software for analysis, query, and visualization (e.g., ESRI's ArcView).
• WEB-based GIS application interfaces and data presentation.
• Desktop or Workstation GIS advanced software for data creation, geo processing, and conversion (e.g., ESRI's Arc Info).
• Geo-locational and Geo-relational dataset concepts and database structures.
• Engineering/surveying principles and practices as related to GIS and GPS (global positioning systems) applications.
• Interface and integration of GIS database systems with other public enterprise systems such as permitting, licensing, and financial systems.
• Install, configure, upgrade and maintain hardware and software, including that related to local and wide area networks.
• Perform hardware modifications such as chip replacement and board swaps.
• Troubleshoot and resolve network hardware and software problems.
• Use and maintain networking test equipment.
• Read and prepare clear and concise reports and technical documents.
• Work with minimal supervision.
• Provide effective customer service.
• Develop and recommend cost effective improvements for technical systems.
• Implement systems based on design specifications and instructions.
• Evaluate and recommend purchase of computer equipment, services and supplies.
• Analyze, design, program, test, debug, document and maintain various systems and applications.
• Develop procedures and means of storage for archiving data.
• Expertise in Python, APIs, and data stewardship.

Nice To Haves

• Power BI dashboards

Responsibilities

• Performs a variety of professional, technical, and analytical duties in the operation of enterprise, client/server, and desktop computer systems and networks.
• Assists in the analysis of city, county, and criminal justice agencies' data processing needs.
• Assists in the design, testing, and implementation of systems.
• Performs network design, implementation and maintenance, data/database analysis/administration, and modifications to existing computer applications.
• Develops data integrations, automated scripting, and Power BI dashboards.
• Bridges the gap between legacy platforms and emerging technologies.
• Installs and maintains servers and network equipment.
• Troubleshoots any application or server connections.
• Installs, configures, and troubleshoots office network software and operating systems.
• Identifies the need for hardware and software upgrades and performs upgrades.
• Under minimal supervision, develops specifications, codes, tests and documents application programs.
• Under minimal supervision, develops specifications, codes, and tests interfaces and conversion programs or procedures.
• Creates and maintains medium project work plans.
• Creates data flow documents which detail systems or business problems.
• Evaluates and tests options for backup, restoration, and recovery procedures.
• Identifies software requirements.
• Drafts requests for proposals to accomplish design objectives.
• Evaluates and specifies hardware and software configuration and places orders with vendors.
• Applies a general understanding of protocols, topology, hardware and software, and network design.
• Evaluates and specifies networking equipment and application.
• Applies network hardware and software troubleshooting skills.
• Provides second level network problem escalation resolution.
• Develops and administers end-user training programs.
• Assures that appropriate IT security is considered in all tasks.
• Acts in compliance with the City of Cincinnati's Information Security Policy, Administrative Regulations, and related standards and procedures in the City's Human Resources Policies and Procedures.

Benefits

• Valid Driver's License for some positions.
• Criminal background investigation and fingerprinting may be required for some positions.
• May be required to work irregular hours and be on-call.
• Military 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree