EDP Systems and Programming Analyst I/II

County of Santa Barbara; California (MO); On-site; USD 100,000 - 126,000; Full time

Job summary

The County of Santa Barbara is seeking an EDP Systems and Programming Analyst I/II to design or modify, and monitor computer application systems, assist users with issues, write reports, and manage automated jobs.

Ideal candidates have experience with SQL databases, dashboards, Power BI, and Tableau; strong data analysis skills; and the ability to work across platforms, with proficiency in C#, Java, Groovy or Visual Basic.

Qualifications

• Experience in supporting Microsoft SQL databases and writing queries.
• Experience with dashboards and Power BI data analysis.
• Knowledge of Tableau dashboard creation.
• Strong data collection and analysis methods.
• Experience modifying stored procedures and maintenance plans; SQL queries.
• Ability to work across databases, cloud apps, and system integrations.
• Proficiency in C#, Java, Groovy and Visual Basic.
• Experience in service ticket management.
• Strong verbal and written communication skills.
• Experience with EHR or Case Management system administration.

Responsibilities

• Design or modify and monitor computer application systems under supervision.
• Assist system users with resolution of application problems.
• Write reports and manage automated jobs; update server information.
• Perform related duties as required.

Skills

Strong communication

Team player

Customer service experience

Tools

Microsoft SQL

Power BI

Tableau

C#

Java

Apache Groovy

Visual Basic

Job description

Description

SALARY: EDP Systems and Programming Analyst I: $100,518.08 - $121,012.32 Annually ; plus bilingual and uniform allowance when applicable. For benefits info click HERE.

SALARY: EDP Systems and Programming Analyst I - Restricted: $104,551.20 - $125,860.80 Annually; plus bilingual and uniform allowance when applicable. Restricted positions are regularly privy to the decisions or recommendations of County management affecting employer employee relations. These employees are in the confidential-unrepresented bargaining unit. For benefits info on restricted positions click HERE.

Note: Applicants from other public sector employers may qualify for retirement reciprocity and time and service credit towards an advanced vacation accrual rate.

Current Vacancies: The current vacancies are in the Public Defender’s Office and the Probation Department.

Future Vacancies: We are establishing one employment list to fill current and future Electronic Data Processing (EDP) Systems and Programming Analyst I/II vacancies in multiple departments and locations within the County of Santa Barbara. This job classification is utilized by 12 different departments within the County. Please make sure you select the departments and locations that you are willing to accept current and future employment.

If you are interested in working with the Sheriff’s Office, Public Defender’s Office or the Probation Department, you will need to select “All Locations” on the agency-wide and supplemental questionnaire.

Each EDP Systems and Programming Analyst I/II's duties vary from one department to another depending on the needs of the department and the nature of the work that you will be performing.

THE POSITION

Under close supervision, the Electronic Data Processing (EDP) Systems and Programming Analyst I/II designs or modifies, and monitors computer application systems; assists system users with the resolution of computer application problems; writes reports and manages automated jobs; updates information on servers; and performs related duties as required.

DISTINGUISHING CHARACTERISTICS

EDP Systems and Programming Analyst I/II is a flexibly staffed class series. Positions in these classes perform applications analysis work of existing or new systems including programming, testing, maintenance, and implementation. This series differs from the Departmental Data Processing Specialist series in that the Analyst series focuses on the technical design, writing and testing of complex computer programs. Incumbents may specialize in computerized applications used in a particular type of service/program; e.g., criminal records, medical billing, inventory, financial, or personnel systems.

Employees may be hired at either the I or II level of the series. The I level is the entry level of the systems and programming analyst series, occupied by employees who require close supervision while acquiring great technical knowledge and ability to work with clients in needs and feasibility applications analysis. Employees at the II level work from general instruction and consult supervisors for guidance on policy matters and assist in the resolution of difficult technical problems. Employees are expected to gain the knowledge and ability needed to perform at the II level within two years.

IDEAL CANDIDATE

• Experience in supporting Microsoft SQL database management systems for a department.
• Knowledge of dashboard and Microsoft Power BI data analysis tool.
• Knowledge of Tableau tools and dashboard creation experience.
• Strong understanding of data collection and analysis methods.
• Experience modifying stored procedures, maintenance plans, and developing SQL queries.
• Ability to work across various platforms such as databases, cloud applications, and system integrations.
• Experience with writing software in C#, Java, Apache Groovy and Visual Basic.
• Experience in service ticket management.
• Experience in both verbal and written customer service communication.
• Experience with Electronic Health Record (EHR) or Case Management system administration.
• Ability to work well independently and as part of a team, making positive contributions and assisting others as necessary.
• Ability to validate and interpret data and deliver results and report substantiate trends and/or forecasts.
• Ability to understand, process, interpret, communicate and relate technical information to stakeholders, vendors, end users, and those who may have limited technical understanding.
• Strong verbal and written communication skills and experience working with end users.
• Ability to effectively manage multiple situations occurring simultaneously.
• Ability to prepare and write clear and concise reports, and keep records organized accordingly.
• Ability to identify areas of improvement is existing processes and implement new automation solutions.
• Strong critical thinking skills and the ability to solve complex problems.
• Knowledge and experience in resolving technical issues, user inquiries, diagnosing and troubleshooting technical issues.