Public Safety Crime Analyst

Washington County; Hillsboro (OR); On-site; USD 91,000 - 110,000; Full time

Job summary

Washington County seeks a Crime Analyst for the District Attorney’s Office to analyze external data from police, state, and federal sources and to develop geospatial maps for community partners and prosecutions. The role emphasizes data collection, validation, and creating clear, data-driven visuals for public safety decisions.

The ideal candidate will have strong data skills, familiarity with GIS tools (ArcGIS, Tableau), and the ability to present findings using Microsoft Excel and related

Qualifications

• Knowledge of crime analysis, crime prevention, and public safety operations.
• Data collection, validation, and quality assurance.
• Confidentiality requirements (LED/SJIS).
• GIS mapping concepts and data visualization tools.

Responsibilities

• Collect, standardize, and maintain a data warehouse for external data sources.
• Identify and flag impacts to recurring reports from partner data changes.
• Quality checks on externally sourced data.
• Analyze external crime trends to identify hotspots and shifts.

Skills

Data analysis

GIS mapping

Tableau

ArcGIS

Excel

Education

Bachelor's Degree in public or business administration, statistics, accounting, or related field

Associate Degree in public or business administration, statistics, accounting, or related field

High School Diploma/GED

Tools

Tableau

ArcGIS

Microsoft Excel

Job description

Note: This job will be posted through 11:59 PM of the day prior to the end date listed.

Job Type
Regular

Pay Range
$90,615.36 - $110,120.04 Salary

Department
District Attorney

FLSA Exemption Status
Exempt

About The Opportunity

The District Attorney’s Office is seeking a detail-oriented, analytically strong Crime Analyst with a primary focus on analyzing internal data along with external data sources (Oregon Criminal Justice Commission, NIBRS, UCR, etc.). The Crime Analyst will work with external public safety partners and other criminal justice agencies collecting relevant data.

This role centers on collecting, standardizing, evaluating, and interpreting data originating from outside the DA’s Office—including police agencies, state and federal systems, public safety partners, specialty courts, community corrections data, and other justice-related external datasets. The Crime Analyst will use external data, along with internal data, to develop products and geospatial mapping for presentation to community members and public safety partners.

Key Responsibilities

External Crime & Public Safety Data Analysis

• Collect, standardize, clean, and maintain a data warehouse for external data sources relevant to crime and public safety, including police department data, OSP crime data, WCCCA, judicial data, community corrections, and federal crime datasets.
• Identify and flag impacts to recurring reports caused by changes in external partner reporting practices or statewide crime reporting standards.
• Conduct quality checks on externally sourced data before inclusion in DA reports.
• Analyze external crime trends to identify emerging patterns, geographic hotspots, and shifts in socioeconomic conditions and criminal activity across jurisdictions.

External Data Repository Management

• Input external datasets into the DA’s central data repository (data warehouse), focusing on standardization, cleaning, and ongoing maintenance.
• Document recurring external data issues or changes in partner data systems.
• Develop and apply external data validation procedures to ensure high-quality analytical outputs.

Reporting, Visualization & Presentation

• Using a variety of data sources to prepare summary reports, tables, charts, maps, and timelines tied to external crime trends and socioeconomic conditions.
• Create handouts and presentation materials for internal teams and external public safety partners.
• Use critical thinking and analytical skills to translate internal and external data into compelling visual formats using Microsoft tools, Tableau, ArcGIS, and other graphic design software applications.
• Develop and maintain a system for aiding in data-driven prosecutions of high-frequency offenders.

Collaboration with External Public Safety Partners

• Work extensively with law enforcement agencies, courts, community corrections, juvenile departments, statewide crime reporting programs, and other partners on data collection and standardization.
• Provide technical consultation on external data trends, projections, and implications for public safety operations.
• Prepare technical responses to external information requests, including public records inquiries.

Ideal Knowledge, Skills, And Abilities (KSAs)

Knowledge of:

• Principles of crime analysis, crime prevention, and public safety operations.
• Fundamentals of data collection, validation, and quality assurance.
• Applicable laws, regulations, and confidentiality requirements (e.g., LEDS/CJIS).
• Intermediate concepts of qualitative and quantitative analysis.
• Standard office practices and business software (Microsoft Excel, Word).
• Intermediate GIS mapping concepts and other common data visualization tools.

