Data Analyst

Salary: See Position Description
Location : County of Santa Barbara - All locations, CA
Job Type: Full-time
Job Number: 25-2550-03 (O/IT)
Department: Information Technology
Opening Date: 03/18/2025
Closing Date: 4/1/2025 5:00 PM Pacific

Description

This is an excellent opportunity to begin a rewarding and reliable career with the Information Technology Department at the County of Santa Barbara. Come and be a part of a team of talented individuals who are passionate about fostering a culture of teamwork, learning and respect!

In the IT Department our success is powered by people and technology. Our culture is what makes IT a fun and rewarding place to work! We establish, develop and nurture partnerships and open communication within our communities. We embrace a willingness to learn and accept new ideas, to actively listen and to be receptive to change. We strive to grow our talents and do our best in the service of others while taking pride in our work. We explore and deliver new and creative ways to pair technology with business needs. We ensure the resources necessary to succeed and encourage thoughtful participation leading to inclusion and ownership.

Compensation: the payroll title for this job classification is EDP Systems and Programming Analyst
EDP Systems and Programming Analyst I: $95,209.92 - $114,622.56 annually.
EDP Systems and Programming Analyst II: $104,436.80 - $125,881.60 annually.

NOTE: Candidates may be appointed at the I or II level, depending on the candidate's qualifications and the needs of the department.

The Position
Under general supervision, this role involves conducting professional data analysis from various sources. Responsibilities include extracting, transforming, and loading data to prepare it for use, writing queries to obtain necessary data, and generating insightful reports. The position requires designing engaging displays such as dashboards, charts, graphs, and infographics to facilitate understanding of the data. Additionally, it involves creating automated routines to streamline data collection and interpretation, as well as implementing and testing backup and recovery plans to protect the integrity of the data. Related duties may also be assigned as needed.

We are currently recruiting to fill one full time vacancy. Remote work is permitted but onsite work in Santa Barbara, CA is required when needed (typically 2-5 times per year; lodging/travel expenses are not provided). Employees of the County must reside in California. At this time, this position is not eligible for visa sponsorship. Applicants must have permanent work authorization to work in the United States without the need for visa sponsorship by the start date of employment. The payroll title for this role is EDP Systems and Programming Analyst.

Highlighted Benefits:

• Primarily remote schedule
• Health Plan: County contributes towards premium; HSA offered
• Pension Retirement
• Reciprocity with other public sector retirement systems (like CalPERS)
• 13 holidays, 12 sick leave days (unlimited accumulation), and 12 to 25 days of vacation (based on length of service) per year
• Time and service credit towards an advanced vacation accrual rate for previous public service.
• For more information on County benefits, please click

Examples of Duties

Collects, compiles, processes, analyzes, and interprets data from various sources.

Designs, administers, updates, and implements data query, extraction, translation, interface, and loading scripts; creates easy-to-use automated routines to streamline data collection and extraction.

Creates and implements dashboards, charts, graphs, tables, infographics, and other data displays.

Maintains data quality by creating and implementing data cleansing processes; performs routine maintenance procedures; troubleshoots problems; reindexes and updates data.

Identifies and interprets data trends and patterns as they relate to the organization.

Researches, designs, and configures databases and data systems; researches emerging database and data system technologies; tests new and upgraded systems.

Administers, operates, maintains, and upgrades existing databases and data systems; checks for database consistency and addresses errors; monitors performance. Creates and manages tables, indexes, and related systems and processes.

Designs and implements backup and recovery plans; tests backup plans and performs database restores as needed.

Analyzes collected data and transforms it into a format that others can easily interpret.

Prepares technical, administrative, and other reports for organizational leadership to use in a business setting.

Collaborates with other employees, including engineers and programmers, to determine areas of improvement in relation to data; recommends and administers collaborative solutions; implements integrations and interfaces between data systems.

Stays current with emerging technologies and trends in the field of data analysis.

Ensures compliance with laws and ordinances pertaining to data security, computer systems, applications, and associated infrastructure operations and activities.

Within assigned areas of accountability, represents the department to outside agencies and organizations; participates in outside community and professional groups and committees; provides technical assistance as necessary.

Researches and prepares technical and administrative reports; prepares written correspondence.

Builds and maintains positive working relationships with co-workers, other District employees, and the public using principles of good customer service.

Performs related duties as assigned.

Employment Standards

