Search Jobs

FINAL FILING DATE:                        Open Until Filled  First cut-off is Friday, March 20, 2020.       

 

IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL QUESTIONNAIRE. YOUR APPLICATION WILL BE REJECTED IF YOU DO NOT PROVIDE ALL NECESSARY INFORMATION.

 

THE POSITION

The Human Resources Department is accepting applications for the Regular and full-time position of ERP Business Analyst II in the Finance Department.  The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available.

 

The City of Roseville promotes a no smoking atmosphere.

 

DEFINITION

To perform complex analytical, administrative, financial, and technical duties in support of implementation, administration, and operation of the Enterprise Resource Planning (ERP) system to improve and enhance business systems and applications; act as liaison between functional users and technical groups in the configuration, modification and testing of the ERP system to meet changing business requirements.

 

DISTINGUISHING CHARACTERISTICS

This is the journey level class within the ERP Business Analyst II series and is distinguished from the I level by the assignment of the full range of duties. Employees at this level receive only occasional instruction or assistance as new, unusual or unique situations arise and are fully aware of the operating procedures and policies within the work unit. Positions in this class are flexibly staffed and are normally filled by advancement from the I level.

 

SUPERVISION RECEIVED AND EXERCISED

Receives direction from assigned management or supervisory personnel. May exercise technical and functional supervision over lower level professional and direct supervision over technical and administrative support personnel.

 

EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:

• Provide internal support on business processes and transactions including understanding integration between an ERP system and external systems ensuring issues resolution.
• Collaborate with Information Technology staff to identify and test quarterly patches, service requests and assess impacts to functionality, resolving issues and identifying solutions to the impacted areas through completion.
• Maintain and modify system table configurations in the various ERP modules, including, but not limited to Finance, Budget, Human Resources and Payroll to support on-going business needs.
• Design, develop, and modify custom reports using ERP tools as required by City Council, management, staff, external systems, and outside agencies.
• Lead and participate in projects to examine, define and modify business processes; serve as technical resource for the planning and execution of projects; plan and participate in business requirements gathering and hands on functional and technical testing of new or modified systems.
• Provide technical support to user groups and identify system enhancements, business process reengineering and recommend system changes to improve efficiencies across the City as a whole.
• Responsible for evaluation of business processes for inefficiencies and matching business needs with ERP System capabilities; recommend best practices and provide support in the building, development, testing of new functionality.
• Perform financial analyses and reconciliation and assist with general accounting duties including balancing financial transactions, assisting with reconfiguration, reporting, month end close, and year end close in performing data collection for the production of financial reports including regulatory and compliance reporting.
• Establish and enforce standards for all documentation of application changes and updates to configuration, process and procedures; update training content by working in conjunction with the business owners of the applicable modules; provide support and training to end users.
• Answer questions and provide information to the public, via telephone, e-mail, and written correspondence; investigate complaints and recommend corrective action as necessary to resolve complaints.
• Build and maintain positive working relationships with co-workers, other City employees and the public using principles of good customer service.
• Perform related duties as assigned.

 

MINIMUM QUALIFICATIONS

 

Knowledge of:

• Modern office equipment and methods including use of computer applications in word processing, spreadsheet, database, and graphic presentation, including Microsoft Office suite.
• Automated accounting and information systems.
• Statistical research and analysis techniques.
• Data analysis and research methods.
• Reporting tools and practices.
• Principles of data management.
• Methods for financial recordkeeping and general ledger reconciliation.
• Principles and practices of generally accepted accounting and reporting activities
• Troubleshooting techniques as it relates to enterprise business applications.
• Principles and practices of project management.
• Principles and practices of business analysis including requirements analysis and solutions assessment.
• Methods and techniques for application development and integration.
• Principles of data retrieval and reporting.

 

Ability to:

