- Nature of Work, Essential Functions & KSA's
You can do great work and love what you do with the City of Delaware. We are an organization that succeeds because of teamwork, dedication, diversity, and the innovative spirit of all our employees. The City of Delaware is an award-winning local government organization known for its professionalism, customer service orientation and a strong commitment to distinctive and well-planned community development. The work environment is stable with excellent benefits and retirement packages. Our mission is to ensure an effective government, a healthy economy, being a safe city and welcoming you to be a part of this great community!
Under the direction of the Public Utilities Director, the GIS/CMMS Analyst's primary responsibility is to discover patterns and trends through spatial mapping, develop mapping applications and tools and manage a digital library of geographic maps in various file types, among other duties. The position explains geographic trends and findings from analyses to City employees and other parties as needed.
ESSENTIAL FUNCTIONS: For purposes of 42 USC 12101
- Analyzes spatial data using mapping software.
- Discovers patterns and trends through spatial mapping of data.
- Designs digital maps with geographic data and other data sources. Builds and/or publishes live GIS maps for display or report purposes.
- Creates "shapefiles" to merge topographical data with external data by layering external data over a topographical map.
- Produces maps showing the spatial distribution of various kinds of data, including crime statistics and hospital locations.
- Develops mapping applications and tools.
- Converts physical maps into a digital form for computer usage.
- Performs data munging and cleaning to convert data into its desired form.
- Produces reports on geographic data utilizing data visualizations.
- Manages a digital library of geographic maps in various file types.
- Updates existing reports.
- Recommends appropriate reactionary strategies in response to GIS/data analysis.
- Integrates programming, mapping, and cartography.
- Converts and manipulates graphics and different database file structures.
- Utilizes data information for query and analysis purposes.
- Utilizes ArcGIS for Server and/or ArcGIS Online to develop and maintain a customized Internet website for GIS.
- Analyzes data from departments to assist in creating best practices for managing assets.
- Performs other duties as assigned.
KNOWLEDGE, SKILLS, AND ABILITIES
- Microsoft Office applications (e.g., Outlook, Word, Excel, Publisher, Access, Sharepoint, OneNote, and Teams) and other computer software.
- City and Department goals and objectives.
- City and Department policies and procedures.
- Government structure and process.
- Standard office procedures.
- ESRI's ArcGIS core products.
- GIS spatial development techniques and digitizing and data manipulation procedures for GIS.
- Geographic Information Systems (GIS) and concepts such as ESRI ArcGIS Online, ArcGIS for Server, ArcGIS for Desktop, Python, and Internet development tools.
- SQL databases.
- Use of plotters, scanners, GPS, and IOS/Android systems for data collections.
- ESRI's ArcGIS for Desktop software applications combined with associated analysis modules and data storage architecture.
- Symbols and terminology used in civil, architectural, or electronic engineering drawing.
- CityWorks or other GIS-centric asset management software used to perform inspection, monitoring, and condition assessment preferred.
- BI Report building tools such as Microsoft Power BI
- Excellent organization, attention to detail, accuracy, time management, and critical thinking skills.
- Using tact, discretion, initiative, and independent judgment within established guidelines.
- Civic engagement and customer service.
- Use of Geographic Information Systems (GIS) and concepts such as ESRI ArcGIS Online, ArcGIS for Server, ArcGIS for Desktop, Python, and Internet development tools.
- Advanced SQL database skills.
- Composing, editing, and proofreading a variety of correspondence, reports, and forms.
- Outstanding quantitative skills, attention to detail and good problem-solving skills and an analytical mindset.
- Outstanding quantitative skill set.
- Attention to detail and good problem-solving skills.
- Deal with many variables, define and solve problems, collect, analyze, and interpret data, establish facts, and determine specific action.
- Operate assigned equipment.
- Maintain a high level of confidentiality about information within the office.
- Add, subtract, multiply, and divide.
- Calculate fractions, decimals, and percentages.
- Prepare correspondence.
- Compile and prepare reports.
- Understand and follow written and oral instructions, policies, and procedures.
- Be honest, dependable, and trustworthy.
- Maintain effective working relationships.
- Communicate effectively, both in oral and written form and to prepare and present effective public presentations.
- Exercise independent judgement and discretion.
- Work in a professional office environment.
- Provide high level technical assistance and support by analyzing difficult problems and recommending solutions.
- Use graphic design application and follow graphic instructions such as blueprints, layouts, or other visual aids.
- Diagnose technical problems and recommend solutions.
- Work and maintain a professional demeanor during stressful situations.
- Work effectively as a team member.
- Make presentations to small and large audiences, and to train users on software.
- Have an analytical mindset.
- Run advanced SQL Queries.
- Illustrative Examples of Work / Physical Requirements & Working Conditions
- The primary duties of this position are performed in a general office environment with regular visits to off-site City facilities.
- Sufficient clarity of speech and hearing or other communication capabilities, with or without reasonable accommodation, which permits the employee to discern verbal instructions and to communicate effectively with others in person and over the telephone.
- Sufficient visual acuity, with or without reasonable accommodation, which permits the employee to comprehend written work requests, to diagnose and detect problems and to develop effective system solutions.
- Sufficient manual dexterity, with or without reasonable accommodation, which permits the employee to operate computer equipment and components, power tools and other office equipment.
- Sufficient personal mobility and flexibility, with or without reasonable accommodation, which permits the employee to work in an office setting and to sit for extended periods of time.
- Sufficient ability and strength to lift, carry, or otherwise move objects up to fifty (50) pounds for varying distances.
Computer, copier, phone, and other standard/modern office equipment; computer software (e.g., Microsoft Office, ESRI ArcMap, ESRI ArcPro, Power BI, and other applicable computer software).
- Training, Experience, and Qualifications
- Bachelor’s degree in computer science, data analytics, geography, engineering.
- Two (2) or more years of experience in GIS analysis.
- Proficiency with database programming languages such as SQL or Python.
- Experience with mapping tools.
- Experience with GPS measuring tools.
- Possession of a valid State of Ohio driver’s license and ability to maintain insurability under the City's vehicle insurance policy.
- Regular and reliable attendance
- Any combination of training and experience which will indicate the possession of the skills, knowledge and abilities listed below.
- Supplemental Information / Special Requirements
The City of Delaware offers a complete benefits package to full-time employees including: health, dental, and life insurance, retirement pension and savings plans, paid holidays, vacation, sick leave, and longevity pay and in many positions, paid uniforms or clothing allowance. This position is part of the Management Pay Plan. Details about the compensation and benefits for this position can be found in the agreement by clicking here.
The information above is intended to be illustrative of the kinds of duties that may be assigned to the position and should not be interpreted to describe all the duties which may be required of employees holding this position.
The City of Delaware is an Equal Opportunity Employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status. In compliance with the Americans with Disabilities Act (ADA) and the Americans with Disabilities Act Amendment Act (ADAAA), the City of Delaware will provide reasonable accommodations, upon reasonable request, to qualified individuals with disabilities and encourages both prospective employees and incumbents to discuss potential accommodations with the employer.