s

Business Analyst II

sjgov
Full-time
On-site
Stockton, United States

Introduction



This examination is being given to fill one vacancy in the Health Care Services (Behavioral Health Services) 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.


Pre-Employment Drug Screening and Background:Β  Potential new hires into this classification are required to successfully pass a pre-employment drug screen and a background investigation as a condition of employment. Final appointment cannot be made unless the eligible has passed the drug screen and successfully completed the background process.Β  The County pays for the initial drug screen.


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.


Β 



TYPICAL DUTIES




  • Leads, conducts, and participates in the collection, identification, and analysis of business cycle information, including key performance indicators; designs complex data tools and system queries; ensures the correct selection, analysis and interpretation of data and the identification of business trends.

  • 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.

  • Prepares 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.

  • Designs and develops solution testing plans, strategies and quality management tools; reviews solution defects and makes strategy adjustments as needed.

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

  • Helps monitor and maintain the quality and integrity of data stored in and/or processed through core business applications and databases; maintains data tables and references; downloads/uploads data sets; identifies opportunities for improving databases, data sets, and reports utilized by the department and recommends changes as appropriate.

  • 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.

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

  • 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.

  • Assists in the development of capital and operational budgets by analyzing budget variances, providing explanations as to why they occurred, and providing recommendations as needed.

  • Develops and recommends policy statements for management approval.

  • Confers with representatives of other agencies or departments; coordinates projects; serves as liaison between departments.

  • May supervise clerical or technical employees if assigned as an ancillary, but not preponderant, duty.



MINIMUM QUALIFICATIONS



EITHER PATTERN I

Experience: Two years as a Business Analyst I 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: Two 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.


KNOWLEDGE



Principles and practices of business analysis including planning and monitoring, elicitation, requirements management and communication, enterprise analysis, requirements analysis, and solution assessment and validation; theories, principles, and methods related to the business intelligence life cycle including the identification of key performance indicators, predictive modeling and data mining; quantitative data analytics techniques and procedures associated with 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.


ABILITY



Identify key business performance data and indicators, based on departmental 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.


PHYSICAL/MENTAL REQUIREMENTS



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 complies with the Americans with Disabilities Act (ADA) and, upon request, will consider reasonable accommodations to enable individuals with disabilities to perform essential job functions.


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 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.



BENEFITS




Health Insurance: The County provides part time employees eligible for benefits with a choice of one of three health insurance plans at no cost to the employee. Dependent coverage is available for all plans, with employee paying a portion of the premium.Β  The three plans are: (1) a Kaiser Plan; (2) a Select Plan; and (3) a Premier Plan


Dental Insurance: The County provides employees an option for dental insurance coverage for eligible employees and dependants in either the Delta Dental or theΒ United Health Care-Select Managed Care Direct CompensationΒ plan at no cost to the employee. Dependent coverage is available at the employee’s expense


Vision Insurance: Under the Vision Service Plan (VSP), coverage for the employee is available at no cost to the employee. Dependent coverage is available at the employee’s expense


Pay differential for benefits: Part time employees eligible for benefits receive a two (2) percent differential


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


Employee may purchase additional term life insurance up to a maximum of $100,000 at the County's rate.


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)


Deferred Compensation: The County maintains 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


Vacation: Vacation is pro-rated based on hours worked.Β  Employees earn .0577 hours based on each hour worked.Β  Vacation accrual increases based on length of service


Holiday: 14 holidays per year which includes 4 floating holidays if the employee is normally scheduled to work the day of the holiday


Β·Β Β Β Β Β Β Β Β  Regular holiday: when an employee works on a regular holiday (non-floating), employee receives regular pay plus holiday pay or time off at time and one half


Β·Β Β Β Β Β Β Β Β  Floating holiday: employees who work on a floating holiday earn time off to be taken at a later date


Educational Leave:Β  Each fiscal year, department heads grant 24 hours to part time employees eligible for benefits of educational leave that are not carried beyond the end of the fiscal year


Sick Leave: Part time employees eligible for benefits accrue .0462 hours of sick leave for each straight-time hour on payroll 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 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 1840 hours on each step of the range, they are eligible for a merit increase to the next step


License/Certificate Fees:Β  The County provides reimbursement for specific classifications under the Registered Nurses Memorandum of Understanding for fees required to renew State required license/certification.Β  Fees associated with initial license/certification will not be covered


Job Sharing:Β  Employees may agree to job-share a position, subject to approval by a Department Head and the Director of Human Resources


Educational Reimbursement Program:Β  The County offers an Educational Reimbursement Program which reimburses the part time employees eligible for benefits up to $450 per fiscal year and up to $900 per fiscal year for enrollment in an approved degree program


Parking Supplemental Downtown Stockton:Β  The County contributes up to $17.00 per pay period for employees 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


Social Security: Part time employees are covered by Social Security with the employee and the County sharing the cost


Β 



Selection Procedures



Applicants for part-time and temporary recruitments who meet the minimum qualifications are either referred to the hiring department for further selection or they may be required to take a written examination.Β  If a written examination is given, the top candidates may be referred to the hiring department for further selection.


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.Β 


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.


Pre-employment Drug Screening Exam:Β  Some classifications require a new employee successfully pass a pre-employment drug screen as a condition of employment.Β  Final appointment cannot be made until the eligible has passed the drug screen.Β  The County pays for the initial drug screen.


Β 


Employment of Relatives: Applicants who are relatives of employees in a department within the 3rd degree of relationship, (parent, child, grandparent, grandchild 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 Heads may establish additional limitations on the hiring of relatives by departmental rule.


Proof of Eligibility:Β  If you are offered a job, you will be required to provide proof of U.S. citizenship or other documents that establish your eligibility to be employed in the U.S.



HOW TO APPLY



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.