Data Analyst

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. This role is primarily remote but onsite work/all staff meetings in Santa Barbara, CA is required when needed (lodging/travel expenses are not included). Employees of the County must reside in California. 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 here.

1. Collects, compiles, processes, analyzes, and interprets data from various sources.
2. 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.
3. Creates and implements dashboards, charts, graphs, tables, infographics, and other data displays.
4. Maintains data quality by creating and implementing data cleansing processes; performs routine maintenance procedures; troubleshoots problems; reindexes and updates data.
5. Identifies and interprets data trends and patterns as they relate to the organization.
6. Researches, designs, and configures databases and data systems; researches emerging database and data system technologies; tests new and upgraded systems.
7. 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.
8. Designs and implements backup and recovery plans; tests backup plans and performs database restores as needed.
9. Analyzes collected data and transforms it into a format that others can easily interpret.
10. Prepares technical, administrative, and other reports for organizational leadership to use in a business setting.
11. 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.
12. Stays current with emerging technologies and trends in the field of data analysis.
13. Ensures compliance with laws and ordinances pertaining to data security, computer systems, applications, and associated infrastructure operations and activities.
14. 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.
15. Researches and prepares technical and administrative reports; prepares written correspondence.
16. Builds and maintains positive working relationships with co-workers, other District employees, and the public using principles of good customer service.
17. Performs related duties as assigned.

1. 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,
2. 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.

Selection Process

1. Review Application to determine applicants that meet the employment standards.
2. 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.