Principal Business Analyst - Department Promotional

This examination is being given to fill 1 vacancy in the Probation Department and to establish an eligible list to fill future vacancies. Resumes will not be accepted in lieu of an application. A completed application must be postmarked or received online by the final filing deadline.

NOTE: All correspondences relating to this recruitment will be delivered via e-mail. The e-mail account used will be the one provided on your employment application during time of submittal. Please be sure to check your e-mail often for updates. If you do not have an e-mail account on file, Human Resources will send you correspondences via US Mail.

 

1. Manages departmental business cycle analytics programs and functions; works with other department managerial staff to establish process improvement goals, objectives, and opportunities and make strategic proposals for the analysis and interpretation of business information and the realization of business goals.

2. Manages, directs, oversees, and participates in the collection, identification, and analysis of business cycle information, including key performance indicators; designs and manages the use of complex data tools and system queries; ensures the correct selection, analysis and interpretation of data and the identification of business trends.

3. Manages and conducts detailed analytic and data-based studies of departmental business functionality, including financial, program, and/or operational activities; using explanatory and predictive modeling methods, develops business scenarios, options, priorities and alternatives; prepares cost and revenue projections.

4. Manages and participates in the preparation of complex analytical reports outlining study findings as well as process improvement solutions and analyses; develops cost allocations and indirect cost rate proposals based on third-party payer and/or other requirements.

5. Participates in the development of capital and operational budgets; analyzes budget variances, provides explanations as to why they occurred, and provides recommendations as needed.


6. Manages the design and development of solution testing plans, strategies and quality management tools; reviews solution defects and makes strategy adjustments as needed.

7. Supervises the work of subordinate staff, including analytical, supervisory, technical and/or other employees; provides training on departmental systems and processes; assigns, directs, and monitors staff activities; evaluates staff performance; initiates disciplinary action as required.

8. Provides business process subject matter expertise for, and coordination of, information technology projects; defines business process needs and provides liaison and input to information technology staff regarding the development, modification, and/or maintenance of automated systems.

9. Monitors the quality and integrity of data stored in and/or processed through core business applications and databases; ensures the maintenance of data tables and references and the downloading/uploading of data sets; identifies opportunities for improving databases, data sets, and reports utilized by the department, and works with departmental information technology staff to implement changes as appropriate.

10. Defines and conducts best practice studies by researching other departments and/or agencies; responds to a variety of information requests from both inside and outside the department.

11. Analyzes and interprets existing, new and proposed legislation for cost and program impacts; develops and prepares impact projections.

12. Prepares and presents a variety of financial, statistical, and narrative documents, including charts, tables, and other visual data tools; prepares and answers correspondence and questionnaires; makes graphic and oral presentations to individuals and groups.

13. Develops and recommends policy statements for management approval.

14. Confers with representatives of other agencies or departments; serves as a liaison between departments.

PLEASE NOTE: This is a departmental promotion. Qualified applicants must currently be employed with San Joaquin County Probation department and meet the promotional eligibility requirements as stated in Civil Service Rule 10, Section 3-Eligiblity for Promotional Examinations.

EITHER PATTERN I

Experience: Two years as a Business Analyst II in San Joaquin County Service.

OR PATTERN II

Education: Graduation from an accredited four-year college or university with a major in business analytics, computer science, mathematics, finance, business, or public administration, or a closely-related field.


Experience: Four years conducting professional, quantitative analyses of financial, programmatic, and/or operational business data utilizing business analytics methodologies, as well as developing and presenting process improvement recommendations.

Substitution #1: Current standing as a Certified Business Analysis Professional (CBAP) from the International Institute of Business Analysis may substitute for the above-required education.

Substitution #2: A master’s degree in business analytics, computer science, mathematics, finance, business or public administration, or a closely-related field may be substituted for one year of the above-required experience.

AND FOR BOTH PATTERNS

Special Requirement: Depending on assignment, positions may require that some or all of the qualifying experience was obtained while working in an area or program that is directly related to departmental business operations.

