Systems Project Analyst - Sheriff's Office (Non Sworn)

$38.84 - $49.64 hourly
  • Clackamas County
  • Oregon City, OR, USA
  • Sep 23, 2020
Full time Government Information Technology

Job Description

This position will remain open until filledThe first application review will be October 5, 2020.  We reserve the right to close this recruitment at any time on or after that date.



Annual Pay Range:  $80,802 - $103,257

Hourly Pay Range:     $38.84 - $49.64

Starting salaries will be within the posted pay range based on job-related factors such as experience, training and/or education.



In addition to competitive wages, Clackamas County offers an attractive benefits package for employees in regular status positions.

This is a full time County position represented by the Peace Officers Association.

Peace Officers Association (POA) Full Time Benefits

Learn More About Benefits



The Clackamas County Sheriff's Office seeks an experienced IT professional to join the Clackamas County Sheriff's Office.

This position will conduct professional level work in the analysis, design, enhancement, and implementation of broad and complex application systems; prepare specifications and procedures; create and maintain complex database systems, perform programming, testing, installation, and maintenance of new or modified applications; generate reports and gather data; create interactive dashboards, and do other work as needs arise.

This is a unique position requiring a high level of confidentiality, initiative, and versatility, with the ability to meet the technological needs of one of Oregon's largest and most dynamic criminal justice agencies.


This is a NON-SWORN position that requires a complete Statement of Personal History (SPH).  

Only those applicants who are invited to the department interview for this position will need to submit the SPH.  The SPH is due 10 calendar days AFTER you have been notified that you are being referred for a department interview.

Applicants who are invited to a department interview will receive instructions from the Department of Human Resources or the Sheriff’s Office on how to login to the electronic SPH. (The Sheriff’s Office no longer accepts hard copies of the SPH.)

Required Minimum Qualifications/ Transferrable Skills:*

  • At least three (3) years’ work experience installing, configuring, and maintaining Microsoft SQL database technologies including MSSQL, SSRS, SSIS, and T-SQL.
  • At least three (3) years’ work experience creating custom and ad-hoc reports from various data sources
  • At least three (3) years’ work experience developing and maintaining an internal data warehouse.
  • Strong knowledge of the SQL database languages (MSSQL, TSQL)
  • Ability to communicate well both verbally and in writing.
  • Experience scoping projects including meeting with users and gathering needs and creating timelines.
  • Proven ability and experience demonstrating technical writing skills.
  • Experience handling confidential, time sensitive information.
  • Must pass a post-offer, pre-employment drug test
  • Must pass an extensive background investigation, including national fingerprint records check
  • Driving is required for County business on a regular basis or to accomplish work. Incumbents must possess a valid driver's license, and possess and maintain an acceptable driving record throughout the course of employment.  Learn more about the County's driving policy

Preferred Special Qualifications/ Transferrable Skills:*

  • Experience implementing and using Microsoft PowerBI to create custom and interactive dashboards. 
  • Demonstrated experience creating highly-available SQL installations using Microsoft Clustering, Database Availability Groups, or other methodologies.
  • Experience upgrading, migrating, and transitioning end of life SQL processes and installations to modern platforms. 
  • Experience designing and building various performance reports for Law Enforcement Command Staff (COMPSTAT).
  • Practical experience with AS/400, IBM DB2, IBM System I Navigator and Visual Studio.
  • Knowledge of law enforcement terminology.

Other Qualifications:

  • Possession of a Law Enforcement Data System (LEDS) Certification is required within 3 months of employment.

*For Veterans qualified for Veteran’s Preference:  If you believe you have skills that would transfer well to this position and/or special qualifications that relate to this position, please list those skills and/or qualifications in the open-ended question at the end of the application and explain how those skills and/or qualifications relate to this position.


Duties may include but are not limited to the following:

  1. Coordinates the work of a project team composed of staff, vendors and users; guides and formulates project needs and requirements; manages and completes projects within specific time and budget constraints; prepares progress reports and revises projections to reflect current status.
  2. Confers with users and departments to analyze current and projected data information needs, resources and system performance; conducts research of new systems and modifications; conducts compatibility studies and cost/benefit analyses and recommends the most cost-effective approach to meet computer system requirements.
  3. Coordinates the planning of projects related to existing or proposed systems; prepares estimates and tracks project time and costs; establishes a work plan in relation to the capacity and limitations of computer hardware, operating time and available personnel; assigns projects or sections of projects to project staff.
  4. Develops detailed design specifications, definitions, flow charts, diagrams, performance criteria, and testing methods; writes; develops, and documents operational procedures for data elements and sources; coordinates systems maintenance, testing, and production runs; devises schedules for implementation; provides training and technical guidance to users and staff in the use of new or modified systems and procedures.
  5. Utilizes appropriate software tools and techniques for systems analysis, logic design, applications programming and coding, data base management, computer operations, troubleshooting equipment problems, and maintaining operational integrity of the computer system.
  6. Researches changes, trends and technologies related to computer systems.


