Microsoft Data Analyst Jobs in Oregon (NOW HIRING)

The District Attorney's Office isseekinga 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'sOffice-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, andmaintaina 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.
Identifyand 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 toidentifyemerging patterns, geographic hotspots, and shifts insocioeconomicconditionsandcriminal 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 toprepare summary reports, tables, charts, maps, and timelines tied to external crime trendsandsocioeconomic conditions.
Create handouts and presentation materials for internal teams and external public safety partners.
Use critical thinking and analytical skills to translateinternal andexternal data into compelling visual formats using Microsoft tools,Tableau, ArcGIS, and other graphic design software applications.
Develop andmaintaina system for aiding in data-driven prosecutions of high-frequencyoffenders.
Collaboration with External Public Safety Partners
Work extensively with law enforcement agencies, courts, community corrections, juvenile departments, statewide crime reporting programs, and otherpartnerson data collectionandstandardization.
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.

IdealKnowledge, 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).

• Intermediateconcepts of qualitative and quantitative analysis.

• Standard office practices and business software (Microsoft Excel, Word).

• IntermediateGIS mapping concepts andothercommon data visualization tools.

Skillsto:

• 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 ofgeospatialandtemporalanalyticalconcepts and apply standard methods and tools withminimalguidance.

• 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 productsandreporting to key stakeholders andthe publicunder the guidance of higher-level analysts.

• Maintain confidentiality and adhere to security protocols.

• Work cooperatively with diverse teams and incorporate feedbacktoimprove performance.

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 publicor 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 Degreein 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 obtainCriminal Justice Information Services (CJIS)certification within 30 days of employment.

Aboutthe 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 andtimelyprosecution 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, andprovidethe data-driven insights necessary for effective prosecution and resource planning.