Senior Computer Programmer Analyst

About the role

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.

Minimum Qualifications (KSAs)

- Knowledge of: - 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 computers, hardware and software. - Computer system configurations. - 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. - Programming: - 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 Administration: - Database management systems. - Database design. - Database tools. - Data/file management tools. - Database utilities. - Data warehouse and multidimensional. - File and data recovery. - Database security methods and techniques. - Physical control standards and procedures. - Database software (Oracle, SQL, etc.). - Web: - 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: - Business systems analysis. - Business software packages. - GIS: - 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 georelational 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. - Skill to: - 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.

Required Education and Experience

Each applicant must have completed an Associate's Degree from an accredited college or university with a major in computer science, information technology, computer programming, criminal justice, geography or a related field. In addition, each applicant must have one year of professional paid work experience performing work similar to that listed under "Examples of Work Performed." OR Each applicant must have completed 45-quarter credit hours from an accredited college or university with 30 of the 45 credit hours being in computer science, information technology, and/or computer programming. In addition, each applicant must have two years of professional paid work experience performing work similar to that listed under "Examples of Work Performed." A certification program, such as a Novell or Windows NT engineer, may substitute for one year paid work experience (completion of other certification programs not listed will be reviewed on a case-by-case basis).

Working and Physical Conditions

Environmental Conditions: Office environment, exposure to computer screens; travel to sites within the City/Hamilton County may be required. Physical Conditions: Duties require maintaining physical condition necessary for sitting and standing for prolonged periods of time; general manual dexterity; must be able to operate assigned vehicle (as required).