The Eugene Police Department is currently seeking a Data and Reports Specialist. We’re looking for someone who is passionate about what they do, has a strong work ethic, and wants to have a positive impact on their community. This is a full time position with the City of Eugene and is partially remote: a typical work week is Monday, Wednesday and Friday remote, and Tuesday and Thursday at EPD headquarters on Country Club Road.
The application window for this posting closes Friday 9/23/2022.
A well-qualified individual will have knowledge of:
Scripting and coding for automation, data ingestion, and data extraction purposes.
Microsoft SQL Server.
Microsoft SQL Server Management Studio.
Microsoft Excel (lookups, formulas, pivots, macros).
GIS concepts such as cartography, relational databases, data validation, coordinate systems, projections, and transformations.
Converting spatial data from various sources into SQL Server geometries.
The ability to:
Develop, test, and modify various SQL queries, stored procedures, views, and functions.
Extract, analyze, organize, and compile system data into spreadsheets and analytical reports.
Write SQL statements to join, filter and aggregate data stored in relational databases.
Convert spatial data from various sources into SQL Server geometries.
Minimum Requirements: Combinations of experience and education which meet the minimum qualifications will be considered.
Education: Equivalent to an Associate Degree in Computer Sciences, Information Technology, or a closely related field.
Experience: Four years of progressively responsible paraprofessional experience in Information Technology, Database Management, or a closely related field.
Additional Requirements: MUST PASS A POLICE BACKGROUND INVESTIGATION
Full details and application are available here:
Original Article: Source