County of Alameda

DESCRIPTION

Under general direction, the incumbent will analyze department information and reporting system needs, and review, maintain and upgrade software systems to meet those needs. The Workforce Board System Administrator is responsible for gathering requirements, defining problems and recommending solutions, writing and identifying database design specifications, modifying existing information and reporting systems and providing production support for staff, users and their systems. The Workforce Board System Administrator may also prepare instructional material for department staff, vendors and service providers; act as project manager; and perform related duties as required.

 

DISTINGUISHING FEATURES

This is a single position classification working in the Workforce Board Department within the Social Services Agency. The incumbent is expected to work independently in evaluating, developing, testing, selecting, implementing, and maintaining software systems and programs, then using those systems to develop and deliver data and reports for stakeholders. Stakeholders include, but are not limited to federal, state and local funders, the governing boards and administrators, program service providers, and workforce system partners. Data systems activities include analyzing information business requirements, recommending technology solutions, preparing automated system specifications, designing logic flow diagrams, screens, reports, forms and menus. Data management activities include researching and complying with federal and state data collection and reporting guidelines, assisting with compliance in program service delivery and developing, tracking, and analyzing service/system performance objectives. The Workforce Board System Administrator may supervise Workforce Services Technicians, Management Analysts, compliance tracking, and clerical staff.

The Workforce Board System Administrator differs from Assistant Director, Workforce Investment Board in that the incumbent specializes in, and spends a majority of their time working on, business applications systems analysis, design, data management, reporting, program performance/measures, and evaluation.

.

EXAMPLES OF DUTIES

NOTE: The following are the duties performed by employees in this classification. However, employees may perform other related duties at an equivalent level. Each individual in the classification does not necessarily perform all duties listed.

1. Performs business systems analysis appropriate to the Department's specific needs.

2. Consults with department representatives to discuss and define business application programming solutions. Defines the scope of system problems and the goals and needs of automated systems; determines methodology to solve application problems.

3. Participates in management review to improve a departments’ functions and/or procedures; identifies potential solutions and reports on the advisability of each, including feasibility, equipment requirements, personnel requirements, cost/ benefit effectiveness, time requirements, and makes a recommendation on which solution should be used.

4. Conducts system review and user consultations to troubleshoot and resolve internal systems and/or external system issues.

5. Analyze existing systems (assessing data flow, file structure, program processes and report layouts) and update designs, as needed, to address changes in systems requirements, equipment configurations, and business needs.

6. Coordinates internal and external system training.

7. Prepares, analyzes, and creates formal operational and performance reports for departmental management review for planning and other purposes. Prepare statistical and other formal reports to board members and other stakeholders.

8. Monitors and maintains data production systems to assure success.

9. Acts as a liaison with the State Workforce Agency and the Department of Labor, various funders, and vendors. Participate in State, Regional and Local User Peer Groups.

10. Assists department management team in the development of measureable goals and objectives demonstrating knowledge of computer systems and capabilities.

11. Researches, understands, and implements data management systems to comply with federal, state, and other funding data collection and reporting guidelines.

12. Oversees data collection and reporting used to measure compliance in program service delivery, fiscal tracking, and developing, tracking, and analyzing service/system performance objectives.

MINIMUM QUALIFICATIONS

EITHER I

Education:

The equivalent to graduation from an accredited four-year college or university (120 semester units or 180 quarter units) with a major in Public or Business Administration, Management, MIS, Computer Science, Computer Engineering or a closely related field.


AND
Experience:

The equivalent of four years full-time administrative/management experience within a county, workforce development or community-based organization, involving database management, planning, and evaluation, with a minimum of one year responsible database management experience. Possession of a Master’s Degree in a related area may substitute for two years of the administrative/management experience.

Experience using Results Based Accountability and/or other performance/evaluation development and measurement methods is desirable. Experience in designing, creating and managing dashboards is desirable.

Additional professional administrative/management experience within a county, workforce development or community-based organization, involving database management, planning, and evaluation may be substituted for the education on a year-for-year basis.

NOTE: The Civil Service Commission may modify the above Minimum Qualifications in the announcement of an examination.

KNOWLEDGE AND SKILLS

NOTE: The level and scope of the following knowledge and abilities are related to duties listed under the “Examples of Duties” section of this specification.

Knowledge of:

• Business and management principles involved in strategic planning, resource allocation, human resources/supervision, leadership techniques, production methods, and coordination of people and resources.
• Modern computer technology used to plan, develop and administer computers and network systems.
• Information technology concepts.
• Quality assurance and/or performance measurement concepts.
• Methodologies for analyzing systems, procedures and workflow.
• Office software applications, including proficiency in Excel, Access, Word, Power Point and other data and presentation applications.
• Functions and capabilities of database systems.
• World Wide Web technology.
• Principles of network infrastructure.

 
Ability to:

• Function as a system(s) administrator.
• Formulate and execute queries in MS Access and other databases.
• Create a variety of reports, analysis, data compilations for board members, stakeholders, funders, and the general public.
• Interpret workforce regulations, mandates and state/federal legislative requirements.
• Maintain and modify existing office software applications.
• Analyze and problem solve.
• Make effective decisions.
• Plan and organize.
• Identify and correct problems with computers and related equipment.
• Analyze problems related to database design and system interactions and cross platform issues.
• Prepare and maintain documentation, records and logs.
• Communicate effectively both orally and in writing.
• Interface with users at all levels of the organization, including formal reports and presentations to governing boards.

CLASS SPEC HISTORY

Newspecs: 6056
IB:cs 5/23/16
CSC Date: 6/22/16
IB:jf Revised 1/31/17

CSC Date: 3/1/17

BENEFITS

Alameda County offers a comprehensive and competitive benefits package that affords wide-ranging health care options to meet the different needs of a diverse workforce and their families. We also sponsor many different employee discount, fitness and health screening programs focused on overall well being.  These benefits include but are not limited to*:

For your Health & Well-Being

• Medical – HMO & PPO Plans
• Dental – HMO & PPO Plans
• Vision or Vision Reimbursement
• Share the Savings
• Basic Life Insurance 
• Supplemental Life Insurance (with optional dependent coverage for eligible employees)
• Accidental Death and Dismemberment Insurance 
• County Allowance Credit
• Flexible Spending Accounts - Health FSA, Dependent Care and Adoption Assistance
• Short-Term Disability Insurance
• Long-Term Disability Insurance
• Voluntary Benefits - Accident Insurance, Critical Illness, Hospital Indemnity and Legal Services
• Employee Assistance Program

For your Financial Future

• Retirement Plan - (Defined Benefit Pension Plan)
• Deferred Compensation Plan (457 Plan or Roth Plan)

For your Work/Life Balance

• 12 paid holidays
• Floating Holidays
• Vacation and sick leave accrual
• Vacation purchase program
• Management Paid Leave**
• Catastrophic Sick Leave
• Pet Insurance
• Commuter Benefits Program
• Guaranteed Ride Home
• Employee Wellness Program (e.g. At Work Fitness, Incentive Based Programs, Gym Membership Discounts)
• Employee Discount Program (e.g. theme parks, cell phone, etc.)
• Child Care Resources
• 1^st United Services Credit Union 

*Eligibility is determined by Alameda County and offerings may vary by collective bargaining agreement.  This provides a brief summary of the benefits offered and can be subject to change.

** Non-exempt management employees are entitled to up to three days of management paid leave. Exempt management employees are entitled to up to seven days of management paid leave.