Business Process Analyst II - System Reporting

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