County of Riverside in
Business Process Analyst II - System Reporting
County of Riverside in, Riverside, California, United States, 92504
Overview
Business Process Analyst II - System Reporting (Finance) 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 candidate will focus on a designated area (e.g., billing, fiscal reporting, or operations reporting) and develop a deep understanding of the department's business process flow to ensure accurate and timely production of required reports. They will use their expertise in MS SQL and WinSQL coding, and tools such as PowerBI, Crystal Reporting, MS Access, and MS Excel to create, modify, and repair reports and dashboards. They will create complex queries and build or adjust PowerBI dashboards and tables within the stated applications and communicate findings clearly to various audiences. Adaptability to short turnaround times for ad-hoc reports and projects is expected.
Responsibilities Responsibilities include:
Develop and maintain reports and dashboards using MS SQL/WinSQL, PowerBI, Crystal Reporting, MS Access, and MS Excel.
Create and modify complex queries; build or adjust PowerBI dashboards and tables within stated applications.
Work with cross-functional teams and communicate findings clearly to all audiences.
Meet tight deadlines for ad-hoc reports and projects.
Qualifications 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 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.
Team and Additional Information Meet the Team:
Conduct system analysis and design of business processes; evaluate current and proposed information technology; provide cost and benefits analysis.
Develop and document user requirements for new and existing systems, processes, and applications; prepare project documents, requirements, reports, feasibility studies, and QA for controls standards.
Select and recommend software based on systems analysis and evaluation; create RFPs or requirement specifications.
Serve as a business process resource for enterprise system support, maintenance, enhancements, and upgrades; provide functional support and design specifications to programming staff.
Coordinate design and evaluation of business processes for implementation of enterprise systems and upgrades; test changes prior to final implementation.
Identify and implement automated business processes; analyze requirements and develop design specifications for new or modified processes.
Coordinate with departments on new/changed local ordinances, labor agreements, legislation, reporting, and regulations.
Design, implement, and maintain system setup tables and parameters to ensure regulatory compliance; interpret new or updated regulations to identify required system changes.
Identify and resolve production issues; collaborate with vendors for resolution of underlying system problems; search corporate resources for fixes.
Coordinate system security and network security and installation requirements.
Maintain context-sensitive online help to reflect current system structure.
Education and Experience 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. Additional qualifying experience in a functional support area may substitute for education on a 30 semester/45 quarter unit basis (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.
Licensing:
Valid California driver's license and auto insurance are required for driving during work hours.
#J-18808-Ljbffr
Business Process Analyst II - System Reporting (Finance) 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 candidate will focus on a designated area (e.g., billing, fiscal reporting, or operations reporting) and develop a deep understanding of the department's business process flow to ensure accurate and timely production of required reports. They will use their expertise in MS SQL and WinSQL coding, and tools such as PowerBI, Crystal Reporting, MS Access, and MS Excel to create, modify, and repair reports and dashboards. They will create complex queries and build or adjust PowerBI dashboards and tables within the stated applications and communicate findings clearly to various audiences. Adaptability to short turnaround times for ad-hoc reports and projects is expected.
Responsibilities Responsibilities include:
Develop and maintain reports and dashboards using MS SQL/WinSQL, PowerBI, Crystal Reporting, MS Access, and MS Excel.
Create and modify complex queries; build or adjust PowerBI dashboards and tables within stated applications.
Work with cross-functional teams and communicate findings clearly to all audiences.
Meet tight deadlines for ad-hoc reports and projects.
Qualifications 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 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.
Team and Additional Information Meet the Team:
Conduct system analysis and design of business processes; evaluate current and proposed information technology; provide cost and benefits analysis.
Develop and document user requirements for new and existing systems, processes, and applications; prepare project documents, requirements, reports, feasibility studies, and QA for controls standards.
Select and recommend software based on systems analysis and evaluation; create RFPs or requirement specifications.
Serve as a business process resource for enterprise system support, maintenance, enhancements, and upgrades; provide functional support and design specifications to programming staff.
Coordinate design and evaluation of business processes for implementation of enterprise systems and upgrades; test changes prior to final implementation.
Identify and implement automated business processes; analyze requirements and develop design specifications for new or modified processes.
Coordinate with departments on new/changed local ordinances, labor agreements, legislation, reporting, and regulations.
Design, implement, and maintain system setup tables and parameters to ensure regulatory compliance; interpret new or updated regulations to identify required system changes.
Identify and resolve production issues; collaborate with vendors for resolution of underlying system problems; search corporate resources for fixes.
Coordinate system security and network security and installation requirements.
Maintain context-sensitive online help to reflect current system structure.
Education and Experience 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. Additional qualifying experience in a functional support area may substitute for education on a 30 semester/45 quarter unit basis (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.
Licensing:
Valid California driver's license and auto insurance are required for driving during work hours.
#J-18808-Ljbffr