Data and Reports Specialist



Data and Reports Specialist

Salary

$69,534.40 - $86,652.80 Annually

Location

Eugene, OR

Job Type

Full-Time Regular

Job Number

03249

Department

Police Department

Division

Police Administration

Opening Date

05/23/2022

Closing Date

7/15/2022 5:15 PM Pacific

General Statement of Duties

Application Deadline: Friday, July 15, 2022 at 5:00 pm PDT 
ONLINE APPLICATIONS ONLY 

Application deadline extended to July 15 (Posting Updated: 6/29/22)

--------------------------------------------------------------------------------- 

The Data and Reports Specialist works in the Eugene Police Department Crimes Analysis Unit. Performs a variety of advanced paraprofessional duties requiring extensive specialized knowledge and experience in statistical reporting, and may require related administrative technical knowledge. Responds to requests for information by accessing data both through customized applications and by developing queries through direct database connections. Provides assistance to the Crime Analysis Manager and is responsible for the administration of a specialized area which includes implementing, coordinating and administering complex paraprofessional-level activities to include the department's automated reporting system.


Salary Range: $30.61 - $38.13

Department/Division:  Eugene Police Department / Finance and Administrative Division

Work Location: 300 Country Club Road. Eugene, OR 97401 

Must reside in the state of Oregon and be able to report onsite for work as needed in Eugene, OR to meet business needs. 

Schedule: Monday - Friday, 8:00 AM - 5:00 PM with flexibility per business need


Living & Working in Eugene:

For more information on living in Eugene, how the City of Eugene operates, and more, visit this page.

Examples of Duties Performed - Duties may include but are not limited to the following

  • Develops and maintains manual and computerized databases to track program or operational activities.
  • Utilizes scripting languages to design and create standard and customized reports; establishes and maintains complex recordkeeping systems. Executes complex statistical reports requiring detailed research and independent judgment.
  • Designs and creates standard and customized reports; establishes and maintains complex recordkeeping systems. Executes complex statistical reports requiring detailed research and independent judgment.
  • Coordinates, implements, and administers a variety of projects and activities; coordinates with other departments and/or jurisdictions; defines and resolves administrative and operational issues and problems.
  • Develops administrative and operating procedures and controls for carrying out activities related to law enforcement statistical reporting.
  • Researches alternatives to achieve objectives and recommends necessary program adjustments or operational focus and/or activities; is responsible for designing and implementing approved program changes.
  • Develops systems, manuals, and forms for assigned area; writes instruction manuals describing procedures and requirements.
  • Represents the program area or department at task forces, committees, etc., as assigned.
  • Assists in developing long and short range program goals; evaluates objectives, policies and processes and provides recommendations to program manager; participates in the development of program or operational guidelines.
  • Develops work plans, timelines and resource allocations for assigned program or operational area; monitors progress to ensure objectives and deadlines are met.
  • Interprets laws and ordinances; reviews legislation and other rules and regulations pertaining to law enforcement statistical reporting; monitors program activities for compliance with Federal and/or State laws.
  • May schedule, oversee the work activities of, and provide training to staff in lower classifications, temporary clerical employees and/or volunteers.
  • Actively supports and respects diversity in the workplace. Performs other related duties as assigned.
  • Performs related and other duties as assigned. 

To view detailed information on the duties, knowledge, and abilities that may be expected for this position, please see the classification: Senior Program Coordinator

Qualifications

Introduction to Qualifications: Any equivalent combination of education and experience which provides the applicant with the knowledge, skills, and abilities required to perform the job. Studies have shown that women and people of color are less likely to apply for jobs unless they believe they are able to perform every task in the job description. We are most interested in finding the best candidate for the job, and that candidate may be one who comes with relevant transferrable skills from a variety of sources and experiences. The City will consider any equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role. Licenses that are listed as minimum qualifications must be held to be considered for the position.  

A typical way to obtain the knowledge and abilities would be: 

Knowledge of: 

  • Microsoft Excel (lookups, formulas, pivots, macros) 
  • Microsoft SQL Server
  • Microsoft SQL Server Management Studio
  • Scripting and coding for automation, data ingestion, and data extraction purposes
  • GIS concepts such as cartography, relational databases, data validation, coordinate systems, projections, and transformations.
  • Converting spatial data from various sources into SQL Server geometries.

 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. 

Licenses and Certificates: 

Oregon Driver’s License (ODL): Valid Oregon driver’s license, or ability to obtain by date of hire; must pass driving records check and, if hired, maintain a driving record that meets the City’s standard. Oregon law requires that an out-of-state license holder must obtain a valid Oregon license (with appropriate endorsements) within 30 days of becoming domiciled in the state (ORS 803.355). 


Additional Requirements: 

MUST PASS A POLICE BACKGROUND INVESTIGATION  

Supplemental Information

Selection Process: Applicants are screened based upon their relevant knowledge, abilities, skills, experience, and training. The selection process varies according to the position and can include such things as screening of supplemental questionnaires, written or skill tests, ability or fitness tests, interviews, and assessment processes. In addition, background investigations and records checks may be required. Applicants selected to continue in the process will be notified within two-three weeks after the posting deadline.  