Thorough Knowledge of: Principles and practices of applications programming, data communications and systems analysis and design; computer hardware and systems software in supporting application systems; data base management principles and techniques; operational characteristics of computer hardware and software.

Working Knowledge of: Basic principles and techniques of supervision and training; methods of project planning and management; cost/benefit analysis, research methods and report preparation.

Skill to: Communicate effectively, both orally and in writing; convey technical and complex information to users and management; design and analyze advanced systems; collect, analyze, evaluate, and prepare recommendations regarding system performance, user needs and requirements; establish controls and security measures; develop and manage projects within established timelines and budget requirements; plan and coordinate assigned staff to achieve project requirements and objectives; establish and maintain effective working relationships with system users, vendors, co-workers, other County personnel and outside agencies; perform mathematical and statistical computations.


This position works 40 hours during a standard workweek of Monday through Friday. Specific hours of work will be discussed with the candidate selected for this position at the time an offer of employment is extended.


Clackamas County is in a prime location in the Portland, Oregon metropolitan area and is recognized nationally as one of the most livable areas in the United States. Located on the southern edge of the City of Portland and extending to the top of Mt. Hood, Clackamas County is part of a thriving region in the Northwest. It has a population of about 400,000 citizens.

Explore Clackamas County

Clackamas County Core Values

Working for Clackamas County

Recreation, Arts & Heritage

Equity, Diversity and Inclusion


The vision of the Clackamas County Sheriff's Office (CCSO) is to become a world-class Sheriff's Office. The CCSO mission is to preserve life, uphold the law, prevent crime, hold offenders accountable, and promote safety while finding innovative solutions and building partnerships with the community. CCSO will fulfill the mission of the Clackamas County Sheriff's Office through teamwork and partnerships, as reflected in the motto: "Working Together to Make a Difference." In order to fulfill the vision and complete the mission CCSO adheres to these core values:

HONESTY- We will be truthful in all we do and say, acting with character and principle and serving the community in an open, transparent and professional manner.

COURAGE- We will serve the community with compassion and commitment, lending our strength to those who are most vulnerable and unable to protect themselves.

JUSTICE- We will always be fair and impartial, enforcing the law without bias or favoritism. We will treat each person we meet with courtesy and honor their rights, beliefs and diversity.

The CCSO serves over 400,000 residents of the County with 385 employees. As the County's largest law enforcement agency the Sheriff's Office patrols the unincorporated areas of the county as well as several cities that have contracted with CCSO to provide law enforcement for them. The CCSO has many specialized units such as canine, motorcycle patrol, the dive team, Special Weapons and Tactics (SWAT), search and rescue, narcotics investigation (SIU), detectives and Corrections Emergency Response Team (CERT). The Sheriff's Office is also required by law to provide correctional facilities for the county and to offer support services to other agencies in the County, such as: the jail, special units and occasionally personnel resources.

The CCSO is committed to enhancing a diverse workforce through principles of active recruitment in the community, equal employment opportunity and positive human resource management. The Administration and staff of the Clackamas County Sheriff’s Office adopts a philosophy and practice that we recognize the full potential of all employees, treating all persons with respect, fairness and impartiality.

Learn more about the Clackamas County Sheriff's Office.


Clackamas County only accepts online applications.

Help With Your Application:

Application Process

Help with the Application

If you have any questions or issues you may contact the Department of Human Resources at 503-655-8459 or e-mail us.  Our office hours are Monday - Thursday 7:00 a.m. - 6:00 p.m. Pacific Time (closed on Fridays).


Request Veterans' Preference

Learn more about the County's Veterans' Preference


Clackamas County does not offer visa sponsorships. Within three days of hire, applicants will be required to complete an I-9 and confirm authorization to work in the United States.


Clackamas County is an Equal Opportunity Employer.  We value diversity, equity, and inclusion as essential elements that create and foster a welcoming workplace.  All qualified persons will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, political affiliation, disability or any other factor unrelated to the essential functions of the job.

If you wish to identify yourself as a qualified person with a disability under the Americans with Disabilities Act and would like to request an accommodation, please address the request to the Department of Human Resources prior to the recruitment close date.  You may request an accommodation during the online application process.