Business Process Analyst II

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

Valid California driver's license and auto insurance are required for driving during work hours.
SUPPLEMENTAL INFORMATION
________________________________________________________________________________________

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: https://rc-

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 ( NACES ) or Association of International Credential Evaluators, Inc. ( AICE ).

Work Authorization Requirement
Applicants must be legally authorized to work in the United States at the time of application. The County of Riverside does not participate in visa sponsorship programs, including H1-B visas, and will not provide sponsorship for any employment-based visas.

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 applicant support desk Monday through Friday, 6 am to 5 pm Pacific Time at or toll-free