What You Can Expect from Our Application Process: 
1. Submit your application materials. 
2. Your application is reviewed by a person for relatable skills and experience that can but used to meet the minimum requirements of the role. 
3. Your application supplemental question answers are reviewed by at least two reviewers to make sure that distinct lenses are used to see your perspective and unique characteristics. Take your time on your answers, they are really important! 
4. Interview invites are extended. (There can be more than one round of interviews.) We use panel interviews where all interviewees are asked the exact same questions to provide the same opportunity to each candidate. 
5. Finalists are discovered, and references and backgrounds are checked. 
6. Pay equity reviews are performed to avoid any pay gaps or inequities. 
7. Offers are made. 

 
Once the posting closes, the process can take 4-8 weeks to complete. 
 
Our recruiting goal is the find the best candidate to help us grow and serve.  In order to do that, we are very intentional and mindful throughout each element of the process.  We know that means a little more time to get to the end, but we believe that making sure each employee is in a role that they can succeed in is important to our community's success. 


Current information about the status of a job posting is available by going to www.eugene-or.gov/jobs and selecting "Job Posting Status". 

 

The City of Eugene complies with the Americans with Disabilities Act of 1990. Any applicant with a qualified disability under the Americans with Disabilities Act may request accommodation by contacting an employment coordinator at (541) 682-5061. 

  

In compliance with the Immigration Reform and Control Act of 1986, the City of Eugene will request all eligible candidates who accept employment with the City to provide documentation to prove they are eligible for employment in the United States. 

  

The City of Eugene is committed to a Respectful Work Environment, we value the cultural, educational, and life experiences of each employee. We believe that a diverse workforce enables us to deliver culturally responsive services to all members of our community. As part of our commitment to diversity, equity, and inclusion we desire to welcome, respect, and create a sense of belonging for a wide range of identities and experiences in our workforce.  Women, people with disabilities, and persons of color are strongly encouraged to apply. 

If a job posting indicates this position is temporary (not limited duration) then the employee serves at will. Temporary employees do not receive benefits through the City of Eugene unless required by City, State or Federal code/statute.
 
Representation
Employees in this classification are represented by American Federation of State, County, and Municipal Employees (AFSCME), and their salaries may be subject to a monthly payroll deduction after 31 days of employment.

Salary and Benefits
The normal starting salary is the first step shown on the posting. Other placement in the salary range may be considered depending on qualifications and experience. Periodic advancement through the salary range is dependent upon merit. The City provides a full range of benefits, including holidays, vacation, sick leave, retirement benefit, and life insurance. Health, dental, and vision benefits are available.
 
To view a summary of benefits, benefit premium rates, and/or the AFSCME contract click the respective link. Click here to view information about Total Worker Health.
 

01
The supplemental questionnaire is scored and will be used to determine if you will proceed to the next phase of the selection process. Provide detailed answers to each question. Please do not reference your resume or application in your responses. I understand
  • Yes
  • No
02
Do you have an equivalent to an Associate degree?
  • Yes
  • No
03
Do you have four years of progressively responsible paraprofessional experience in the program or operational area or a related field, including at least two years of experience at the paraprofessional journey-level.
  • Yes
  • No
04
Please describe why you want to work as a Data and Reports Specialist for the Crime Analysis Unit, please highlight any specific skills or traits you believe make you uniquely qualified for the position.
05
Describe a complex statistical report you have created for either an internal or external customer. Include the nature of the report, the types of databases involved, the tools or software used to generate the report, and the final format in which the data was delivered to the customer. Describe your experience automating this process for a recurring report.
06
Provide an example from your previous work experience when it has been necessary for you to multitask. Explain the duties performed, how your work was prioritized, and how you handled completing multiple tasks at the same time.
07
Describe your training, knowledge, and experience with specific computer programs and databases, including a summary of tasks performed with each system. Highlight any specific experience with Microsoft SQL Server Management Studio, Python, JavaScript, and Excel.
08
Describe your experience creating heat or point density maps using geographic data contained within databases. Additionally, describe any experience creating reports from data which is geo-coded (lat/long or x/y): specifically pulling data from within a specified geo-spatial boundary while excluding or filtering all other data.
09
The job duties for this position require a background check. As an adult, have you ever been convicted for an offense other than a minor traffic violation?
  • Yes
  • No
10
If you answered "yes" to the previous question, complete this question. List the date(s) of the conviction(s), the location(s) the offense(s) occurred, and describe the nature of the offense(s). PLEASE NOTE: A previous conviction does not automatically disqualify an applicant from consideration for employment with the City of Eugene. Depending on a variety of factors (for example, the nature of the position, the nature of the conviction, age of the candidate when the illegal activity occurred), a candidate with a conviction may still be eligible for employment with the City of Eugene. This information is only considered at the appropriate time in the hiring process and candidates will be given the opportunity to discuss this information as appropriate.

Required Question

Agency
City of Eugene
Address
City of Eugene, Employee Resource Center
100 W. 10th Ave. Ste. 400
Eugene, Oregon, 97401
Phone
(541) 682-5061