Salary: $54,886 - $82,342

Position Grade: 211G

Department: Refuse Division

Job Type: Full-Time (Permanent)

Examination Number: EX1690

Location: St. Louis, MO

The GIS Specialist II/Graphic Designer uses professional knowledge of Geographic Information System (GIS) technology to compile information, and develop and revise maps and graphic designs using computer software and equipment for the City of St. Louis Refuse Division.

Essential Functions and Responsibilities:

• Edit and maintain Traffic and Refuse GIS datasets, including but not limited to layers, fields, domains, geometric networks, and associated attributes and assets. Operational examples include refuse routes, refuse collection areas, traffic signals, and street lighting.
• Produce high-quality digital and printed GIS maps that effectively communicate geographic information by creating and maintaining map documents (.mxd), including symbology, table joins, and labeling. Operational examples include digital refuse routes for drivers and traffic signal maps overlaid with network attributes.
• Coordinate and track GIS projects to ensure schedules and deadlines are met while keeping stakeholders informed. Example projects include load balancing of refuse routes and providing data to support lighting upgrade initiatives.
• Perform routine quality assurance and quality control (QA/QC) checks of GIS data to ensure data integrity and accuracy, documenting and resolving identified issues.
• In coordination with ITSA, create user groups and roles, manage user access, maintain folder and file structures, and develop GIS protocols for SLDC. Perform other duties as assigned.

Asset Inventory Management

• Database Maintenance: Update and maintain enterprise geodatabases (SDE) containing critical infrastructure data.
• System Integration: Facilitate the technical integration of spatial data with other city enterprise platforms, including Cityworks asset management, permitting (PLL), and CAD systems.
• Data Quality Control: Enforce quality control protocols on all asset updates submitted by distributed City GIS users and agencies.
• Data Presentation: Build spatial views within Microsoft SQL Server environments to support asset reporting and map visualization.

Routing and Network Maintenance

• Routing Package Automation: Maintain and run Python scripts and SQL Server Agent jobs to automate routine routing network updates and agency data integrations.
• Service Publishing: Use Portal for ArcGIS and GIS Server to deploy and maintain mobile map packages, routing services, and web adaptors/REST APIs for city field crews.
• Performance Monitoring: Support business performance analysis and optimization by providing GIS data in support of those needs.

Support and Coordination

• User Support: Act as an integral team member of the distributed City GIS workforce, particularly regarding asset tracking and routing datasets for the Street Department and its Divisions.
• Technical Training: Train city staff and system end-users on using ArcGIS Enterprise technologies and mobile data collection platforms.

Knowledge, Skills, and Abilities:

• Data Utilization: Requires the ability to perform mid-level data analysis including the ability to audit, deduce, assess, conclude and appraise. Requires discretion in determining and referencing such to established criteria to define consequences and develop alternatives.
• Human Interaction: Requires the ability to provide guidance, assistance and/or interpretation to others, such as coworkers, interns, various city departments and the public, on how to apply policies, procedures and standards to specific situations.
• Equipment, Machinery, Tools and Materials Use: Requires the ability to operate and perform complex rapid adjustment on equipment, machinery and tools such as computer terminal, plotter, printers, telephone, and/or related materials used in performing essential functions.
• Verbal Aptitude: Requires the ability to utilize a variety of reference, descriptive and advisory data and information such as computer software operating manuals, work orders, text copy for publications, clip art manuals, graphic design manuals, training manuals, procedures and guidelines.
• Mathematical Aptitude: Requires the ability to perform addition, subtraction, multiplication and division; calculate percentages, fractions and decimals; perform mathematical operations involving basic algebra, geometry and trigonometry.
• Functional Reasoning: Requires the ability to apply principles of rational systems. Ability to interpret instructions furnished in written, oral, diagrammatic or schedule form. Ability to exercise independent judgment to adopt or modify methods and standards to meet variations in assigned objective.
• Situational Reasoning: Requires the ability to exercise the judgment, decisiveness and creativity required in situations involving the evaluation of information against measurable or verifiable criteria.
• Environmental Factors: Tasks are regularly performed in safe and comfortable surroundings without exposure to adverse environmental conditions.
• Physical Requirements: Requires the ability to clearly distinguish objects in close range and sustain prolonged visual concentration.
• Sensory Requirements: Ability to conceptualize and apply characteristics of colors and shapes to develop graphic designs. Ability to combine and harmonize graphic design characteristics, as well as recognize and identify degrees of similarities or differences between characteristics.

A Bachelor's degree in Geographic Information Systems, Cartography, Computer Science, Information Systems, Graphic Design, or a closely related field; plus one year of computer mapping and graphic design experience which includes using AutoCAD and ArcGIS Software. OR an equivalent combination of education, training and experience.

License: Must possess and maintain a valid driver's license while employed by the City of St. Louis. Must possess a valid driver's license at the time of filing application and be able to present it upon request. Please note type of license, number, class and expiration date on the Employment Application. Only qualified applicants who provide proof of a valid driver’s license will be considered for this position.

Scoring Components and Their Weights
Experience and Training: 100%
May be Subject to:
Background Investigation: Pass/Fail
Medical Examination: Pass/Fail

Documentation of Academic Credentials must be Submitted Upon Request

When completing the Employment History and the Educational/Training History sections of the Employment Application, please be as thorough as possible when describing your education, training and experience relating to this position. Applicants will only receive credit for their experience, training and education as shown on the application. Resumes will not be accepted as a substitute to a fully completed application. Incomplete applications will not be considered.

Veterans Preference Points

To be eligible for veteran's preference points, the applicant must submit a copy of their DD 214 Certificate of Release or Discharge from Active Duty with the Employment Application or upon request. The Director of Personnel may, in their discretion, accept alternate documentation.

City Residence Preference Points

City residents who pass an examination for a position in the classified service and do not receive any other preference will receive a five (5) point preference on a scale of 100 points on the exam. An additional one (1) point shall be added to the passing score of City residents who receive any other preference on a scale of 100 points. City residents must have resided in the City for at least one (1) year at the time of filing their application to be eligible for the preference points.

Accommodations

If assistance with the job application is necessary based on a physical impairment, mental impairment, or otherwise, they should reach out to the Office on the Disabled with contact information. This office will not disclose any information that an applicant or employee has a disability or has discussed possible accommodations without the applicant's or employee's prior consent.