• On a continuous basis, know and understand all aspects of the job. Intermittently analyze work papers, reports and special projects; identify and interpret technical and numerical information; observe and problem solve operational and technical policy and procedures.
• On a continuous basis, sit at desk for long periods of time. Intermittently twist to reach equipment surrounding desk; perform simple grasping and fine manipulation; use telephone, and write or use a keyboard to communicate through written means; and lift or carry weight of 10 pounds or less.
• Learn applicable Federal, State and local laws, codes and regulations.
• Learn specialized business unit work processes.
• Apply accounting principles to the analysis of financial and accounting transactions and audit of financial records.
• Support all current and future system and/or process improvements for Finance, Human Resources, Payroll, and Budget.
• Use automated accounting and information systems.
• Research, analyze and resolve technical administrative issues.
• Analyze large and complex sets of data.
• Work with and maintain the confidentiality of information.
• Communicate clearly and concisely, both orally and in writing.
• Establish and maintain effective working relationships with those contacted in the course of work.
• Independently perform professional duties in the analysis of accounting and financial business processes and maintenance and testing of enterprise application systems.
• Analyze, evaluate and integrate business and/or systems processes and procedures to improve current practices and develop effective solutions.

 

EXPERIENCE AND TRAINING

 

Experience:

Two years of professional experience performing duties similar to that of an ERP Business Analyst I with the City of Roseville (performing complex analytical, administrative, financial, and technical duties in support of implementation, administration, and operation of the Enterprise Resource Planning (ERP) system to improve and enhance business systems and applications; acting as liaison between functional users and technical groups in the configuration, modification and testing of the ERP system to meet changing business requirements).

 

AND

 

Training:

A Bachelor’s degree from an accredited college or university, preferably in business administration, computer science, finance, accounting, or a related field.

 

License or Certificate:

Possession of a valid California driver’s license by date of appointment.

 

 

SUPPLEMENTAL QUESTIONNAIRE

 

1. Your responses to questions 2-3, the applicant’s education, training and experience, will be scored using a pre-determined formula.  Your responses to these questions must be consistent with your employment application information.  This experience must also be described in the “Work Experience" section of this application.  Responses to the supplemental questionnaire that are inconsistent from your “Work Experience” section in the application will not be scored.  I understand and agree with the above instructions.

• Yes
• No

 

2. Was any of the work experience listed on your application an unpaid internship, or volunteer work?  If so, please list below which ones.

 

3. How many years of professional experience do you have performing complex analytical, administrative, financial, and technical duties in support of implementation, administration, and operation of an Enterprise Resource Planning (ERP) system to improve and enhance business systems and applications; acting as liaison between functional users and technical groups in the configuration, modification and testing of an ERP system to meet changing business requirements?

• Less than 2 years
• 2-3 Years
• 3-4 Years
• 4-5 Years
• 5+ Years

 

4. Please describe your experience implementing and/or maintaining an ERP system.

 

5. Please identify the products and modules you worked on including any configuration experience.

 

6. What was the most complex project you worked on and what was your role?

 

SELECTION PROCESS

All candidates meeting the minimum qualifications will have their application scored in a Formula Rate Examination.  The applicant’s experience and education will be evaluated using a pre-determined formula.  Scores from this evaluation will determine applicant ranking and placement on the Employment List.  Supplemental questions will be utilized by the department hiring authority to make interview and selection determinations.  Final appointment is contingent upon a check of past employment references, passing a City-paid fingerprint check and depending on position applied for a pre-employment medical exam and a drug and alcohol screening test.

 

THE CITY OF ROSEVILLE IS AN EQUAL OPPORTUNITY EMPLOYER.  IF YOU REQUIRE AN ACCOMMODATION DUE TO A DISABILITY, PLEASE CONTACT THE HUMAN RESOURCES DEPARTMENT AT LEAST 5 WORKING DAYS BEFORE A SCHEDULED INTERVIEW/EXAMINATION PROCESS.  MEDICAL DISABILITY VERIFICATION MAY BE REQUIRED PRIOR TO ACCOMMODATION.

FINAL FILING DATE:                        Open Until Filled  First cut-off is Thursday, March 12, 2020.

 

IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL QUESTIONNAIRE. YOUR APPLICATION WILL BE REJECTED IF YOU DO NOT PROVIDE ALL NECESSARY INFORMATION.

 

THE POSITION

