Data Analytics Specialist

Orange County, CA
September 10, 2021
Orange County, CA
Job Type



In addition to performance-based merit increases, this position is scheduled to receive salary range increases on the following dates:
Effective July 1, 2022 - 3.5% increase

Salary may be negotiable within the range listed above, based on position requirements and successful candidate's qualifications, subject to appropriate authorization.

The recruitment will establish an open eligible list and will be used to fill current and future Staff Specialist positions within OC Animal Care. The eligible list established may also be used to fill similar and lower-level classifications throughout the County of Orange.

This recruitment will remain open on a continuous basis for a minimum of five (5) business days, until the needs of the County are met. Qualified applicants are encouraged to apply immediately, as the deadline to apply for the first round of consideration is Wednesday, September 22, 2021 .

OC Community Resources is a multi-faceted department comprised of OC Animal Care, OC Community Services, OC Housing & Homeless Services, OC Parks, and OC Public Libraries.

OC Animal Care promotes responsible pet ownership, health and safety of people and animals, and spay/neuter programs. OC Animal Care provides temporary shelter and medical care for "lost" owned or stray animals and opportunities for adoption of these animals.

The Data Analytics Specialist duties include, but are not limited to, the following:

  • Provide statistics and/or conduct statistical analysis regarding OC Animal Care's operational data or other data as requested
  • Create and edit Crystal Reports for the animal shelter software program Chameleon, in order to meet operational needs
  • Conduct workflow analysis to ensure consistent inputting practices and identify areas of improvement
  • Regularly audit existing reporting tools to ensure reports are accurate and consistent with current inputting practices
  • Perform quality assurance actions, developing error reports and schedules as necessary
  • Present work product verbally, in writing, and/or with the use of visual aids to management and stakeholders as needed

Work Schedule: The standard work schedule for this assignment would consist of day shifts during the week on schedule consisting of four (4) to five (5) days per week, depending on the department's needs. However, OC Animal Care provides service 24 hours per day, 365 days per year. Incumbents should be prepared to occasionally work other shifts as necessary, if needed by the department.

The ideal candidate will possess three (3)+ or more years of work experience conducting complex data, statistical, or workflow analysis. An undergraduate degree or higher, in a related discipline, such as computer science, mathematics, statistics, or any quantitative discipline or focused area of study, may substitute for this experience.

The ideal candidate will also possess experience writing, editing, and creating Crystal Reports using SQL coding language, or experience writing, editing, and creating reports with similar business intelligence software applications.

In addition, the ideal candidate will demonstrate extensive knowledge and/or related experience in the following core competencies:

Technical Expertise

  • Creating Crystal Reports utilizing SQL coding language, or creating reports with a similar business intelligence software application
  • Gathering and manipulating data, and connecting it to operational concepts
  • Demonstrating expert level skills in Microsoft Excel including working with large data sets, charting, graphing, filtering, sorting and formatting data, as well as the use of functions
  • Working knowledge of relational database concepts
  • Demonstrating intermediate to advanced skills in Microsoft Word and PowerPoint
  • Performing statistical analysis compiling data from a variety of sources

Critical Thinking

  • Applying the correct mathematical concept to engage problems and develop solutions
  • Thinking logically and organizing thoughts and work priorities to accomplish work efficiently
  • Gathering, analyzing and applying information skillfully
  • Conducting research, critically analyzing data, and presenting complex data or ideas to a variety of audiences

Interpersonal Communication | Relationship Building

  • Demonstrating skill and ability to work cooperatively with internal and external stakeholders
  • Coordinating with others in response to multiple, competing demands to ensure work is completed in a timely manner
  • Liaising with organizations and individuals on achieving common goals

Oral & Written Communication

  • Demonstrating effective verbal and written communication
  • Preparing and conducting presentations clearly and effectively
  • Following written and oral instruction effectively
  • Interpreting and applying oral and written instructions
  • Listening actively to others for full understanding of what is being communicated
  • Establishing and maintaining cooperative working relationships

Organization & Planning

  • Coordinating with others in response to multiple, competing demands to ensure work is completed in a timely manner
  • Maintaining a high level of energy and commitment to juggle multiple tasks and priorities, and using available resources to get more done with less; all without losing focus
  • Setting high standards for quality work and responsiveness in providing administrative services
  • Adjusting priorities to respond to pressing and changing demands

Minimum Qualifications
Click here for the complete classification description for Staff Specialist including the minimum qualifications.

Human Resource Services (HRS) screens all application materials for minimum and/or desirable qualifications. After screening, applicants who meet the minimum and/or desirable qualifications will be referred to the next step in the recruitment process. All applicants will be notified via email of their status in the process.

Office Skills Examination | (Weighted 100%)
Candidates will be invited to participate in a series of online examinations related to the essential job functions. Only the most successful candidates will be placed on the eligible list.

Based on the Department's needs, the recruitment procedures listed above may be modified. All candidates will be notified of any changes in the selection procedure.

Eligible List
Once the assessment has been completed, HRS will establish an eligible list of candidates. Candidates placed on the eligible list may be referred to a selection interview to be considered for present and future vacancies.

Veterans Employment Preference
The County is committed to providing a mechanism to give preferential consideration in the employment process to veterans and their eligible spouses and will provide eligible participants the opportunity to receive interviews in the selection process for employment and paid internship openings. Please click here to review the policy.

Email is the primary form of notification during the recruitment process. Please ensure your correct email address is included in our application and use only one email account.

NOTE: User accounts are established for one person only and should not be shared with another person. Multiple applications with multiple users may jeopardize your status in the recruitment process for any positions for which you apply.

Candidates will be notified regarding their status as the recruitment proceeds via email through the site. Please check your email folders, including spam/junk folders, and/or accept emails ending with "" and "" If your email address should change, please update your profile at .

Click here for additional Frequently Asked Questions.

For specific information pertaining to this recruitment, contact Vanessa Rosas at 714.480.2867 or

Orange County, as an equal employment opportunity employer, encourages applicants from diverse backgrounds to apply.

Closing Date/Time: Continuous

Drop files here browse files ...

Related Jobs

Data Analytics Specialist   Minneapolis, MN
September 7, 2021