Enterprise Resource Planning Analyst I - Department Promotional

About the Role

This examination is being given to fill 1 vacancy in the Auditor-Controller's Office and to establish an eligible list that may be used to fill future vacancies. This is a departmental promotion. Qualified applicants must currently be employed with San Joaquin County Auditor-Controller's department and meet the promotional eligibility requirements as stated in Civil Service Rule 10, Section 3-Eligibility for Promotional Examinations.

Typical Duties

• Participates in defining and documenting County business requirements through discussions with executive and management staff and end users; creates, documents, and maintains County business processes and troubleshoots ERP system issues in collaboration with County technical support.
• Translates County business requirements into business solutions utilizing the ERP system; identifies opportunities for improvements and increased functionality.
• May serve as a liaison between department end-users, analysts, information technology staff, and vendors in analyzing, designing, configuring, testing, maintaining, and troubleshooting the ERP system in order to ensure optimal system performance, meet County business requirements, and automate business processes.
• Tracks functional upgrades in new releases of ERP software; educates end users on new functionality and implements new functionality upon request.
• Creates integration design requirements and specifications in coordination with end users and the technical staff in support of ERP and/or the IS Division; develops and coordinates acceptance criteria with end users.
• Creates custom report design requirements and specifications in coordination with end users and the technical staff in the ERP Support Organization; develops and coordinates acceptance criteria with end users.
• Collects data, research topics, and gathers information in the completion of studies; and makes recommendations based on studies regarding business solutions in the ERP system.
• Develops and manages task/project plans to implement business solutions; monitor and communicate progress of task/project.
• Assists with identifying and developing application level security; develop and administer security definitions and profiles.
• Enters, maintains and audits data in the ERP system.
• Assists and/or coordinates the development of test scenarios, scripts, and acceptance criteria for the testing of approved changes to the ERP system and/or implementation of a new or upgraded ERP system.
• Participates in the development of training curriculum and training sessions; provides input/feedback on the creation and implementation of policies and procedures, business rules, and user guides; responds to assigned end user requests for assistance and provides instruction where needed.
• Analyzes and interprets technical ERP system and functional information to translate/communicate it to end users in a manner that is easily understood.
• Prepares a variety of periodic and special custom reports; create end user custom reports utilizing vendor's report writer tools.
• Recommends and assists in the implementation of goals and objectives for assigned functional area; establish schedules and methods for achieving assigned work objectives.
• Monitors and evaluates operations and activities of assigned program or functional area responsibilities; recommends improvements and modifications.

Minimum Qualifications

Education: Bachelor's degree from an accredited four-year college or university with major course work in Business Administration, Public Administration, Accounting, Finance, Human Resources, Computer Science, Information Technology, or a related field.

AND EITHER

Experience Option 1: Two years increasingly responsible work experience which required expertise in one or more functional areas served by an ERP system (i.e., financial/accounting or human resources/payroll), including at least one year experience interpreting and analyzing information system requirements within the assigned functional area.

OR

Experience Option 2: Two years of full journey level professional financial/accounting or human resources/payroll administration experience that included transacting and/or processing data in an ERP system application AND participating in the validation of an ERP application's data and/or functionality.

Substitution: Additional qualifying experience may substitute for education on a year-for-year basis.

Knowledge

• ERP System modules in finance, and/or accounting, and/or budgeting, and/or human resources, and/or payroll, and/or property tax
• Business Process Reengineering
• ERP business solution implementation
• Problem diagnosis and troubleshooting techniques
• Relational database theory and design
• Security methods for managing ERP system access
• Principles and practices of training
• Principles and methods of automated records system management
• Web-based business processes such as general ledger, billing, procurement, accounts payable/receivable, cash receipts, bank management, budget management, core human resources, position control, leave management, compensation, benefits administration, time tracking, payroll, financial reporting and/or regulatory reporting

Skills and Abilities

• Develop, communicate and execute detailed project plans
• Define and document business requirements
• Configure ERP application or create custom software designs
• Create reports utilizing ERP application reporting tools
• Establish and maintain effective working relationships and maintain high levels of customer service
• Communicate effectively both orally and in writing
• Follow oral and written instructions
• Read, understand, interpret and apply ERP system manuals
• Work independently under limited supervision, exercise initiative within established procedural guidelines, and organize and prioritize work to meet established deadlines
• Log and track new releases of software, associated functional upgrades and software patches
• Coordinate implementation of new software releases, functional upgrades and software patches with information technology and end users
• Write clear and concise instructions and training plans
• Use Microsoft Office software including Word, Excel, PowerPoint, and Access

Physical/Mental Requirements

• Mobility—sitting for long periods, walking; occasional standing, pushing, pulling, bending, squatting, climbing
• Lifting—frequently 5 pounds or less; occasionally 5 to 30 pounds
• Visual—constant good overall vision and reading/close-up work; frequent color perception and use of eye/hand coordination; occasional use of depth perception and peripheral vision
• Hearing/Talking—frequent hearing of normal speech, hearing/talking on the telephone, talking in person
• Emotional/Psychological—frequent decision making, concentration, and public contact
• Special Requirements—may occasionally require working nights and weekends
• Environmental—occasional exposure to varied weather conditions

Benefits

Health Insurance: San Joaquin County provides a comprehensive benefits package to employees of this bargaining unit. The benefits include the option of four medical plans: a Kaiser HMO plan, a Sutter Health Plus HMO plan, and two self-funded PPO plans called the Select Plan and Premier Plan. Employees pay a portion of the cost of the premium. Dependent coverage is also available.

Dental Insurance: The County provides employees with a choice of four dental plans: Three through Delta Dental and one through United Health Care-Select Managed Care Direct Compensation Plan. The County pays the full premium for all but one Delta Dental Plan (Buy-up), which the employee pays a slightly higher cost. Dependent coverage is available at the employee's expense.

Vision Insurance: The County provides two vision plan options through Vision Service Plan (VSP). There is no cost for the base plan at employee only coverage. The buy-up plan option has a slightly higher cost. Dependent coverage is available at the employee's expense.

Life Insurance: The County provides eligible employees with life insurance coverage as follows: 1 but less than 3 years of continuous service: $1,000; 3 but less than 5 years of continuous service: $3,000; 5 but less than 10 years of continuous service: $5,000; 10 years of continuous service or more: $10,000. Employees may purchase additional term life insurance up to a maximum of $200,000 at the group rate. Regular employees in this unit shall be provided with a supplemental life insurance policy with a face value up to $75,000.

Section 125 Flexible Benefits Plan: This is a voluntary program that allows employees to use pre-tax dollars to pay for health-related expenses that are not paid by a medical, dental or vision plan and dependent care costs. Annual limits are set by the IRS and may change each year.

Retirement Plan: Employees of the County are covered by the County Retirement Act of 1937. Please visit the San Joaquin County Employees' Retirement Association (SJCERA) at www.sjcera.org for more information. NOTE: If you are receiving a retirement allowance from another California county covered by the County Employees' Retirement Act of 1937 or from any governmental agency covered by the California Public Employees' Retirement System (PERS), you are advised to contact the Retirement Officer of the Retirement Plan from which you retired to determine what effect employment in San Joaquin County would have on your retirement allowance.

Deferred Compensation: The County maintains a deferred compensation plan under Section 457 of the IRS code. You may annually contribute $22,500 or 100% of your includible compensation, whichever is less. Individuals age 50 or older may contribute additional catch-up contributions as allowed by law. For more detailed information on the County's benefits program, visit our website at www.sjgov.org under Human Resources/Benefits.