The County of Sonoma Human Services Department is seeking a qualified candidate to fill ONE FULL-TIME position as Systems and Programming Analyst. The employment list established from this recruitment may be used to fill future Full-Time, Part-time, and Extra-Help vacancies as they occur during the active status of the list.
The Systems and Programming Analyst is a member of the 5-person Human Services Programming Team that collaboratively serves a Department of 800+ employees who provide a wide variety of programs and services to the community. The team is responsible for Application Development (web and client), Business Intelligence, Data Integration/Transformation Services, Database Administration, External Website Development/Maintenance, Intranet Development/Maintenance, and System Administration of all Programming Tools/Systems.
The Systems and Programming Analyst is a specialized, professional class, and is reserved for positions whose primary responsibilities emphasize combined business applications analysis, design, programming, database design and database administration work in a decentralized department that is not supported by central ISD programming staff. Incumbents in this class work with considerable independence on complex systems and programs and typically have overall responsibility for design and installation of one or more major systems, and are expected to be competent in all phases of applications programming, database design, database administration and analysis. An incumbent may provide work direction and training to other information systems staff. The ideal candidate will have experience with the following:
Object Oriented Programming (OOP)
C# (or similar object oriented language) ASP.NET, Microsoft Visual Studio
Application Development Lifecycle
Web Application Development
Enterprise Information Management/Data Governance, ie data integration, data quality, master data management, metadata management, data warehousing, enterprise data architecture, database administration.
SAP Business Objects Business Intelligence Suite
Microsoft SQL Server 2008 DBA The ideal candidate will also possess strong interpersonal, collaboration and team skills and be comfortable with multitasking and adapting to changing priorities. The ideal candidate will also be successful in staying current on a wide variety of technologies.
Please answer the mandatory supplemental questions at the end of this job announcement .
Civil Service Title: Human Services Systems & Programming Analyst
Any combination of education and experience which would provide the opportunity to acquire the knowledge and abilities listed. Normally, this would include:
Education: Completion of completion of 24 semester college units or 36 quarter units in computer science or information systems.
Experience: Three years of experience performing both systems analysis/design and programming for business applications, which entailed analysis and design of several systems.
License: Possession of a valid driver's license at the appropriate level including necessary special endorsements, as required by the State of California to perform the essential job functions of the position.
Knowledge, Skills, and Abilities:
Knowledge of: techniques used for finding and correcting problems in programs and systems; principles and methods of business applications programming; principles and methods used in analysis and application development; principles of systems and procedures analysis and documentation; uses and limitations of applications; programming languages applicable to system in use in operating department; current developments in applications development and database administration; operating capabilities of common hardware configurations; project management methods and techniques; database design, development, administration and management concepts and techniques; data mining, storage, and warehousing methods; state-of-the-art Internet technologies, methods, standards, and issues (e.g., security, privacy, accessibility); Internet services concepts and best practices; Internet services architecture.
Ability to: Define complex problem areas, collect and evaluate data, validate conclusions and make recommendations; develop complex systems for efficient operations; modify and write complex programs for efficient business applications; plan, coordinate and initiate actions necessary to implement recommendations; write instructions and procedures and prepare systems and programming documentation; establish and maintain cooperative working relationships with users and others contacted in the course of work; prepare clear and concise written reports; identify and take corrective actions to solve problems in programs and production systems; concentrate on many complex elements of a problem; investigate, evaluate, and select tools and methods for improving productivity and software quality; plan and manage the migration of databases to new technologies, such as the migration to client-server or Web-enabled databases; plan and oversee the installation or reinstallation process and coordinate with specialists in other functional areas to resolve connectivity, compatibility, reliability, security, and related issues.
The information contained in the application and responses to the supplemental questions will be evaluated and taken into consideration throughout the employment process. Applicants should list all employers and positions held within the last ten years in the work history section of your application and be as thorough as possible when responding to the supplemental questions. You may include history beyond ten years if related to the position for which you are applying. If you held multiple positions with one employer, please list each position separately. Failure to comply with these instructions may impact your competitiveness in this process or may result in disqualification.
For more detailed information about examination steps and the hiring process, you are encouraged to go to http://hr.sonoma-county.org/content.aspx?sid=1024&id=1464 and review the Hiring Process Overview.
Application submissions require the supplemental questionnaire be completed.
The selection procedure will consist of the following examination:
An Application & Supplemental Questionnaire Appraisal Examination (weight 100%) will be conducted to evaluate each applicant's application and supplemental questionnaire for satisfaction of minimum qualifications (pass/not pass), and for educational coursework, training, experience, knowledge, and abilities which relate to this position. Each applicant will be evaluated based on the following criteria:
Candidates demonstrating possession of the minimum qualifications will be placed on an employment list in order of most qualified to least qualified based on the achieved score received in the Application & Supplemental Questionnaire Appraisal Examination . Scores may be adjusted based on such factors as number of candidates, anticipated vacancies, past practice, and natural breaks in the scores achieved by this group of candidates.
- Relevance of work history, related experience, and achieved level of education and/or training as described in the application and responses to the supplemental questions.
A background investigation is required prior to employment. Candidates referred to departments for a selection interview are typically required to sign authorization and release forms enabling such an investigation. Failure to sign prescribed forms will result in the candidate not being considered further for that vacancy. Reference information will not be made available to applicants.
Additionally, a pre-employment medical examination, including a drug screening, will be required prior to employment.
How To Apply
Applications are accepted on-line at www.yourpath2sonomacounty.org . Paper applications may be submitted by person, fax (707-565-3770), email, or through the mail. All applications and appropriate supplemental information as outlined in the job bulletin must be RECEIVED by the time and date specified on the first page of this job announcement. Applications received after the recruitment closes will not be accepted.
The County of Sonoma is committed to a policy and actively pursues a program of equal employment and non-discrimination. More information can be found at: http://hr.sonoma-county.org/content.aspx?sid=1024&id=1304
HR Analyst: SR
HR Technician: DH