IT Business Systems Analyst II - Sheriff's Office - County of Riverside
Riverside, CA 92501
About the Job
The Riverside County Sheriff's Office is seeking an IT Business Systems Analyst II to fill a vacancy within their Technical Services Bureau in Riverside. This position will be in-office; no telework will be available.
As an IT Business Systems Analyst II, the incumbent willbe tasked with application support and development on the Systems Analysis Group, while also possessing the expertise to create comprehensive and insightful reports. Other duties may include: testing, debugging, and maintaining applications to ensure optimal performance and usability; managing user permissions and access levels based on established security protocols; working closely with stakeholders to understand reporting requirements and translate them into effective reports; creating visually appealing and easy-to-understand dashboards and reports using relevant tools or languages; optimizing queries and data retrieval processes to enhance report generation efficiency.
Competitive applicants will possess:
- Proficient experience working with databases, such as MS Access or SQL.
- Experience creating and designing reports with Power BI, SQL Server Reporting Services (SSRS) or similar tools.
- Experience with front end and back end programming languages, such as .NET, JavaScript, ReactJS, C#, JSON, and/or C++.
- Proficiency in SharePoint frameworks and development tools.
- Experience with installation, testing, and migration processes and techniques.
- Experience with the use of packaged or off-the-shelf and third party application software, including office automation tools.
- Experience in a law enforcement agency or a related field.
Meet the Team!
The law enforcement professionals of the Riverside County Sheriff's Office , with a staff of over 3,600 dedicated men and women, cover the expanse of over 7,300 square miles in southern California. The Sheriff's Office is dedicated to serving the citizens of its communities with integrity, professionalism, leadership, and loyalty and believes in service above self.
Who May Apply
This recruitment is open to all applicants. Current employees of the County of Riverside and/or the Riverside County Sheriff's Office may be considered before other applicants, depending on the volume of applications received.
EXAMPLES OF ESSENTIAL DUTIES
• Conduct systems analysis and design of business processes involving evaluation of current and proposed information and business process flow, available and emerging technology hardware and software, and cost/benefits.
• Analyze projects; document new organizational processes; generate reports for management on new technology.
• Develop and document user requirements from end-user input for new and/or existing systems, business processes, and applications.
• Develop enhancements and modifications to existing software programs using programming language, such as C# and other tools.
• Design and develop Power BI reports, dashboards, and data visualizations that provide actionable insights.
• Coordinate and communicate with end users, management, staff, and vendors on project issues and status.
• Troubleshoot and resolve application-related problems reported by users. Collaborate with development teams to address bugs and performance issues.
• Understanding of version control systems (e.g., Git) and experience in collaborative coding environments.
• Document troubleshooting steps and resolutions for future reference and knowledge sharing.
• Assist in the testing of new application features and updates. Ensure changes meet quality standards before deployment.
• Utilize strong communication skills to interact effectively with stakeholders and translate requirements into technical solutions.
• Coordinate program and/or system development activities with vendors as required; maintains effective communications with users regarding vendor activities, problems, status, timelines and other details.
• Provide professional support and troubleshooting assistance to customers pertaining to applications-related matters; investigate, troubleshoot, evaluate and resolve application function problems.
• Conduct online, group and/or one-on-one training sessions with application users and/or technology staff in order to provide information on application functions; design and prepare training materials.
MINIMUM QUALIFICATIONS
Education: Completion of 30 semester or 45 quarter units from an accredited college or university, preferably with coursework in computer science, computer information systems, data processing, information management, or a related field to the assignment. (Additional qualifying IT job-related experience may substitute for the required education on the basis of 30 semester or 45 quarter units equaling one year of full-time experience).
Experience: Two years of IT job-related experience, preferably with the County of Riverside.
License: Possession of a valid California Driver's License.
Background Investigation: A successful security clearance background check conducted by the Riverside County Sheriffs' Office is required for this position.
Knowledge of: Database systems and proficiency in working with databases (e.g., SQL, MS Access); SharePoint frameworks and development tools; creating, designing, and optimizing reports using SQL Server Reporting Services (SSRS), Power BI or similar tools; principles, methods and techniques used in designing, developing, and testing business applications Methods and techniques of developing and presenting technical documentation and training materials; conducting regular backups of databases, files, and other data sources according to established schedules and protocols.
Ability to: Perform professional level applications development duties, including programming, maintaining, troubleshooting and repairing various application structures and websites; gather and interpret business requirements to design and develop reports that meet stakeholders' needs; develop, maintain, test and troubleshoot program structures, flow charts, layouts and screens using standard technologies and tools; read and interpret source code from commonly used programming languages; develop a working knowledge of new programming languages; communicate technical information to a wide variety of users; troubleshoot and repair a variety of application issues using appropriate testing methods and tools; plan, organize, prioritize and process work to ensure that deadlines are met; communicate effectively, both verbally and in writing; establish and maintain effective working relationships with those encountered during the course of the work.
Required IT-Related Skills: Systems analysis theory, processes and techniques; project spec development; application design; writing and modifying technical and user documentation; data modeling techniques; prepare flow process diagrams and other design graphics; application of industry or County standards and conventions for systems analysis and quality assurance; installation, testing and migration process and techniques; quality and version control processes; use of packaged or off-the-shelf and third party application software including office automation tools.
Preferred IT-Related Skills: Analyze and interpret complex data sets to produce detailed and actionable reports. Knowledge of database design and management. Design, develop, and implement custom applications and solutions tailored to business requirements.
SUPPLEMENTAL INFORMATION
Contact Information
For more information regarding this position, please contact the recruiter, Stephanie Rodriguez, at (951) 955-5776 or via email at sterodriguez@rivco.org .
________________________________________________________________________________________
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: https://rivcocob.org/board-policies
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-hr.com/disability
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 ).
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, www.rc-hr.com .
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 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. 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 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.