Principles and practices of public sector management and administration, including human resources and fiscal control; principles and practices of leadership, supervision and employee development; advanced theories, principles, and methods related to the business intelligence life cycle including predictive modeling, data mining, lean operations, requirements management and communication, enterprise analysis, requirements analysis, and solution assessment and validation; advanced quantitative data analytics techniques and procedures related to research, collection, compilation, statistical evaluation, and modeling of data; laws and regulations pertaining to area of assignment; computer software tools used for the storage, management, manipulation, analysis and reporting of large quantities of data; typical spreadsheet and relational database programs and analysis tools; basic principles of information technology; principles and methods of communicating information through written and oral reports and presentations.

Manage complex business analytics programs and projects; supervise and develop subordinate staff, including professional analysts; participate in strategic management groups for the purpose of identifying analytics goals and objectives; build and conduct relational database queries using standard software tools; analyze business data in order to identify trends, resolve problems, and recommend potential areas of process improvement; participate in the development and maintenance of departmental data systems and structures; lead and/or coordinate projects; communicate effectively, both orally and in writing; maintain effective relationships with those contacted during the course of work.

Mobility - ability to frequently sit for long periods, move about an office, and reach above and below desk level. Dexterity - sufficient to frequently operate a keyboard, handle individual papers, and write and take notes. Lifting - ability to occasionally lift papers, files, and material weighing up to 25 pounds. Visual - ability to frequently read computer screens and do close-up work. Hearing/Talking - ability to hear normal speech, hear on the telephone, talk in person, and talk on the telephone. Emotional/Psychological Factors - ability to frequently make decisions and concentrate, and to occasionally make public contact and work overtime if needed.

San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation.  For more information go to Equal Employment Opportunity Division (sjgov.org).

Accommodations for those covered by the Americans with Disabilities Act (ADA):

San Joaquin County complies with the Americans with Disabilities Act and, upon request, will consider reasonable accommodations to enable individuals with disabilities to perform essential job functions.

Health Insurance:  San Joaquin County provides a comprehensive benefits package to employees of this bargaining unit.  The benefits include the option of three medical plans: a Kaiser Plan, a Select Plan, and a 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 two dental plans:  Delta Dental and United Health Care-Select Managed Care Direct Compensation Plan.  There is no cost for employee only coverage in either plan; dependent coverage is available at the employee’s expense.

Vision Insurance:  The County provides vision coverage through Vision Service Plan (VSP).  There is no cost for employee only coverage; dependent coverage is available at the employee’s expense.

For more detailed information on the County’s benefits program, visit our website at www.sjgov.org under Human Resources/Benefits.

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.

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 (Health Flexible Spending Account $2550 annual limit with a $500 carry over); and dependent care costs (Dependent Care Assistance Plan $5000 annual limit). 

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 $18,000 or 100% of your includible compensation, whichever is less.  Individuals age 50 or older may contribute to their plan, up to $24,000. The Roth IRA (after tax) is also now available.

Vacation:  Maximum earned vacation is 10 days each year up to 3 years; 15 days after 3 years; 20 days after 10 years; and 23 days after 20 years.

Holiday: Depending on date of hire into the unit, employees earn either 10 or 14 holidays per year. 

Administrative Leave:  Each fiscal year, department heads grant 10 days of administrative leave to eligible salaried employees.  Administrative leave may not be carried beyond to the next fiscal year.

Sick Leave:  12 working days of sick leave annually with unlimited accumulation.  Sick leave incentive: An employee is eligible to receive eight hours administrative leave if the leave balance equals at least one-half of the cumulative amount that the employee is eligible to accrue.  The employee must also be on payroll during the entire calendar year.

Bereavement Leave:  3 days of paid leave for the death of an immediate family member, 2 additional days of accrued leave for death of employee’s spouse, domestic partner, parent or child.

Merit Salary Increase:  New employees will receive the starting salary, which is the first step of the salary range.  After employees serve 52 weeks (2080 hours) on each step of the range, they are eligible for a merit increase to the next step.

Educational Reimbursement Program:  Eligible employees may be reimbursed for career-related course work up to a maximum of $850 per fiscal year.  Eligible employees enrolled in an approved four (4) year College or University academic program may be reimbursed up to $800 per semester for a maximum of $1600 per fiscal year.

Parking Supplemental Downtown Stockton:  The County contributes up to $17 per pay period for employees who pay for parking and are assigned to work in the Downtown Core Area.

School Activities:  Employees may take up to 40 hours per year, but not more than eight (8) hours per month, to participate in their children’s school activities.

