Business Process Analyst II - System Reporting - County of Riverside
Riverside, CA 92501
About the Job
The County of Riverside's System Reporting Unit at Riverside University Health System's Behavioral Health Department is seeking several Business Process Analyst II for the System Reporting Divisions in Riverside.
The selected candidates will be responsible for querying data related to services, programs, and client detail using Power BI, WinSQL, Microsoft SQL, Crystal Reports, Advanced Excel, and MS Access, submitting various state reporting requirements and services billable/claimable to Medi-Cal/Medicare/VA/Commercial insurance, testing quarterly updates and changes prior to installation, improving system functionality, providing analysis and detailed reports as required by contractual agreements, reviewing and evaluating existing County business process models to identify potential areas for automation and streamlining and develop recommendations for new or modified processes.
Desired Qualifications:
- Advanced Analytical skills.
- Ability to multi-task and prioritize projects.
- Professional experience using Microsoft Access, Crystal Reports, Power BI, SQL, and JavaScript.
Meet the Team!
Behavioral Health Department Website
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.
Knowledge of: Principles and practices of enterprise functions; project specifications development; application design; data modeling techniques; application of industry/corporate standards and conventions for systems analysis and quality assurance; installation, testing and migration process and techniques; quality and version control processes; the use of packaged, off-the-shelf and third party application software, including office automation tools; public assistance programs and C-IV application maintenance for positions within the Department of Public Social Services.
Ability to: Write/modify technical and user documentation; prepare flow process diagrams and other design graphics; use basic principles and practices and functional activities for the maintenance and enhancement of enterprise systems components; gather and analyze data; reason logically, draw valid conclusions and make appropriate recommendations; speak and write effectively; read, interpret and apply laws, rules, regulations, standards, and procedures; establish and maintain effective working relationships with others and gain their cooperation.
SUPPLEMENTAL INFORMATION
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). If you are a qualified individual and need a reasonable accommodation to take this exam, contact the recruiter before taking the exam. For additional information and the accommodation form, visit the Disability Access Office web page at: http://dao.rc-hr.com
Veteran's Preference:
The County has a Veteran's Preference Policy. 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. See the policy here . ( Download PDF reader ).
Pre-Employment
All employment offers are contingent upon successful completion of both a pre-employment physical exam, including a drug/alcohol test, and a criminal background investigation, which involves fingerprinting. (A felony or misdemeanor conviction may disqualify the applicant from County employment).
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.
What's Next?
This recruitment is open to all applicants. Applicants who are current County of Riverside employees and/or current employees of The Riverside University Health System - Behavioral Health Department may be considered before other applicants depending on the volume of applications received.
Application Period
BASED ON THE NUMBER OF APPLICATIONS RECEIVED, THIS POSTING MAY CLOSE WITHOUT NOTICE.
Applications received prior to the closing date will be considered based on the information submitted. Changes or alterations cannot be accepted. All applicants must submit a complete application by the closing date of this recruitment. No late applications will be permitted.
Include relevant work experience details on resume and/or application.
Applicants who fail to provide information demonstrating they possess the position requirements may not be considered further in the application process. A description of job duties directly copied from the job classification or job posting will not be considered.
Upload a copy of any license(s), official/unofficial transcript(s), degrees, and/or related employment documents to your NeoGov account. 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 ( NACES ) or Association of International Credential Evaluators, Inc. ( AICE ).
For questions regarding this recruitment contact the recruiter, Jeremy Holforty:
jholfort@rivco.org / 951-955-5558.
GENERAL APPLICATION INFORMATION:
Please read and follow any special application instructions on this posting. Click the 'Apply' link located on this page to submit your application. For instructions on the application process, examinations, Veteran's preference, pre-employment accommodation or other employment questions, please refer to our web site, www.rc-hr.com . A pre-employment physical examination and background check may be required.
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 here .
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. As of July 1, 2020, the employee contribution is 7.25% and subject to change annually.
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 retirement@rivco.org 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.