Business Process Analyst II - System Reporting
Apply NowCompany: Riverside County, CA
Location: Riverside, CA 92503
Description:
Salary : $86,496.27 - $117,045.63 Annually
Location : Riverside
Job Type: Regular
Remote Employment: Flexible/Hybrid
Job Number: 25-86111-JE
Department: Behavioral Health
Division: System Reporting
Opening Date: 03/06/2025
Closing Date: 3/23/2025 11:59 PM Pacific
Max Number of Applicants: 100
ABOUT THE POSITION
The County of Riverside's System Reporting Unit at Riverside University Health System's Behavioral Health Department seeks a Business Process Analyst II for the System Reporting Divisions in Riverside.
The selected candidates will be responsible for focusing on a designated area, such as billing, fiscal reporting, or operations reporting. They will develop a deep understanding of the department's business process flow to their area of focus to ensure accurate and timely production of required reports. The candidate will use their expertise in MS SQL and WinSQL coding, as well as tools like PowerBI, Crystal Reporting, MS Access, and MS Excel, to create, modify, and repair reports and dashboards. They will be expected to create complex queries and build or adjust PowerBI dashboards and tables within the stated applications. Additionally, the candidate must be comfortable using advanced Excel features, including creating spreadsheets with complex formulas independently. They will collaborate with various teams across the organization, communicate findings clearly to all audiences, and be adaptable to short turnaround times for ad-hoc reports and projects.
Desired Qualifications:
Schedule:
9/80 Friday - Day Shift (Remote work may be an option, depending on training requirements/completion, and will be at the department's discretion).
Meet the Team!
EXAMPLES OF ESSENTIAL DUTIES
Conduct system analysis and design of business process involving evaluation of current and proposed information; determine available and emerging technology hardware and software; provide cost and benefits analysis.
Develop and document user requirements for new and existing systems, processes, and applications; prepare and maintain project documents, requirements, reports, feasibility studies, and quality assurance for controls standards.
Select and recommend software based on systems analysis, evaluation of products, and vendors; create requests for proposals (RFPs) or requirement specifications.
Serve as business process resource on all matters involving the support, maintenance, enhancement, and upgrade of the County's integrated enterprise systems; provides functional support, analysis, and design specifications, as needed, to programming staff.
Coordinate and participate in the design and evaluation of business processes required for the implementation of enterprise systems and upgrades; analyzes new components to determine if previously modified processes can be eliminated and/or if new release will also require modification; conduct system testing to ensure that the new release provides the expected results throughout the business cycle.
Evaluate requirements and develops design specifications for new or modified business processes; evaluate existing county business process models to identify potential areas for automation and streamlining; designs and implements resulting automated processes.
Analyze labor relations proposals during the County's negotiation process and state and federal legislation to evaluate the ability to implement needed system changes; design alternative, comparable counter-proposals needed for system compatibility.
Coordinate with business process managers and departmental staff to adopt system changes needed for new/modified public programs and services; test all changes prior to final implementation to ensure appropriate results.
Coordinate with user departments on new/changed local ordinances and labor agreements, legislation, reporting, and regulations.
Design, implement, and maintain system set-up tables and parameters to ensure compliance with state and federal requirements; interpret and analyze new or updated regulations to identify needed system changes.
Identify and resolve production problem areas and corrects system set-up when production errors are identified; work directly with vendors for resolution of underlying system program problems; search corporate Web sites for posted resolutions and fixes to resolve identified problems.
Work directly with vendors to resolve underlying system program problems; searches corporate Web sites for posted resolutions and fixes in resolving identified problems.
Coordinate and implement system security; coordinate network security and installation requirements.
Maintain context-sensitive on-line help reference to reflect the most current structure within the system.
MINIMUM QUALIFICATIONS
Education: Graduation from an accredited college or university with a bachelor's degree in public/business administration, human resources, finance, computer science, information systems, or a related field to the assignment. (Additional qualifying experience in a functional support area may substitute for education on the basis of 30 semester or 45 quarter units equaling one year of full-time experience.)Experience: Two years of professional level experience with business systems, information technology, program applications, business processes and procedures, and financial reporting and data, or other accounting experience.
Valid California driver's license and auto insurance are required for driving during work hours.
SUPPLEMENTAL INFORMATION
For questions regarding this recruitment please contact the recruiter, Jill Eastman at
APPLICATION INFORMATION
Veteran's Preference
The County has a Veterans Preference Policy applicable to new hires. To qualify, upload a copy of your (or your spouse's) Member-4 Form DD-214 indicating dates of service, and a copy of your spouse's letter of disability (if applicable) with your application. For privacy reasons, it is recommended that you remove your social security information from the document(s). A Human Resources Representative will review the materials and determine if you qualify for veterans' preference. The Veterans Preference Policy, C-3 is available here:
Reasonable Accommodations
The County of Riverside is committed to providing reasonable accommodation to applicants as required by the Americans with Disabilities Act (ADA) and Fair Employment and Housing Act (FEHA). Qualified individuals with disabilities who need a reasonable accommodation during the application or selection process should contact the recruiter for the position noted above. For additional information and/or to obtain the appropriate form for requesting a reasonable accommodation, please visit the Disability Access Office web page located at:
Proof of Education
If using education to qualify or when requested by the recruiter, upload a copy of any license(s), official/unofficial transcript(s), degrees, and/or related employment documents to your NeoGov account at the time of application and before the closing date. Official or unofficial transcripts will be accepted.
If your education was completed outside of the United States, you will need to provide a copy of your Foreign Education Equivalency evaluation from a member of the National Association of Credential Evaluation Services () or Association of International Credential Evaluators, Inc. ().
Equal Opportunity Employer
The County of Riverside is an Equal Opportunity Employer. It is the policy of the County of Riverside to provide equal employment opportunities for all qualified persons. All applicants will be considered without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, gender, gender identity, gender expression, marital status, ancestry, medical condition (cancer and genetic characteristics), genetic information, or denial of medical and family care leave, or any other non-job-related factors.
Pre-Employment
All employment offers are contingent upon successful completion of pre-employment requirements including a criminal background investigation, which involves fingerprinting. (A felony or misdemeanor conviction may disqualify the applicant from County employment). A pre-employment physical examination and background check may be required.
Probationary Period
As an Approved Local Merit System, all County of Riverside employees, except those serving "At Will," are subject to the probationary period provisions as specified in the applicable Memorandum of Understanding, County Resolution, or Salary Ordinance. Temporary and Per Diem employees serve at the pleasure of the agency/department head.
General Information
Current County of Riverside and/or current employees of the hiring department may receive priority consideration. Qualified candidates may be considered for future County vacancies.
Job postings may close without notice based on application volume. Submit your complete application by the recruitment close date; no late applications are accepted. Ensure all relevant experience/education is reflected on your application/resume, as a failure to demonstrate position requirements may disqualify applicants. A description of job duties directly copied from the job classification or job posting will not be considered.
Please read and follow any special application instructions on this posting. Click the 'Apply' link located on this page to submit your application. For additional instructions on the application process, examinations, Veteran's preference, pre-employment accommodation or other employment questions, please refer to our web site,
If you are experiencing technical problems, you may contact the governmentjobs.com applicant support desk Monday through Friday, 6 am to 5 pm Pacific Time at support@governmentjobs.com or toll-free 1-855-524-5627.
MEDICAL/DENTAL/VISION INSURANCE: A choice of different medical, dental and visions plan are available to elect. The County provides a Flexible Benefit Credit contribution as governed by the applicable SEIU Memorandum of Understanding to contribute towards the cost of these plans.
Note: Employees on assignment through the Temporary Assignment Program (TAP) receive different benefits. See the list
MISCELLANEOUS RETIREMENT: County of Riverside has three retirement Tiers through the California Public Employees' Retirement System (CalPERS).
A new member is defined as any of the following:
A new hire who enters CalPERS membership for the first time on or after January 1, 2013, and who has no prior membership in any California Public Retirement System. A new hire who enters CalPERS membership for the first time on or after January 1, 2013, and who was a member with another California Public Retirement System prior to that date, but who is not subject to reciprocity upon joining CalPERS. A member who first established CalPERS membership prior to January 1, 2013, and who is rehired by a different CalPERS agency after a break in service of greater than six (6) months.
CalPERS refers to all members that do not fit within the definition of a new member as "classic members".
Contribution rates are subject to change based on the County of Riverside annual actuarial valuation.
Note:
This summary is for general information purposes only. Additional questions regarding retirement formulas can be sent to or by calling the Benefits Information Line at (951) 955-4981,
Option 2.
If you have prior service credit with another CalPERS agency or within agencies, please contact CalPERS at (888) 225-7377 to determine which retirement tier would be applicable to you. CalPERS is governed by the Public Employees' Retirement Law. The Retirement Law is complex and subject to change. If there's any conflict between this summary and the law, the law will prevail over this summary.
DEFERRED COMPENSATION: Voluntary employee contribution with a choice between two 457 deferred compensation plan options.
VACATION ACCRUAL (Bi-Weekly Accrual):
0 < 3 year = 80 Hours (10 Days)
4 < 9 years = 120 Hours (15 Days)
10 or more years = 160 Hours (20 Days)
Maximum Vacation leave accumulation is 480 hours.
SICK LEAVE: Four (4) hours Sick Leave accrual per pay period with unlimited accrual.
HOLIDAYS: Normally 12 paid holidays per year.
BEREAVEMENT LEAVE: Allowed 5 days (3 days are County paid; 2 additional days can be taken from accrued Sick Leave balance).
BASIC LIFE INSURANCE: Equal to one times annual base salary not to exceed $50,000 of term life coverage. Premiums are paid by the County. Additional Supplemental Life plan is available for employee purchase.
DISABILITY: Short-term Disability benefit pays up to a maximum of $461.54 weekly, payable up to a maximum of 52 weeks.
POST RETIREMENT MEDICAL CONTRIBUTION: A monthly contribution is made by the County towards retiree health insurance offered through the County as governed by the applicable SEIU Memorandum of Understanding.
OTHER: There may be other benefit provisions as specified in the applicable Memorandum of Understanding. Please contact the recruiter listed on the job posting directly for more information.
01
I understand that my resume needs to support the answers provided to the screening questions, or I may not be considered further in the selection process.
02
Do you currently hold a valid California driver's license and maintain auto insurance?
03
What is your highest level of education from an accredited college or university in public/business administration, human resources, finance, computer science, information systems, or a related field?
04
How many years of professional level work experience do you have with business systems, information technology, program applications, business processes and procedures, and financial reporting and data, or other accounting experience.
05
How many years of experience do you have working under tight deadlines and managing short turnaround times for ad-hoc reports and projects?
06
How many years of experience do you have creating and modifying queries as needed?
07
How many years of experience do you have building, modifying, and repairing PowerBI dashboards and tables within applications?
08
How many years of professional work experience do you have with Crystal Reports?
09
How many years of experience do you have working with MS SQL and WinSQL coding?
10
Are you a current or temporary County of Riverside employee with the Riverside University Health System - Behavioral Health department?
Required Question
Location : Riverside
Job Type: Regular
Remote Employment: Flexible/Hybrid
Job Number: 25-86111-JE
Department: Behavioral Health
Division: System Reporting
Opening Date: 03/06/2025
Closing Date: 3/23/2025 11:59 PM Pacific
Max Number of Applicants: 100
ABOUT THE POSITION
The County of Riverside's System Reporting Unit at Riverside University Health System's Behavioral Health Department seeks a Business Process Analyst II for the System Reporting Divisions in Riverside.
The selected candidates will be responsible for focusing on a designated area, such as billing, fiscal reporting, or operations reporting. They will develop a deep understanding of the department's business process flow to their area of focus to ensure accurate and timely production of required reports. The candidate will use their expertise in MS SQL and WinSQL coding, as well as tools like PowerBI, Crystal Reporting, MS Access, and MS Excel, to create, modify, and repair reports and dashboards. They will be expected to create complex queries and build or adjust PowerBI dashboards and tables within the stated applications. Additionally, the candidate must be comfortable using advanced Excel features, including creating spreadsheets with complex formulas independently. They will collaborate with various teams across the organization, communicate findings clearly to all audiences, and be adaptable to short turnaround times for ad-hoc reports and projects.
Desired Qualifications:
- Proficiency in MS SQL and WinSQL coding
- Experience with PowerBI, Crystal Reporting, MS SQL, WinSQL, MS Access, and MS Excel
- Ability to create and modify queries as needed
- Experience building, modifying, and repairing PowerBI dashboards and tables within stated applications
- Mid-level experience with Excel, including the ability to create spreadsheets with complex formulas independently
- Strong communication skills, with the ability to present findings to all audiences
- Ability to work under tight deadlines and manage short turnaround times for ad-hoc reports and projects
Schedule:
9/80 Friday - Day Shift (Remote work may be an option, depending on training requirements/completion, and will be at the department's discretion).
Meet the Team!
EXAMPLES OF ESSENTIAL DUTIES
Conduct system analysis and design of business process involving evaluation of current and proposed information; determine available and emerging technology hardware and software; provide cost and benefits analysis.
Develop and document user requirements for new and existing systems, processes, and applications; prepare and maintain project documents, requirements, reports, feasibility studies, and quality assurance for controls standards.
Select and recommend software based on systems analysis, evaluation of products, and vendors; create requests for proposals (RFPs) or requirement specifications.
Serve as business process resource on all matters involving the support, maintenance, enhancement, and upgrade of the County's integrated enterprise systems; provides functional support, analysis, and design specifications, as needed, to programming staff.
Coordinate and participate in the design and evaluation of business processes required for the implementation of enterprise systems and upgrades; analyzes new components to determine if previously modified processes can be eliminated and/or if new release will also require modification; conduct system testing to ensure that the new release provides the expected results throughout the business cycle.
Evaluate requirements and develops design specifications for new or modified business processes; evaluate existing county business process models to identify potential areas for automation and streamlining; designs and implements resulting automated processes.
Analyze labor relations proposals during the County's negotiation process and state and federal legislation to evaluate the ability to implement needed system changes; design alternative, comparable counter-proposals needed for system compatibility.
Coordinate with business process managers and departmental staff to adopt system changes needed for new/modified public programs and services; test all changes prior to final implementation to ensure appropriate results.
Coordinate with user departments on new/changed local ordinances and labor agreements, legislation, reporting, and regulations.
Design, implement, and maintain system set-up tables and parameters to ensure compliance with state and federal requirements; interpret and analyze new or updated regulations to identify needed system changes.
Identify and resolve production problem areas and corrects system set-up when production errors are identified; work directly with vendors for resolution of underlying system program problems; search corporate Web sites for posted resolutions and fixes to resolve identified problems.
Work directly with vendors to resolve underlying system program problems; searches corporate Web sites for posted resolutions and fixes in resolving identified problems.
Coordinate and implement system security; coordinate network security and installation requirements.
Maintain context-sensitive on-line help reference to reflect the most current structure within the system.
MINIMUM QUALIFICATIONS
Education: Graduation from an accredited college or university with a bachelor's degree in public/business administration, human resources, finance, computer science, information systems, or a related field to the assignment. (Additional qualifying experience in a functional support area may substitute for education on the basis of 30 semester or 45 quarter units equaling one year of full-time experience.)Experience: Two years of professional level experience with business systems, information technology, program applications, business processes and procedures, and financial reporting and data, or other accounting experience.
Valid California driver's license and auto insurance are required for driving during work hours.
SUPPLEMENTAL INFORMATION
For questions regarding this recruitment please contact the recruiter, Jill Eastman at
APPLICATION INFORMATION
Veteran's Preference
The County has a Veterans Preference Policy applicable to new hires. To qualify, upload a copy of your (or your spouse's) Member-4 Form DD-214 indicating dates of service, and a copy of your spouse's letter of disability (if applicable) with your application. For privacy reasons, it is recommended that you remove your social security information from the document(s). A Human Resources Representative will review the materials and determine if you qualify for veterans' preference. The Veterans Preference Policy, C-3 is available here:
Reasonable Accommodations
The County of Riverside is committed to providing reasonable accommodation to applicants as required by the Americans with Disabilities Act (ADA) and Fair Employment and Housing Act (FEHA). Qualified individuals with disabilities who need a reasonable accommodation during the application or selection process should contact the recruiter for the position noted above. For additional information and/or to obtain the appropriate form for requesting a reasonable accommodation, please visit the Disability Access Office web page located at:
Proof of Education
If using education to qualify or when requested by the recruiter, upload a copy of any license(s), official/unofficial transcript(s), degrees, and/or related employment documents to your NeoGov account at the time of application and before the closing date. Official or unofficial transcripts will be accepted.
If your education was completed outside of the United States, you will need to provide a copy of your Foreign Education Equivalency evaluation from a member of the National Association of Credential Evaluation Services () or Association of International Credential Evaluators, Inc. ().
Equal Opportunity Employer
The County of Riverside is an Equal Opportunity Employer. It is the policy of the County of Riverside to provide equal employment opportunities for all qualified persons. All applicants will be considered without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, gender, gender identity, gender expression, marital status, ancestry, medical condition (cancer and genetic characteristics), genetic information, or denial of medical and family care leave, or any other non-job-related factors.
Pre-Employment
All employment offers are contingent upon successful completion of pre-employment requirements including a criminal background investigation, which involves fingerprinting. (A felony or misdemeanor conviction may disqualify the applicant from County employment). A pre-employment physical examination and background check may be required.
Probationary Period
As an Approved Local Merit System, all County of Riverside employees, except those serving "At Will," are subject to the probationary period provisions as specified in the applicable Memorandum of Understanding, County Resolution, or Salary Ordinance. Temporary and Per Diem employees serve at the pleasure of the agency/department head.
General Information
Current County of Riverside and/or current employees of the hiring department may receive priority consideration. Qualified candidates may be considered for future County vacancies.
Job postings may close without notice based on application volume. Submit your complete application by the recruitment close date; no late applications are accepted. Ensure all relevant experience/education is reflected on your application/resume, as a failure to demonstrate position requirements may disqualify applicants. A description of job duties directly copied from the job classification or job posting will not be considered.
Please read and follow any special application instructions on this posting. Click the 'Apply' link located on this page to submit your application. For additional instructions on the application process, examinations, Veteran's preference, pre-employment accommodation or other employment questions, please refer to our web site,
If you are experiencing technical problems, you may contact the governmentjobs.com applicant support desk Monday through Friday, 6 am to 5 pm Pacific Time at support@governmentjobs.com or toll-free 1-855-524-5627.
MEDICAL/DENTAL/VISION INSURANCE: A choice of different medical, dental and visions plan are available to elect. The County provides a Flexible Benefit Credit contribution as governed by the applicable SEIU Memorandum of Understanding to contribute towards the cost of these plans.
Note: Employees on assignment through the Temporary Assignment Program (TAP) receive different benefits. See the list
MISCELLANEOUS RETIREMENT: County of Riverside has three retirement Tiers through the California Public Employees' Retirement System (CalPERS).
- Tier I (Classic Member - Formula 3% @ 60): Applicable to current and former County of Riverside local miscellaneous employees hired prior to 08/24/2012 and did not withdraw CalPERS contributions. The employee contribution is eight (8%) percent.
- Tier II (Classic Member - Formula 2% @ 60): Applicable to local miscellaneous employees 1) hired after 08/23/2012 through 12/31/2012; 2) Previously employed with another CalPERS contracting public agency or a reciprocal retirement system, with a break in service of less than six months between the separation date with the previous employer and the appointment date with the County of Riverside. The employee contribution is seven (7%) percent.
- Tier III (PEPRA New Member - Formula 2% @ 62): Applicable to CalPERS local miscellaneous new members hired on or after the implementation of the Public Employees' Pension Reform Act of 2013 (PEPRA) which took effect January 1, 2013. Effective July 1, 2023 employee contributions are 7.25% and will increase to 7.75% effective July 1, 2024.
A new member is defined as any of the following:
CalPERS refers to all members that do not fit within the definition of a new member as "classic members".
Contribution rates are subject to change based on the County of Riverside annual actuarial valuation.
Note:
This summary is for general information purposes only. Additional questions regarding retirement formulas can be sent to or by calling the Benefits Information Line at (951) 955-4981,
Option 2.
If you have prior service credit with another CalPERS agency or within agencies, please contact CalPERS at (888) 225-7377 to determine which retirement tier would be applicable to you. CalPERS is governed by the Public Employees' Retirement Law. The Retirement Law is complex and subject to change. If there's any conflict between this summary and the law, the law will prevail over this summary.
DEFERRED COMPENSATION: Voluntary employee contribution with a choice between two 457 deferred compensation plan options.
VACATION ACCRUAL (Bi-Weekly Accrual):
0 < 3 year = 80 Hours (10 Days)
4 < 9 years = 120 Hours (15 Days)
10 or more years = 160 Hours (20 Days)
Maximum Vacation leave accumulation is 480 hours.
SICK LEAVE: Four (4) hours Sick Leave accrual per pay period with unlimited accrual.
HOLIDAYS: Normally 12 paid holidays per year.
BEREAVEMENT LEAVE: Allowed 5 days (3 days are County paid; 2 additional days can be taken from accrued Sick Leave balance).
BASIC LIFE INSURANCE: Equal to one times annual base salary not to exceed $50,000 of term life coverage. Premiums are paid by the County. Additional Supplemental Life plan is available for employee purchase.
DISABILITY: Short-term Disability benefit pays up to a maximum of $461.54 weekly, payable up to a maximum of 52 weeks.
POST RETIREMENT MEDICAL CONTRIBUTION: A monthly contribution is made by the County towards retiree health insurance offered through the County as governed by the applicable SEIU Memorandum of Understanding.
OTHER: There may be other benefit provisions as specified in the applicable Memorandum of Understanding. Please contact the recruiter listed on the job posting directly for more information.
01
I understand that my resume needs to support the answers provided to the screening questions, or I may not be considered further in the selection process.
- Yes
- No
02
Do you currently hold a valid California driver's license and maintain auto insurance?
- Yes
- No
03
What is your highest level of education from an accredited college or university in public/business administration, human resources, finance, computer science, information systems, or a related field?
- Less than 12 semester or 18 quarter units
- At least 12 semester or 18 quarter units
- At least 24 semester or 36 quarter units
- At least 30 semester or 45 quarter units
- At least 60 semester or 90 quarter units
- At least 90 semester or 135 quarter units
- At least 120 semester or 180 quarter units
- I have my Associate's degree
- I have my Bachelor's degree
- I have my Master's degree
- I have my Doctorate degree
- None of these apply
04
How many years of professional level work experience do you have with business systems, information technology, program applications, business processes and procedures, and financial reporting and data, or other accounting experience.
- None
- Less than 12 months
- 1 year or more, but less than 2
- 2 years or more, but less than 3
- 3 years or more, but less than 4
- 4 years or more, but less than 5
- 5 years or more, but less than 6
- 6 years or more
05
How many years of experience do you have working under tight deadlines and managing short turnaround times for ad-hoc reports and projects?
- None
- Less than 12 months
- 1 year or more, but less than 2
- 2 years or more, but less than 3
- 3 years or more, but less than 4
- 4 years or more, but less than 5
- 5 years or more, but less than 6
- 6 years or more
06
How many years of experience do you have creating and modifying queries as needed?
- None
- Less than 12 months
- 1 year or more, but less than 2
- 2 years or more, but less than 3
- 3 years or more, but less than 4
- 4 years or more, but less than 5
- 5 years or more, but less than 6
- 6 years or more
07
How many years of experience do you have building, modifying, and repairing PowerBI dashboards and tables within applications?
- None
- Less than 12 months
- 1 year or more, but less than 2
- 2 years or more, but less than 3
- 3 years or more, but less than 4
- 4 years or more, but less than 5
- 5 years or more, but less than 6
- 6 years or more
08
How many years of professional work experience do you have with Crystal Reports?
- None
- Less than 12 months
- 1 year or more, but less than 2
- 2 years or more, but less than 3
- 3 years or more, but less than 4
- 4 years or more, but less than 5
- 5 years or more, but less than 6
- 6 years or more
09
How many years of experience do you have working with MS SQL and WinSQL coding?
- None
- Less than 12 months
- 1 year or more, but less than 2
- 2 years or more, but less than 3
- 3 years or more, but less than 4
- 4 years or more, but less than 5
- 5 years or more, but less than 6
- 6 years or more
10
Are you a current or temporary County of Riverside employee with the Riverside University Health System - Behavioral Health department?
- Yes
- No
Required Question