Completion of 24 quarter/18 semester units of college level courses in the principles and methods of systems analysis, systems design, computer program design, computer programming using a language utilized by the hiring department, and information system technology, and two years of experience writing business application programs; or,

A combination of training, education, and experience that is equivalent to one of the employment standards listed above and that provides the required knowledge and abilities.

Knowledge of: principles and methods used in analysis and development of data processing applications; principles of systems and procedures analysis; uses and limitations of data processing applications; principles of information entry, storage, and retrieval; programming languages applicable to systems in use; current developments in data processing; operating capabilities of common hardware configurations; principles and techniques of computer programming; basic math to develop simple equations in programming applications and to estimate costs of systems; and basic principles of electronic data communication.

Ability to: define problems, collect and analyze data, validate conclusions, and make recommendations; modify and write programs for efficient applications; write instructions and procedures; write systems and programming documentation; prepare clear and concise memos and written reports; identify and take corrective actions to solve problems in programs and production systems; communicate on technical issues with individuals with varying degrees of computer familiarity; apply advanced programming languages and programming tools; establish and maintain effective working relationships with users and others contacted in the course of work; read and interpret technical instructions used for such tasks as coding and operating systems; organize work and set priorities to meet deadlines; work within prescribed time constraints.

Additional Qualifications: Employment in this job classification requires successful completion of a background investigation, may require the possession of a valid California Class C Driver's License and the availability to work off hours on occasion for emergencies.
For work related issues, the incumbent may need to travel throughout the County regardless of the assigned location.
Supplemental Information

Selection Process

Review Application to determine applicants that meet the employment standards.

Supplemental Questionnaire Ranking: Applicants who meet the employment standard will have their responses to the supplemental questionnaires evaluated and scored. Candidates' final score and rank on the eligibility list will be determined by the scored supplemental questions. This process may be eliminated if there are fewer than 11 qualified candidates.

Candidates must receive a percentage score of at least 70 on the Supplemental Questionnaire Ranking to be placed on an employment list. An adjustment may be made to raw scores based on factors listed in Civil Service Rule VI. Those candidates who are successful in the selection process will have their names placed on the employment list for a minimum of three months. At the time the employment list is established, all candidates will receive written notice of their score on the exam(s), rank on the employment list, and exact duration of the employment list.

Completion of a 12-month probationary period is required.

Conditional Job Offer: Once a conditional offer of employment has been made, candidate will be required to successfully complete a background check, which includes a conviction history check, LiveScan fingerprinting, satisfactory reference checks, as well as a post-offer medical evaluation or examination.

REASONABLE ACCOMMODATIONS: The County of Santa Barbara is committed to providing reasonable accommodation to applicants. Qualified individuals with disabilities who need reasonable accommodation during the application or selection process should contact the recruiter listed on the job posting. We require verification of needed accommodation from a professional source, such a Medical Provider or a learning institution.

Disaster Service Worker: Pursuant to Governmental Code section 3100, all employees with the County of Santa Barbara are declared to be disaster service workers subject to such disaster service. Activities as may be assigned to them by their superiors or by law.

Statement of Commitment
The County of Santa Barbara is dedicated to cultivating and sustaining an environment that exhibits equity and inclusion everywhere, and at all levels of our organization. The County believes equity is a fundamental principle that must be imbedded in policies, institutional practices and systems. The County recognizes the negative impacts of systemic racism and is committed to eliminating the barriers affecting Black, Latinx, Indigenous, Asian, and socioeconomically disadvantaged community members, as well as people of other diverse racial and ethnic backgrounds.

We envision a world where society and its systems (e.g. education, criminal justice, and health care, housing, the economy) are just, fair, and inclusive, enabling all people to participate and reach their full potential.

We celebrate community and employee diversity, strive for inclusion and belonging, and promote empowered participation. We aspire to build a workforce that is reflective of these values and the communities we serve. We are proud to be an equal opportunity employer and will resolutely uphold federal, California state law and/or Santa Barbara County ordinances.

We believe equity and inclusion are vital to fulfill the County's mission and to embody a culture of "One County, One Future." Expanding the full range of employee talent allows the County to deliver our best to all our community members.

We believe in the dignity and humanity of all people. We strive for a healthy and prosperous society that promotes all people having equitable access and opportunity.

APPLICATION DEADLINE: Tuesday, April 1, 2025, at 4:59 p.m. PST, postmarks not accepted. You can view job postings and apply online 24 hours a day at

