Data Analysis and Entry Clerk - W&S Engineering (Term Limited)

Full Salary Range:                    $23.70 - $30.82 Hourly

Anticipated Hiring Range:      $23.70 - $27.26 Hourly 

Why do I see two salary ranges?

The City of Greeley in compliance with Colorado state law, includes a salary range for all positions posted.  This law is intended to improve wage transparency.  The City of Greeley, in support of wage transparency, posts both the full salary range for each position (what you might anticipate your earnings could be if you work for the City of Greeley for some time), as well as the anticipated hiring range (the range within which the City anticipates making an offer).  The actual offer extended will be based on your years of relevant experience, education, certifications and potentially other factors.  

City of Greeley's Total Rewards

The City of Greeley is proud to offer a robust benefits package in addition to your wages.  This package includes health and wellness, retirement savings, discounted access to Greeley facilities and more. 

This position is benefit eligible. Please view our benefits guide here. 

*This position is a full-time, term-limited position funded through December 31, 2027, with the possibility of becoming permanent if additional funding is approved at a later date.  This position is eligible for full time benefits.

Job Summary:

The City of Greeley Water & Sewer Department is seeking an individual who are committed to providing support for a growing, dynamic community. As part of the Engineering Division, you will work with other dedicated employees to enhance Greeley’s water leadership role through work with the Lead Protection Program within the community. To comply with new Environment Protection Agency (EPA) regulations, the Water & Sewer Department is developing an inventory of all water service lines within the city and replacing those that are found to contain lead. The Data Analysis and Entry Clerk will support the Lead Protection Team by compiling and organizing historical City records and data according to Colorado Department of Public Health & Environment (CDPHE) guidelines. Duties include assisting in project preparation, communications,  historical document review, record-keeping with data input, data management, data review, and quality control. This position requires a self-motivated candidate with sound judgment, problem solving skills, and data management abilities who can work in collaboration with the project team.   

Experience, Knowledge, and Skills:

MINIMUM REQUIREMENTS:

• Valid, unrestricted driver’s license
• Associates degree from an accredited college.
• One (1) year of record-keeping experience with data input, record-keeping, data management, data review and quality control.
• One year of Administrative experience.
• Two (2) years of experience using Microsoft Excel for data input, validation, visualization, and analysis, FILTERS, VLOOKUP, and other advanced features required
• Experience with GIS or similar programs to display and edit data.

OR                       

• A combination of related education, experience, certifications, and licenses that will result in a candidate successfully performing the essential functions of the job may be considered by the hiring authority.

PREFERRED:

• Bachelor’s degree (four-year degree) from an accredited college or university in a related field.
• Experience with advanced Excel features is preferred.
• Two (2)  years’ experience with ESRI ArcGIS maps, and dashboards with the ability to create maps, extract attribute data, and generate reports.
• Previous experience working on engineering projects within a municipality, utility, or engineering firm.

Knowledge, Skills, and Abilities:

• Knowledge of the business and organizational structure of Colorado municipalities 
• Collaboration skills, including the ability to work with others from different areas and backgrounds to reach a common goal 
• Computer skills, including the ability to utilize Microsoft Office programs (i.e. Word, Excel, PowerPoint, Outlook, etc.) and learn and experiment with new software and systems
• Interpersonal skills, including the ability to facilitate interaction, communication, and teamwork between others
• Oral, written, and listening communication skills, including the ability to accurately interpret what others are saying and convey messages, information, concepts, and details accurately and clearly
• Organizational skills, including the ability to set and meet goals and deadlines, manage appointments, create schedules, coordinate, and facilitate meetings, and make decisions 
• Ability to work under pressure, manage multiple concurrent and competing tasks and responsibilities, and adapt to changing priorities while maintaining personal effectiveness
• Ability to prioritize work, meet deadlines, and stay on task when completing special projects and daily assignments
• Ability to work independently with minimal supervision and reliable professional judgment, as well as collaboratively with a team to achieve desired results
• Ability to maintain a strong work ethic, positive problem-solving attitude, and enthusiasm for the work performed
• Ability to self-start and take initiative in completing daily tasks and special projects
• Ability to focus on activities that have the greatest impact on meeting work commitments
• Ability to establish and maintain partnerships with a variety of internal and external constituencies
• Ability to communicate and work effectively with individuals from diverse backgrounds, cultures, and ages
• Ability to navigate a complex political environment
• Ability to  adapt to evolving project needs.
• Strong attention to detail and ability to methodically manage repetitive tasks and data.
• Ability to document procedures and findings for replication.
• Ability to be self-motivated to investigate data sources, identify patterns, and understand the bigger picture.
• Ability to proficiently digest, understand, and analyze large amounts of data.

Essential Functions (Duties and Responsibilities):

• Prepare lists, spreadsheets, and reports to communicate and track project tasks.
• Data management – categorizing service line status and ensuring properties are on the correct list and customers are receiving the correct communication pieces regarding their service lines.
• Use ArcGIS to review and export data.
• Email and phone communication with customers, responding to program queries.
• Drafting letters and other communication pieces.
• Researching properties and their historical records. Review and scan historical physical records, perform efficient and accurate data analysis and entry. 
• Document Standard Operating Procedures to facilitate quality control. Thorough documentation of processes and findings for regulatory compliance reporting.
• Assist with project reporting tasks.
• Utilize other data sources as necessary including Weld County Data, GIS and other resources for data retrieval and comparison.
• Review and scan historical physical records, perform efficient and accurate data analysis and entry.
• Manage and populate a database of historical data from multiple sources.
• Determine limitations in data reliability, follow and develop Standard Operating Procedures to facilitate quality control.
• Utilize other data sources as necessary including Weld County Data, GIS and other resources for data retrieval and comparison.
• Thorough documentation of processes and findings for regulatory compliance reporting.
• Folder and file management.
• Taking meeting minutes.
• QA/QC of data supplied by contractors, follow up with inconsistencies and reconcile.

Work Environment and Physical Requirements: 

• Work is primarily performed in an office environment with extended periods of time at a fixed workstation
• Work independently and collaboratively and attend meetings.
• Exposure to standard office conditions with minimal adverse environmental elements.
• Occasional physical activities such as bending, standing, carrying, and lifting objects of varying weight. 
• Close visual acuity required for tasks such as: data analysis; transcribing; viewing a computer terminal; and extensive reading of printed materials. Visual acuity includes close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.
• While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear.
• The employee is occasionally required to stand.
• The employee must occasionally lift and/or move up to 10 pounds.
• Specific vision abilities required by this job include close vision, peripheral vision, depth perception, and ability to adjust focus.
• Vision enough to read computer keyboards, reference books and other written documents. 
• Communication skills sufficient to convey information to the public via telephone and in person. 
• Manual dexterity sufficient to accurately input, retrieve and verify work assignments.

EOE Statement: The City of Greeley provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

ADA Statement: We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting.  Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: HR@Greeleygov.com .

Conditions of Employment: Candidates must successfully complete all pre-employment screenings and employment eligibility verification. Pre-employment screenings include a drug test, a background and national sex offender search, a motor vehicle record search, and for some positions, a physical demands evaluation. For more information about City policies and practices during the recruitment process, including but not limited to EOE, Reasonable Accommodation, and pre-employment screenings, please visit our career page HERE.

Salary : $24 - $31