Note: County employees who currently receive a cafeteria plan allowance and subsequently transfer, demote or promote from or into the Middle Management represented unit which provides for a capped cafeteria plan contribution amount shall receive the capped amount of the Middle Management unit.

 

Civil Service Rule 10 – Section 3 – Eligibility for Promotional Examinations

To compete in a promotional examination, an employee must:

A. Meet the minimum qualifications of the class on or before the final filing date for filing applications.

B. Meet one of the following qualifying service requirements:

1. Have permanent status in the Classified Service.

2. Probationary, part-time, or temporary employees who have worked a minimum of 1040 hours in the previous 12 months or previous calendar year.

3. Exempt employees who have worked a minimum of 2,080 continuous and consecutive hours.

C. Have a rating of satisfactory or better on the last performance evaluation.

D. If a person whose name is on a promotional list is separated (except for layoff) the name shall be removed from the promotional list of the action.  

Employees who meet the minimum qualifications will go through one of the following examination process:

• Written Exam: The civil service written exam is a multiple choice format.  If the written exam is administered alone, it will be 100% of the overall score.  Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list.
  
• Oral Exam:   The oral exam is a structured interview process that will assess the candidate’s education, training, and experience and may include a practical exercise.   The oral exam selection process is not a hiring interview.   A panel of up to four people will determine the candidate’s score and rank for placement on the eligible list.  Top candidates from the eligible list are referred for hiring interviews.  If the oral exam is administered alone, it will be 100% of the overall score.  Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list. 
  
• Written & Oral Exam:  If both a written exam and an oral exam is administered, the written exam is weighted at 60% and the oral exam is weighted at 40% unless otherwise indicated on the announcement.  Candidates must achieve a minimum rating of 70% on each examination in order to be placed on the eligible list.
  
• Rate-out:  A rate-out is an examination that involves a paper rating of the candidate’s application using the following criteria: education, training, and experience. Candidates will not be scheduled for the rate-out process. 

Note:  The rating of 70 referred to may be the same or other than an arithmetic 70% of the total possible points.

Testing Accommodation:  Candidates who require testing accommodation under the Americans with Disabilities Act (ADA) must call Human Resources Division at (209) 468-3370 prior to the examination date.   

Eligible Lists:   Candidates who pass the examination will be placed on an eligible list for that classification.  Eligible lists are effective for nine months, but may be extended by the Human Resources Director for a longer period which shall not exceed a total of three years for the date esblished.  

Certification/Referral: Names from the eligible list will be referred to the hiring department by the following methods.

• Rule of Five:  The top five names will be referred for hiring interviews.  This applies only to department or countywide promotional examination.

Physical Exam:  Some classifications require physical examinations. Final appointment cannot be made until the eligible has passed the physical examination. The County pays for physical examinations administered in its medical facilities.

Employment of Relatives: Applicants who are relatives of employees in a department within the 3rd degree of relationship, (parent, child, grand parent, grand child or sibling) either by blood or marriage, may not be appointed, promoted, transferred into or within the department when;

·         They are related to the Appointing Authority or

·         The employment would result in one of them supervising the work of the other.

Department Head may establish additional limitations on the hiring of relatives by departmental rule.

Apply Online:       

www.sjgov.org/department/hr

By mail or in person:  

San Joaquin County Human Resources

44 N. San Joaquin Street Suite 330

Stockton, CA 95202                                  

 

Office hours:               
Monday – Friday 8:00 am to 5:00 pm; excluding holidays.

Phone:  (209) 468-3370 

 

Job Line:

For current employment opportunities please call our 24-hour job line at (209) 468-3377. 

When a final filing date is indicated, applications must be filed with the Human Resources Division before 5:00 p.m. or postmarked by the final filing date. Resumes will not be accepted in lieu of an application. Applications sent through county inter-office mail, which are not received by the final filing date, will not be accepted. (The County assumes no responsibility for mailed applications which are not received by the Human Resources Division).  

San Joaquin County Substance Abuse Policy: San Joaquin County has adopted a Substance Abuse Policy in compliance with the Federal Drug Free Workplace Act of 1988. This policy is enforced by all San Joaquin County Departments and applies to all San Joaquin County employees.

Equal Opportunity Employer:  San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation.  For more information go to www.sjgov.org/department/hr/eeo.