Recruiters will correspond with applicants by email during each step of the recruitment process. Applicants are reminded to check spam filters continuously during the Selection Process steps to ensure they do not miss required deadlines.

For any questions, please contact Sabina Netto, ITD Human Resources Manager at
Retirement Plans

• Generous County Defined Benefit Plan
• Eligible to participate in 457(b) Deferred Compensation Plan
• Retirement Reciprocity with CalPERS, CalSTRS, and 1937 Act plans
• For more information on our retirement plans, please visit: and

Health Benefits

• Choice of dental, vision and medical plans. In addition to the Benefit Allowance noted above, the County contributes toward medical premiums and dental premiums
• On-Site Employee Health Clinics in Santa Barbara and Santa Maria which provide ongoing and episodic services to eligible employees and their eligible dependents
• Employee Assistance Program (EAP) offers free, confidential assistance with personal and workplace problems to employees and their immediate family members
• Healthcare Advocacy Program to help employees navigate the complexities of health plan benefits
• Available Health Care and Dependent Care Flexible Spending Accounts, Health Savings Account (HSA), Supplemental Term or Whole Life Insurance, Personal Accident Insurance, Critical Illness Insurance, Accident Insurance and more!
• For more information on our health benefits, please visit:

Paid Time Off

• Vacation Leave 12 to 25 days per year depending on length of public employment
• Sick Leave 12 days annually with unlimited accumulation, one year of which can be converted to service credit upon retirement
• Paid Holidays based on bargaining unit (view the compensation summary for this bargaining unit, link below)
• Alternative Transportation Benefit (TDM) up to 2 days of additional vacation for using alternative methods of commuting
• For more information on Paid Time Off please view the Compensation Summary for this bargaining unit (available below)

Miscellaneous Benefits

• County Paid Term Life Insurance
• County Paid Long Term Disability Insurance
• Childcare and Employee Discounts
• Relocation Assistance may apply
• Flexible work schedule may apply
• For more information on all of these benefits, please visit:

Compensation Summary

• To view the Compensation Summary specific to the bargaining unit for this position (link to full Memorandum of Understanding also available at bottom of the summary), please visit:

*This benefits list is for convenience only; please refer to the Memorandum of Understanding for complete details of terms and conditions. Amounts are generally prorated for part-time employment.
01

I acknowledge that it is my responsibility as an applicant to provide sufficient information on my application to demonstrate that my education and experience meets the employment standards (minimum qualifications) for this position as detailed in the job posting. I understand that resumes are not considered as part of the application review process so a thorough and detailed application and supplemental questionnaire are required and entering "see resume" is not acceptable.I further acknowledge that if the County determines that I do not meet the employment standards there will be no opportunity for me to provide additional information regarding my application after the closing date listed on the job posting.Therefore, I understand that before submitting a job application, it is important that I review the job posting thoroughly and ensure that my application clearly reflects how my education and experience meets the employment standards at the time I submit my application.

• I understand

02

The Human Resources Department communicates with all applicants through e-mail. Please make sure your email address is entered correctly, it is current, and that you check spam filters continuously during the recruitment and selection process to ensure you do not miss required deadlines.

• I understand

03

While this is a primarily remote role, I understand that County employees must reside in California and that when required to be in the office (in Santa Barbara, typically 2-5 times per year), employees are not provided lodging or travel expenses.

• I understand

04

At this time, this position is not eligible for visa sponsorship. Applicants must have permanent work authorization to work in the United States without the need for visa sponsorship by the start date of employment.

• I understand

05

The following questions will be evaluated by the hiring manager if your application meets the minimum employment standards and certified to the hiring department. Please note that grammar/syntax/etc. will be evaluated in addition to content of responses.

• I understand

06

Can you provide an example of a project where you collaborated with cross-functional teams (such as engineers, product managers, or other departments) to analyze data and drive insights? What was your role in the collaboration, how did you ensure effective communication, and what was the outcome of the project?
07

Do you have experience working for a for a public/government sector agency (county, city, school district, etc.)?

• Yes
• No

08

If you indicated that you do have experience working for a public/government sector agency, please list the agency/agencies below (enter N/A if not applicable). These employers must also be listed on your application.
09

I understand the Civil Service Examination for this recruitment is a Supplemental Questionnaire Ranking. I understand my responses to the following supplemental questions will be used as a weighed, scored selection device that will determine my ranking on the employment list for this position.For information on protest procedures for the Supplemental Questionnaire Ranking, please see Civil Service Rules 612 and 613: https://www.countyofsb.org/1444/Civil-Service-Rules