The Human Resources Department is accepting applications for the position of Accountant II in the Finance Department. The current opening is a limited term, benefitted and full-time position in the General Accounting division, but the list may be utilized to fill future regular and full-time vacancies for the duration of the list.  The term length for the current vacancy is not guaranteed but cannot exceed 36 months. The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available. 

 

DEFINITION

To perform a variety of professional accounting duties related to preparing financial statements, reviewing fiscal records, and monitoring financial transactions in accordance with prescribed accounting systems and generally accepted principles of accounting and auditing.

 

DISTINGUISHING CHARACTERISTICS

This is the journey level class within the Accountant series and is distinguished from the I level by the assignment of the full range of duties.  Employees at this level receive only occasional instruction or assistance as new, unusual or unique situations arise and are fully aware of the operating procedures and policies within the work unit.  Positions in this class are flexibly staffed and are normally filled by advancement from the I level.

 

SUPERVISION RECEIVED AND EXERCISED

• Receives direction from the Accounting Supervisor.
• May exercise technical and functional supervision over professional, technical, and support staff as appropriate.

 

EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:

• Participate in the posting, balancing and reconciliation of the general ledger and subsidiary accounts; review and post all utility billing journal entries and reconcile related revenue; analyze and review accrued/deferred assets and liabilities.
• Assist in the preparation, analysis and review of estimated revenues, reimbursements, expenditures, fund balances or other proprietary and budgetary accounts.
• Maintain and update records for the City’s fixed assets in accordance with Governmental Accounting Standards Board (GASB) valuation, quality assessment, and reporting requirements.
• Process and monitor State and Federal grants; coordinate the Single Audit with City’s independent auditors; maintain records of grant-related financial transactions; update and administer the City’s grant policy.
• Assist in the preparation of annual financial reports including but not limited to prepare graphics and statistical data for the City’s Comprehensive Annual Financial Report (CAFR) and other financial reports; review, reconcile, and prepare notes to the financial statements, audit spreadsheets, reports and journal entries; coordinate audits with external auditors and other governmental agencies.
• Examine accounting transactions to ensure accuracy; correct financial records as necessary; analyze, verify, and prepare various financial reports and statements; assist in monitoring various accounts and verify availability of funds and accurate coding and classification of revenues and expenditures; research and analyze transactions to resolve problems.
• Monitor, reconcile, and oversee the petty cash program including maintaining appropriate forms with the appropriate custodian information and performing petty cash counts.
• Assist in processing and monitoring transfers and interfund loans between City funds.
• Recommend or implement changes in accounting systems and procedures; participate in operating a variety of automated office and computerized financial information systems and test various budgetary accounting programs.
• Answer questions and provide information to the public and City departments; research requested information and make recommendations appropriate to resolving inquiries and/or complaints.
• Build and maintain positive working relationships with co-workers, other City employees and the public using principles of good customer service.
• Perform related duties as assigned.

 

 

MINIMUM QUALIFICATIONS

 

Knowledge of:

• Principles and practices of generally accepted accounting practices including generally accepted accounting principles, governmental accounting standards board standards, and grant guidelines.
• Modern office equipment and methods including use of computer applications in word processing, spreadsheet, database, and graphic presentation.
• Principles and practices of governmental accounting, auditing, and financial reporting including generally accepted accounting principles, governmental accounting standards board standards, and grant guidelines.
• Pertinent local, State and Federal laws, rules and regulations, especially as related to accounting, auditing, and grants.

 

Ability to:

• Learn to apply accounting principles to accounting transactions and financial reports.
• On a continuous basis, know and understand all aspects of the job; intermittently analyze financial data, workpapers, reports and special projects; identify and interpret technical and numerical information; observe and problem-solve operational and technical policy and procedures.
• On a continuous basis, sit at desk for long periods of time; intermittently twist to reach equipment surrounding desk; perform simple grasping and fine manipulation; use telephone, and write or use a keyboard to communicate through written means; and lift or carry weight of 10 pounds or less.
• Learn to use automated financial management systems.
• Learn governmental accounting principles and practices, including fund accounting.
• Learn applicable local, State, and Federal laws, rules and regulations, especially as related to accounting and auditing.
• Examine and verify a wide variety of financial documents and reports.
• Prepare a variety of financial statements, reports, and analyses.
• Use a variety of personal computer applications in word processing, spreadsheet, database, and graphic presentation.
• Communicate clearly and concisely, both orally and in writing.
• Establish and maintain effective working relationships with those contacted in the course of work.
• Independently apply accounting principles accounting transactions and financial reports.
• On a continuous basis, know and understand all aspects of the job; analyze financial data, workpapers, reports and special projects; identify and interpret technical and numerical information; observe and problem-solve operational and technical policy and procedures.
• On a continuous basis, sit at desk for long periods of time; intermittently twist to reach equipment surrounding desk; perform simple grasping and fine manipulation; use telephone, and write or use a keyboard to communicate through written means; and lift or carry weight of 10 pounds or less.
• Use automated office and computerized financial information systems.
• Monitor accounting activities relative to compliance with local, State, and Federal requirements and professional standards.
• Assist in the review and implementation of new Governmental Accounting Standard Boards Standards.
• Understand and ensure proper governmental accounting principles and practices, including fund accounting.
• Review and ensure compliance with applicable local, State, and Federal laws, rules and regulations, especially as related to accounting and auditing.

 

 

Experience and Training

 

Experience:

Two years of professional experience performing duties similar to that of an Accountant I with the City of Roseville (performing a variety of professional accounting duties related to preparing financial statements, reviewing fiscal records, and monitoring financial transactions in accordance with prescribed accounting systems and generally accepted principles of accounting and auditing).

 

AND

 

Training:

A Bachelor’s degree from an accredited college or university, preferably in accounting, finance or a related field.

 

License or Certificate

• Possession of a valid California driver’s license by date of appointment.
• Possession of an active Certified Public Accountant (CPA) license is desirable.

 

SUPPLEMENTAL QUESTIONNAIRE

 

1.  Your response to questions 3-4, the applicant’s experience and training, will be scored using a pre-determined formula.  Your responses to these questions must be consistent with your employment application information.  This experience must also be described in the “Work Experience" section of this application.  Responses to the supplemental questionnaire that are inconsistent from your “Work Experience” section in the application will not be scored.  I understand and agree with the above instructions.

• Yes
• No
   

2.  Was any of the work experience listed on your application an unpaid internship, or volunteer work? If so, please list below which ones.
 

3.  Do you possess a California Certified Public Accountant license (if yes, please attach a copy to your application in the space provided)?

• Yes
• No

 

4.  How many years of experience do you have of governmental accounting or auditing?

• Less than 2 years
• 2-3 Years
• 3-4 Years
• 4-5 Years
• 5+ Years
   

5.  Please describe your experience with governmental accounting or auditing.
 

6.  Please describe your experience analyzing, monitoring, and reconciling general ledger and project ledger activity.

 

7.  Please describe your experience preparing complex journal entries.

 

8.  Please describe your experience in preparing audit schedules and/or CAFR disclosures and tables.
 
 

 

SELECTION PROCESS

All candidates meeting the minimum qualifications will have their application scored in a Formula Rate Examination.  The applicant’s experience and training will be evaluated using a pre-determined formula.  Scores from this evaluation will determine applicant ranking and placement on the Employment List.  Supplemental questions will be utilized by the department hiring authority to make interview and selection determinations.  Final appointment is contingent upon a check of past employment references, passing a City-paid fingerprint check and depending on position applied for a pre-employment medical exam and a drug and alcohol screening test.

 

THE CITY OF ROSEVILLE IS AN EQUAL OPPORTUNITY EMPLOYER.  IF YOU REQUIRE AN ACCOMMODATION DUE TO A DISABILITY, PLEASE CONTACT THE HUMAN RESOURCES DEPARTMENT AT LEAST 5 WORKING DAYS BEFORE A SCHEDULED INTERVIEW/EXAMINATION PROCESS.  MEDICAL DISABILITY VERIFICATION MAY BE REQUIRED PRIOR TO ACCOMMODATION.