Senior Auditor *Revised

Print (https://www.governmentjobs.com/careers/sacramento/jobs/newprint/2430115)

Apply

Senior Auditor *Revised

Salary

$91,955.52 – $111,770.64 Annually

Location

Sacramento, CA

Job Type

Permanent Full-Time

Job Number

27624-B

Department

Finance

Division

Auditor-Controller

Opening Date

09/20/2021

Closing Date

9/19/2024 5:00 PM Pacific

+ Description

+ Benefits

+ Questions

The Position

Come join one of Forbes Magazine’s Best Employers!

This is a limited continuous filing exam. Next filing cut-offs are at 5:00 pm on:

5/30/24, 6/27/24, 7/25/24, 8/22/24, 9/19/24 (final)

Under general supervision, leads, plans, schedules and oversees the work of Auditors while performing the same and/or more difficult and sensitive County-wide audit and attest duties as those being led; ensures completion of tasks in accordance with established policies and procedures; communicates policies, procedures and job expectations; and provides training to staff.

Examples of Knowledge and Abilities

Knowledge of

+ Principles and practices of organizational theory, including planning, organizational design, business finance, business development, project management, and organizational effectiveness

+ Principles and practices of leadership, mentoring, and training

+ Applicable federal, state, and local laws, codes, ordinances, regulations, policies, and procedures related to accounting, audit and attest activities

+ Operational characteristics, services, and activities of assigned programs and functions

+ Various professional accounting and auditing standards such as the Generally Accepted Auditing Standards (GAAS), Generally Accepted Accounting Principles (GAAP), Generally Accepted Governmental Auditing Standards (GAGAS)

+ Professional accounting and auditing standards/guidelines established by the U.S. Government Accountability Office (GAO), Financial Accounting Standards Board (FASB), Governmental Accounting Standards Board (GASB), the California State Controller’s Office and other regulatory agencies

+ The Institute of Internal Auditors’ (IIA) professional standard framework including: Code of Ethics, International Standards, and Practice Advisories

+ Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards issued by U.S. Office of Management and Budget (OMB)

+ Internal Control -Integrated Framework issued by Committee of Sponsoring Organizations of the Treadway Commission (COSO) or Standards for Internal Control in Federal Government issued by GAO

+ Accounting procedures and their application to a variety of accounting transactions

+ Preparation of financial statements

+ Methods and procedures of governmental budget preparation and control

+ Financial schedules for external audit purposes

+ Statistical methods, cost and revenue projecting, and cost allocation

+ Applicable revenue and taxation codes

+ Principles and practices of business law

+ Current technology and trends in the profession

+ English usage, spelling, grammar, and punctuation

+ Office procedures, methods, and equipment including telephones, computers and applicable software applications such as word processing, spreadsheets, databases, and other specialized applications related to area of assignment

Ability to

+ Lead and train professional and clerical staff on audit projects and activities

+ Plan, coordinate, assign, and review the work of staff

+ Provide work direction and instruction

+ Organize and prioritize work efficiently to meet schedules and deadlines

+ Research and evaluate work problems, and recommend solutions

+ Develop and maintain cooperative, effective working relationships with others

+ Interpret and apply applicable federal, state, and local laws, codes, and regulations

+ Apply customer service skills, including the identification of customer needs and follow up to ensure customer commitments have been met

+ Analyze statistical and financial data

+ Analyze laws, codes, regulations and technical material to determine impact on accounting functions, and propose solutions and procedures

+ Participate in government contract and budget preparation and monitoring

+ Exercise discretion and maintain confidentiality of information

+ Analyze and make effective recommendations regarding financial and accounting procedures and workflow

+ Acquire subject-matter expertise in the area of work assignment including the federal, state, and local laws, codes and regulations

+ Discern accounting situations requiring policy and procedural determinations by superiors and discuss with other staff

+ Use a personal computer, peripheral equipment, and various software, with emphasis on accounting applications

+ Communicate clearly and concisely, both verbally and in writing

+ Develop and maintain cooperative, effective working relationships with others

Employment Qualifications

Minimum Qualifications:

A Bachelor’s Degree, or higher, from an accredited college or university in Accounting or Business Administration with a concentration in Accountancy;

AND

Two years of full-time, paid audit experience.

Note: Possession of a current valid Certified Public Accountant (CPA) license from the State of California Board of Accountancy may substitute for the required bachelor’s degree.

Note: If the word “experience” is referenced in the minimum qualifications, it means full-time paid experience unless the minimum qualification states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements.

Note: If the minimum qualifications include an educational or certificate/license requirement, applicants must submit proof of requirements with the application. Failure to submit proof of requirements may result in disqualification from the examination. Unofficial transcripts are acceptable. For guidelines on submitting acceptable proof of educational requirements, please click here (http://www.personnel.saccounty.net/Documents/EducationalDocumentsGuidelines.pdf) or speak to someone in our office before the cut-off date listed in this notice.

General Qualifications

Criminal History and Background Checks:

The County may access criminal history information on candidates who have accepted a conditional offer of appointment for this class consistent with the provisions of Board of Supervisors Resolution No. 82-602, Personnel Policies and Procedures, and applicable federal and state laws. The County shall not consider for employment any candidate who has been convicted of a felony or misdemeanor that relates to or impacts the candidate’s ability to perform the job duties of this class unless it is determined that mitigating circumstances exist. For purposes of accessing criminal history information, the candidate will be fingerprinted. A subsequent arrest notification may be obtained.

The County may also conduct a background check on the candidate prior to appointment to a position within this class. The background check may include personal and professional reference checks, credit history checks where authorized by Labor Code section 1024.5, Social Security Number verification, professional license/registration verification, military service information and driving history. Information obtained in the course of this background check will be considered by the appointing authority in the selection process. In obtaining such information, the County will comply with applicable consent and disclosure practices in the Fair Credit Reporting Act and the California Investigative Consumer Reporting Agencies Act.

Driver’s License: A valid California Driver License, Class C or higher, shall be required at the time of appointment. Failure to obtain or maintain the appropriate California Driver License may constitute cause for personnel action in accordance with Civil Service Rules or applicable bargaining agreement. Individuals who do not meet this requirement due to disability will be reviewed on a case-by-case basis.

Working Conditions: Positions in this class may require the incumbents to:

+ Travel to vendor sites and corporate offices in or out of the County to conduct audit activities.

Probationary Period: The probationary period for this classification is twelve (12) months.

Application and Testing Information

APPLICATION

Qualified applicants are encouraged to apply immediately. All applicants must complete and submit an online County of Sacramento employment application by 5:00 PM on the posted cut-off date. Click here (http://agency.governmentjobs.com/sacramento) to apply.

County of Sacramento

Department of Personnel Services

Employment Services Division

700 H Street, Room 4667

Sacramento, CA 95814

Phone (916) 874-5593; 7-1-1 California Relay Service

Email EmployOffice@Saccounty.net

Inter-Office Mail Code: 09-4667

www.SacCountyJobs.net

+ Employment applications and all documentation requested in this announcement must be submitted by 5:00 p.m. on the cut-off date.

+ Employment Services is not responsible for any issues or delays caused by an applicant’s computer or web browser. Applicants will be automatically logged out if they have not submitted their applications and all documentation prior to 5:00 p.m. on the cut-off date.

+ Your application should highlight all relevant education, training, and experience, and clearly indicate how you meet the minimum qualifications for the position as of the cut-off date.

+ Application information must be current, concise and related to the requirements in this job announcement. You may only apply for this recruitment once. Duplicate and incomplete applications will be disqualified.

+ A resume may be included with your application, however it will not substitute for the information requested on the application.

SUPPLEMENTAL QUESTIONNAIRE

Applicants are required to provide a full and complete response to each supplemental question. The Supplemental Questionnaire is located in the tab marked “Supplemental Questions”. Please be descriptive in your response.

Note: Responses of “See Resume” or “See Application”, or copy and paste of work experience are not qualifying responses and will not be considered.

+ Supplemental Questionnaires must be submitted by 5:00 p.m. on the cut-off date. Employment Services is not responsible for any issues or delays caused by an applicant’s computer or web browser. Applicants will be automatically logged out if they have not submitted their applications and all documentation prior to 5:00 p.m. on the cut-off date.

+ The supplemental questions are designed to elicit specific information regarding a candidate’s experience, education, and training. Responses should be consistent with the information on your application and are subject to verification.

+ Please provide place of employment, pertinent dates, and concise, descriptive and detailed information for each question.

+ If a job included responsibilities applicable to several questions, separate the different functions of the job to answer all the questions completely.

+ Resumes or referral to the application or other questionnaire responses will not be accepted in lieu of completing each question.

+ If you have no experience, write “no experience” for the appropriate question.

+ For many individuals, it is more efficient to develop responses to the supplemental questions in a word processing document and then paste them into the final document to be submitted. Changes or corrections to your Supplemental Questionnaire cannot be made once your application packet has been submitted.

+ If the Supplemental Questionnaire is used in the Formula Rate exam, failure to complete all of the questions or incomplete responses will result in a lower score. While scoring the Supplemental Questionnaire, the candidate’s application and/or attachments will not be reviewed, therefore, a candidate’s responses to the questions should be accurate, thorough, detailed, and complete.

FORMULA RATE EXAMINATION (Weighted 100%)

All candidates meeting the minimum qualifications by the cut-off date will have their Supplemental Questionnaire scored in the Formula Rate Examination.

This examination will evaluate the relevance, level, recency, progression and quality of candidate’s education, training and experience. The candidate’s application or other materials will not be included in this examination. Therefore, the candidate’s responses to the supplemental questionnaire should be thorough, detailed and complete. The score from the Formula Rate Examination will determine the ranking on the eligible/employment list for this job.

All candidates competing in the testing process will receive written notice of their examination results by email. Notices can also be accessed in their governmentjobs.com inbox. Applicants achieving a passing score will be placed on the eligible list in rank order. The rank is determined by the test score attained from the examination.

FREQUENTLY ASKED QUESTIONS

Click here (https://personnel.saccounty.net/Pages/EmploymentServicesFAQs.aspx) for Frequently Asked Questions (FAQ’s)

For information regarding County jobs:

+ www.saccountyjobs.net

Applicants requesting reasonable accommodations during employment examinations: For more information, please review the Job Applicant Exam Reasonable Accommodation Information (https://personnel.saccounty.net/Pages/DCOJobApplicantExamReasonableAccommodation.aspx) and submit an Employment Exam Reasonable Accommodation Online Request Form.

EMPLOYEE BENEFITS

As an employee of the County of Sacramento, there will be a variety of benefits available to you. These benefits currently include: health, dental and life insurance; flexible spending account options for dependent care and unreimbursed dental and/or medical cost; and an employee assistance program (EAP).

GENERAL BENEFITS:

Most employee benefits are similar to the following for all County employees. However, some benefits differ, depending on the employee representation unit to which the employee’s job classification is assigned. Information about the exact benefits applicable to a particular job classification may be obtained from the Sacramento County Department of Benefits or by visiting www.saccountyjobs.net.

TEMPORARY POSITIONS:

Most benefits do not apply to temporary positions. The explanations of benefits applies to employees in regular positions.

SALARY STEP INCREASES:

The beginning salary and the top of the salary range are usually shown on the job announcement. Upon satisfactory service, salary increases of approximately 5% are given annually until the top of the salary range has been attained.

PAY:

All employees are paid bi-weekly via direct deposit into the employee’s bank account. The pay period covers fourteen (14) calendar days, starting on a Sunday and ending on the second Saturday thereafter. Salaries are generally paid on the Friday following the end of the pay period. Employees can set up their direct deposit and access their pay information via Employee Self Service in MySacCounty.

VACATION:

Generally, vacation with pay begins at 10 days annually. With increase over a period of years, the maximum annual vacation with pay is 25 days.

HOLIDAYS:

14.5 holidays per year as recognized.

SICK LEAVE:

Equivalent to 15 days annually, unlimited accumulation. Upon retirement, unused sick leave is converted to retirement service credit.

PARENTAL LEAVE:

Entitles a regular County employee, with at least one year of continuous employment, to schedule a paid parental leave of up to 160 hours upon the birth or during the process of an adoption of a minor child. Parental leave shall be approved by the employee’s appointing authority, except where the granting of the parental leave request would unduly interfere with or cause severe hardship upon department operations.

TUITION REIMBURSEMENT:

Dependent upon union agreements, regular County employees may be eligible to receive Tuition Reimbursement. The costs for course tuition/registration fees and required books/supplies are eligible for reimbursement. Tuition reimbursement amounts may vary depending upon union agreement.

RETIREMENT:

Social Security and Sacramento County Employees’ Retirement System coverage.

HEALTH INSURANCE:

The County offers a variety of health plan design options to fit individual needs.

DENTAL INSURANCE:

The County provides a comprehensive dental benefit program for regular full-time and part-time employees and their eligible dependents. This plan pays on a set fee schedule that varies by procedure. Any amount over the fee schedule is the employee’s responsibility. The yearly maximum is $2,000 per person, not including orthodontia. The orthodontic benefit is 50% of covered charges with a lifetime maximum of $1,000 per person.

LIFE INSURANCE:

The County of Sacramento provides a basic life insurance benefit of $15,000 to all eligible employees at no cost. Additional coverage may be purchased through payroll deduction.

DEFERRED COMPENSATION:

The County offers a Deferred Compensation Program which enables employees to save in a systematic way without paying income tax on either the payroll deduction or the earned interest, prior to withdrawal.

EMPLOYEE ASSISTANCE PROGRAM:

The County of Sacramento provides an Employee Assistance Program (EAP) for employees and their eligible dependents. The EAP offers confidential, professional counseling services in areas such as:

+ Legal Advice/Difficult Decisions

+ Marriage or Family Relationships

+ Financial or Credit Worries/Elder Care

+ Alcohol and Drug Abuse

WELLNESS INCENTIVE PROGRAM:

The County will recognize and award time off to eligible employees who maintain an excellent attendance record.

FLEXIBLE SPENDING ACCOUNT:

The County offers regular employees two separate Flexible Spending Accounts (FSA’s). These accounts allow employees to set money aside, on a pre-tax basis via payroll deduction, to pay for medical, dental or dependent care expenses.

+ DEPENDENT CARE REIMBURSEMENT ACCOUNT:

Employees may set aside pre-tax dollars to pay for qualified childcare or dependent care expenses that are necessary for the employee and/or spouse to continue working.

+ MEDICAL REIMBURSEMENT ACCOUNT:

The Medical Reimbursement Account allows pre-tax dollars to be set aside to pay for out-of-pocket expenses that are not paid by insurance or reimbursed by any other benefit plan.

WORKERS’ COMPENSATION:

In case of injury while on the job, each employee is protected under the Workers’ Compensation laws of California.

SACRAMENTO CREDIT UNION:

The credit union offers loan facilities and systematic saving plans through payroll deduction.

SELECTION AND PLACEMENT

Sacramento County encourages applications from all persons regardless of race, color, ancestry, religious creed, national origin, gender, disability, political affiliation, or age.

Certain age limits may be required by law, ordinance, or Civil Service direction for specific classifications such as those identified with hazardous occupations.

MINIMUM QUALIFICATIONS:

Please read carefully the “Minimum Qualifications” section of your announcement. You must meet those qualifications by the application deadline date unless otherwise specified. Your application must clearly show you meet the minimum qualifications by the application deadline date, or it will not be accepted. All statements are subject to verification.

“Experience” means full-time paid experience unless the announcement states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements.

PROMOTIONAL EXAMINATIONS:

If the announcement indicates the examination is given on a promotional basis, candidates must hold permanent status in Sacramento County Civil Service by the application deadline date and must meet the minimum qualifications.

OPEN EXAMINATIONS:

Any person who meets the minimum qualifications may apply.

CONTINUOUS FILING EXAMINATIONS:

Applicants are eligible to reapply to and retake a continuous filing exam after 6 months from the date the previous exam results was received.

ELIGIBLE LISTS:

Names of qualified persons who made a passing score on an examination are entered, in order of their final grades, on an eligible list. To fill each vacancy, the hiring department will make a selection from among the top three ranks on the employment lists.

EXAMINATION RATINGS:

Unless otherwise stated on the announcement: To be successful, candidates must obtain a rating of at least 70% on each part of the examination. This may be an adjusted score or an arithmetic 70% of the total possible score as determined by the Director.

APPEAL PROCESS:

Persons who believe their applications have been improperly rejected may request the Employment Services Division to review its decision to reject the application. If the applicant desires to submit additional proof of qualifications, such proof must be received by Personnel Services not less than two (2) calendar days prior to the scheduled date for the examination.

Persons who are disqualified in any phase of the examination may appeal such adverse action, in writing, to the Civil Service Commission, 700 H Street, Room 2640, Sacramento, CA 95814, telephone: (916) 874-5586. Such appeals must be filed within thirty (30) calendar days after notice of the adverse action was mailed to the candidate.

FOR MORE INFORMATION PLEASE VISIT OUR FREQUENTLY ASKED QUESTIONS (FAQs): https://personnel.saccounty.net/Pages/EmploymentServicesFAQs.aspx

OTHER INFORMATION

VETERAN’S PREFERENCE:

Military veterans who have served during wartime shall be given preference in initial appointment to County service. Such preference shall apply, provided the veteran has first achieved a minimum passing score in the examination. The passing score of a veteran shall be annotated to indicate the veteran’s score shall be regarded as 5 points or higher, OR 10 points higher for disabled veterans, only for the purpose of determining the three ranks along with which the veteran’s name shall be certified. No score shall actually be changed and no new rank shall be created as a result of application of veteran’s preference for certification purposes.

“Disabled Veteran” means any veteran who has served during wartime and, who, as of the final filing date for an examination is declared by the United States Veterans Administration or military service department to be 10% or more disabled as a result of his/her military service. Persons claiming eligibility for disabled veteran’s preference must submit to the employment office, on or before the application deadline date, a certification from the United States Veterans Administration or a military service department, dated within 1 year, which certifies the present existence of a service related disability of 10% or more, or other acceptable proof of such disability as a result of his/her military service.

Persons claiming eligibility for veterans preference must submit a copy of Form DD 214 or other acceptable proof of veteran’s status on or before the final filing date for the examination. For purpose of this rule “reserve” status does not constitute active duty.

CITIZENSHIP OR AUTHORIZED ALIEN REQUIREMENT:

As required by the Immigration Reform and Control Act, all County employees must be United States citizens or aliens lawfully authorized to work in the United States. Proof of citizenship or authorized status will be required prior to appointment.

CONFLICT OF INTEREST CODE:

Some County Civil Service positions are covered by financial disclosure requirements intended to identify potential conflicts of interest.

CONCURRENT EMPLOYMENT:

No employee may concurrently occupy more than one County position.

SPECIAL SKILL QUALIFICATIONS (WHEN SPECIFIED ON THE APPLICATION):

Persons who have special skills required by some (but not all) positions in a class may be certified ahead of others provided that:

Such special skills are based on the duties and requirements of the positions and are in conformance with merit system and equal opportunity principles, and

The certification of eligibles who possess special skills have been approved by the Civil Service Commission.

PRE-EMPLOYMENT MEDICAL EXAMINATION & DRUG TESTING:

The County of Sacramento is committed to maintaining a drug and alcohol free workplace. All persons selected for appointment to positions must pass a medical examination and a drug test, administered by the County at no cost to the applicant.

DRIVER LICENSE:

Possession of a valid California Driver License may be required for some positions.

PROBATIONARY PERIOD:

Regular positions are subject to a probationary period which is an extension of the selection process. Unless otherwise indicated on the announcement, the probationary period is six (6) months.

AGENCY SHOP/FAIR SHARE FEE:

Some positions require, as a condition of continued employment, that the person either:

1. Become a union member;

2. Pay a fair share fee to the union; or,

3. Meet specific requirements under which an equivalent amount must be paid to a charity.

FINGERPRINTING AND CRIMINAL RECORD CHECKS:

Fingerprinting and criminal record checks are required for some positions.

The following Supplemental Questionnaire is the Civil Service Exam for this position and will be used to determine your exam score.

Note: The Supplemental Questionnaire and the Application are administered as two separate documents. The Application is used only to determine if the minimum qualifications are met; and the Supplemental Questionnaire will be used only to determine your exam score.

In order to receive every consideration in the selection process, you must complete all questions with concise but detailed answers and provide all requested information. Each answer will be scored separately. References such as ‘See Resume’ as a response will not be scored.

By continuing in the exam process, you are certifying that all information provided in the Supplemental Questionnaire is true to the best of your knowledge.

+ I have read and understood the above instructions.

Select the one box that best describes your academic level related to the position of Senior Auditor.

+ Master degree or higher in Accounting or Business Administration with a concentration in Accountancy.

+ Bachelor degree in Accounting or Business Administration with a concentration in Accountancy.

+ Possession of a current valid Certified Public Accountant (CPA) license from the State of California Board of Accountancy.

+ None of the above.

Select all the boxes that best describe active or current accounting or auditing related certifications or licenses you possess.

+ Certified Fraud Examiner (CFE).

+ Certified Governmental Audit Professional (CGAP).

+ Certified Information System Auditor (CISA).

+ Certified Internal Auditor (CIA).

+ Certified Public Accountant-Attest (CPA-A).

+ None of the above.

Select the one box that best describes the continuing professional education hours you have completed in the last 2 years.

+ 1 hour but less than 20.

+ 20 hours, but less than 40.

+ 40 hours, but less than 60.

+ 60 hours, but less than 80.

+ 80 or more hours.

+ None of the above.

Describe in detail your education, training, certifications and/or licenses as they relate to the position of Senior Auditor. If you have earned a degree or completed college level coursework, include your major and name of the college or university. For every certification or license you selected in Question 3, list license number and expiration date. Also, include how you maintain your professional development. If you have no relevant education, training, certifications and/or licenses, please type “None”.

Select the one box that best describes your auditing experience.

+ Some experience, but less than 2 years.

+ 2 years, but less than 3 years.

+ 3 years, but less than 4 years.

+ 4 years, but less than 5 years

+ 5 or more years

+ None of the above.

Select the one box that best describes how much experience you have leading or performing complex audits.

+ Some experience, but less than 1 year.

+ 1 year, but less than 2 years.

+ 2 years, but less than 3 years.

+ 3 or more years.

+ None of the above.

Describe in detail your auditing experience that qualifies you for the position of Senior Auditor with Sacramento County. Highlight the complex audits you performed or led, and specify what made them complex. Also include in your response employer/organization information, position held, an overview of other duties performed in relation to this question, and dates of employment. You may include more than one employer/organization. If you have no relevant experience, please type “None”.

Select all the boxes that describe the types of assignments/engagements you have performed as an auditor.

+ Agreed upon procedures.

+ Compliance audits.

+ Computer system reviews.

+ Financial statement audits.

+ Governmental auditing

+ Internal audits.

+ Internal controls reviews.

+ Other.

+ None of the above.

Describe in detail your experience in performing various engagements as noted in Question 9. Include in your response employer/organization information, position held, duties performed in relation to each type of engagement you selected, and dates of employment. You may include more than one employer/organization. If you have no relevant experience, please type “None”.

Select the one box that identifies your proficiency using Microsoft Excel. You may be required to demonstrate your proficiency using Microsoft Excel during the interview process.

+ None.

+ Basic: Data entry; inputting data to create simple reports; using and creating simple formulas; etc.

+ Intermediate: Using complex formulas; using macros; creating spreadsheets/worksheets; etc.

+ Advanced: Creating macros; creating complex spreadsheets; extracting data from multiple sources and worksheets; creating pivot tables, creating charts and graphs; etc.

Describe in detail your verifiable experience using Microsoft Excel or comparable software. In your response, provide a few examples to demonstrate your proficiency including the type of documents created, how and if you created the documents, and the purpose of the documents. Also, include any formal training you have taken in Microsoft Excel or comparable software. If you have no relevant experience or training, please type “None”.

Select the one box that best identifies your proficiency using Microsoft Word. You may be required to demonstrate your proficiency using Microsoft Word during the interview process.

+ None.

+ Basic: Opening, creating, and saving simple documents; using form letters/templates (not creating); cutting and pasting; etc.

+ Intermediate: Creating form letter templates; creating and using styles; cutting and pasting from unlike data sources; etc.

+ Advanced: Creating macros; creating multiple section breaks with different page numbers; creating automatic table of contents; linking multiple documents; creating columns; embedding images and objects; etc.

Describe in detail your verifiable experience using Microsoft Word or comparable software. In your response, provide a few examples to demonstrate your proficiency including the type of documents created, how and if you created the documents, and the purpose of the documents. Also, include any formal training you have taken in Microsoft Word or comparable software. If you have no relevant experience or training, please type “None”.

Select one box that identifies your proficiency using Microsoft Access in a working environment. You may be required to demonstrate your proficiency using Microsoft Access during the interview process.

+ None.

+ Basic: Data entry; inputting data to create simple reports.

+ Intermediate: Creating a table by using Table Wizard and Design View; adding fields to a table and setting the primary key; saving and adding records; modifying field names; deleting and inserting fields, finding and replacing values in a table; creating queries by using the Query Wizard and Design view; etc.

+ Advanced: Filtering records; setting field properties; sorting and filtering query results; adding fields to and removing fields from a query; grouping and summarizing data in a report; adding report headers and footers; creating a multiple item form, etc.

Describe in detail your verifiable experience using Microsoft Access or comparable software. In your response, provide a few examples to demonstrate your proficiency including the type of documents created, how and if you created the documents, and the purpose of the documents. Also, include any specialized training you have taken in Access or other database programs. If you have no relevant experience or training, please type “None”.

Select all the boxes that describe computerized systems you are proficient in using.

+ Auditing Software (e.g. TeamMate, Idea, CaseWare, etc.).

+ Computerized Accounting Systems (e.g. Quick Books, Peach Tree, etc.).

+ Enterprise Resource Planning Systems (e.g. SAP, Peoplesoft).

+ Other.

+ None of the above.

Describe in detail your experience and provide a few examples to demonstrate your proficiency with Auditing Software, Computerized Accounting Systems, and/or Enterprise Resource Planning Systems. Also, include any specialized training you have taken in computerized systems. If you have no relevant experience or training, please type “None”.

I have read the General Requirements and Other Requirements as stated on the job announcement.

+ Yes.

The County of Sacramento is committed to maintaining a drug and alcohol free workplace. All persons selected for appointment must pass a drug test administered by the County and at no cost to the applicant.

I understand, if offered conditional employment, I will be subject to a drug test administered by the County as described in Sacramento County Personnel Ordinance Section 2.78.030.

+ Yes

+ No

Required Question

Agency

County of Sacramento

Address

700 H Street, Room 4667 Sacramento, California, 95814

Phone

(916) 874-5593

Website

http://www.saccountyjobs.net

Apply

Please verify your email address Verify Email