Skills to:

• Managing multiple tasks and deadlines in a fast-paced, high volume work environment.
• Remainingorganized, composed, andaccurateunder pressure and shifting priorities.
• Communicate clearly and effectively in orally and in writing to convey information to others.
• Apply critical thinking and problem-solving skills toidentifyissues, evaluate information, and provideappropriate recommendationsor solutions.
• Apply strong attention to detail and accuracy when handling sensitive data.
• Follow established procedures and meet deadlines under supervision.

Ability to:

• Demonstrate knowledge of geospatial and temporal analytical concepts and apply standard methods and tools with minimal guidance.
• Prioritize tasks effectively whilemaintainingattention to detail.
• Collect, organize,validate, andmaintaindata from multiple sources.
• Prepare routine reports, maps, dashboards, and visualizations.
• Assistwith data preparation for prosecutorial products and reporting to key stakeholders and the public under the guidance of higher-level analysts.
• Maintain confidentiality and adhere to security protocols.
• Work cooperatively with diverse teams and incorporate feedback to improve performance.

Preferred Qualifications

• Intermediate knowledge of criminal justice system operations
• Background in data analytics and/or geographic information systems
• Ability to write queries or scripts in one or more syntax

To review the complete classification, including the full list of knowledge, skills, and abilities (KSAs) associated with this position, use this link: https://www.washingtoncountyor.gov/hr/job-class/27

Minimum Qualifications

• Bachelor's Degree in public or business administration, statistics, accounting, or a related field that provides the required knowledge, skills, and abilities; AND two (2) years of progressively responsible professional experience in administrative, operations, or similar analyses. OR
• Associate Degree in public or business administration, statistics, accounting, or a related field that provides the required knowledge, skills, and abilities; AND four (4) years of progressively responsible professional experience in administrative, operations, or similar analyses. OR
• High School Diploma/GED; AND six (6) years of progressively responsible work experience in administrative, operations, budgetary, and similar analyses, of which at least two (2) years of this experience is in the public sector for a medium or large governmental unit.

Additional Requirements

• Background Check
• Must obtain Criminal Justice Information Services (CJIS) certification within 30 days of employment.

About The Department/Division

The Washington County District Attorney’s Office serves one of Oregon’s most fast-growing communities. The office is committed to ensuring public safety, delivering justice with integrity, and supporting victims through fair and timely prosecution of criminal offenses. The DA’s Office works closely with local police departments, regional law enforcement partners, county agencies, state courts, community corrections, and statewide criminal justice organizations to strengthen community safety.

With increasing volumes of digital information and expanding interagency data needs, the office relies on skilled analysts to help interpret external crime trends, support collaborative public safety initiatives, and provide the data-driven insights necessary for effective prosecution and resource planning.

Selection Process

You can review our standard selection process here.

Our Commitment To You

Washington County is an equal opportunity employer committed to using a merit-based system in which recruiting, selecting, and advancing employees is based on knowledge, skills, and abilities. Our organization embraces innovation, collaboration, and work-life harmony. We promote employee development and offer an award-winning benefits and wellness program as well as an opportunity to serve and support our vibrant community.

Veterans' Preference

If you are a Veteran and would like to be considered for Veterans' preference for this recruitment, please review the instructions using this link: Veterans' Preference Points.

Accommodation Under The Americans With Disabilities Act

Reasonable accommodation is available to anyone whose specific disability prevents them from completing this application or participating in the selection process for this recruitment. To obtain confidential assistance please contact Human Resources 503-846-8606, or email: [e-mail] at least 48 hours before any step in the recruitment and selection process for which you feel you need accommodation.

Notice

Washington County is currently undergoing a comprehensive classification and compensation study. The purpose of this project is to create new job descriptions and create new classification and compensation systems. Outcomes of the project will include changes to classification titles, which could impact compensation structures. No one will have their pay rate lowered because of this project. For represented positions, appropriate bargaining processes will be utilized prior to implementation.

Questions?

Recruiter
Brighton Bohnenkamp

Email Address
[e-mail]