• I understand the following is an examination that will be used to determine my rank on the Eligible List.

10

For the following, please indicate your level of experience (Beginner, Intermediate, Advanced) for each area. Then, please provide the names of the employers/school courses where you gained this experience. This information is required if you indicate that you have experience. If responses are not included or incomplete, your application may be disqualified. Please note that follow up skills assessments may be administered to validate responses.

• I understand

11

Data Analysis and Interpretation

• Beginner: Can perform basic data analysis and recognize simple patterns.
• Intermediate: Able to analyze complex datasets and draw meaningful conclusions.
• Advanced: Expert in advanced analytical techniques and can identify nuanced trends across multiple data sources.
• I do not have experience or training in the above area.

12

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
13

Data Query and Script Development

• Beginner: Familiar with basic querying and scripting concepts.
• Intermediate: Proficient in writing and managing queries and scripts for data extraction and transformation.
• Advanced: Highly skilled in optimizing and automating complex queries and scripts for efficiency.
• I do not have experience or training in the above area.

14

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
15

Data Visualization

• Beginner: Can create simple charts and graphs to display data.
• Intermediate: Proficient in designing engaging dashboards and infographics for effective data presentation using data visualization tools such as Tableau, PowerBI, MicroStrategy, etc.
• Advanced: Expert in using advanced visualization tools and techniques to tell compelling data stories.
• I do not have experience or training in the above area.

16

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
17

Data Quality Maintenance

• Beginner: Understands basic data quality concepts and performs simple cleansing tasks.
• Intermediate: Skilled in implementing and maintaining data cleansing processes and troubleshooting issues.
• Advanced: Expert in developing comprehensive data quality frameworks and best practices.
• I do not have experience or training in the above area.

18

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
19

Data Acquisition

• Beginner: Understands basic scripting and programming to acquire data from other databases.
• Intermediate: Skilled in advanced scripting and/or programming techniques required to acquire data from complex data sources. Also has the ability to automate and troubleshoot these data feeds.
• Advanced: Expert in developing and documenting comprehensive data acquisition processes, frameworks and best practices.
• I do not have experience or training in the above area.

20

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
21

Trend and Pattern Recognition

• Beginner: Can identify basic trends and patterns in data.
• Intermediate: Able to analyze data trends and make data-driven recommendations.
• Advanced: Expert in predictive analytics and trend forecasting across diverse datasets.
• I do not have experience or training in the above area.

22

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
23

Database Design and Management

• Beginner: Familiar with database concepts and can assist with basic management and design tasks.
• Intermediate: Proficient in designing and managing databases, including routine maintenance.
• Advanced: Expert in advanced database design, architecture, and optimization techniques.
• I do not have experience or training in the above area.

24

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
25

Backup and Recovery Implementation

• Beginner: Understands the importance of backups and can follow basic backup and restore procedures.
• Intermediate: Able to implement and test backup and recovery plans effectively.
• Advanced: Expert in designing comprehensive backup strategies and disaster recovery solutions.
• I do not have experience or training in the above area.

26

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
27

Reporting and Documentation

• Beginner: Can prepare simple reports based on simple datasets. Can document existing processes and procedures as needed.
• Intermediate: Skilled in creating complex reports based on multiple datasets. Can document new and existing processes and procedures.
• Advanced: Expert in developing complex reports from multiple datasets that are used by stakeholders with varying knowledge of data.
• I do not have experience or training in the above area.

28

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
29

Collaboration and Communication

• Beginner: Can communicate basic data findings to team members.
• Intermediate: Proficient in collaborating with cross-functional teams and stakeholders to drive data initiatives. Able to communicate with people of varying technical knowledge.
• Advanced: Expert in leading discussions, workshops, and presentations to effectively communicate complex data insights to or solicit data requirements from users with varying levels of technical knowledge.
• I do not have experience or training in the above area.

30

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
31

Data Security Compliance

• Beginner: Understands basic data security principles and compliance requirements.
• Intermediate: Proficient in implementing security measures such as role-based access to protect data integrity.
• Advanced: Expert in developing comprehensive data security policies and ensuring compliance with industry standards.
• I do not have experience or training in the above area.

32

Please list the employers/school courses where you gained this experience. Any employers listed here must also be listed in the employment experience section of the application. Please enter N/A if you indicated that you do not have experience in this area. (Not scored, used to validate response.)
Required Question