Data Analyst I/II

Salary : $108,784.00 - $127,899.20 Annually Location : Orange County Superior Court, CA Job Type: Full-Time Regular Remote Employment: Flexible/Hybrid Job Number: 5402CX-1024 Department: Finance & Administration Opening Date: 10/24/2024 Closing Date: 11/7/2024 11:59 PM Pacific Position Information DATA ANALYST I/II* (*The position may be filled at the I or II level, depending on qualifications.) DEADLINE TO APPLY The deadline to apply for this recruitment is Thurs day, November, 07, 2024, at 11:59 PM PST This recruitment is open to external candidates and internal OCSC employees (internal OCSC promotions and internal OCSC lateral transfers). The eligible list established from this recruitment will be used to fill current and future positions. ANNUAL SALARY Data Analyst I: $94,099.20 - $110,593.60 Data Analyst II: $108,784.00 - $127,899.20 BENEFIT HIGHLIGHTS Choice of five medical plans Vacation and sick leave packages $3,500 Optional Benefit Plan (OBP) Defined Benefit Retirement Plan (2.50% at 67 formula) Health Reimbursement Arrangement (HRA) 14 paid holidays per year Tuition reimbursement Dental and vision plans Optional deferred compensation program (457 plan) TELEWORK/ON-SITE OPPORTUNITY This position is eligible for a combination of telework and on-site work assignments. Telework must be completed from a pre-designated home-based location within the State of California and employees may be required to report on-site to address business needs. Telework is at the sole discretion of the Court and may be rescinded with 48 hours' notice, based on needs of the Orange County Superior Court. Opportunity Details THE POSITION AND DUTIES Data Analysts utilize well-established analytic principles, methods, and procedures to identify, gather, analyze, and evaluate data to support the Court's effort in leveraging data to optimize business and operational directives. The current need is within the Court's Business Analytics Team (BAT), however this list may be used for other vacancies as needed. BAT aims to deliver innovative and user-friendly data-driven analysis, business process evaluations, enhanced data reporting methods, and financial and strategic planning dashboards. The team provides decision support through data collection, analysis, reporting, evaluation, and science to all levels and areas of the court, including judicial/executive leadership and external agency partners. BAT serves as a cross-departmental resource with the following accountabilities: Courtwide Analytics Support Data management for all litigation types (criminal, civil, family law, juvenile, probate, mental health and appellate division) Regular & ad hoc reporting, including data extraction and reports/dashboard creation Public record requests Business process evaluation/business process re-engineering External research requests (review/recommendation, coordination & participation) Mentoring (judicial branch fellow/intern participants) Statewide reporting Judicial Branch Statistical Information System (JBSIS) Courtwide remote hearings Criminal realignment Pretrial services Court collections Administrative oversight Centralized data warehouse (case operations data) SAP User Administration Data literacy/fluency training curriculum Data governance This position will provide general data support which may include gathering requirements, extracting data from designated case management system(s), analyzing data, creating and maintaining reports and interactive dashboard, performing impact analysis, and participating in meetings and/or projects. If you are interested in expanding your knowledge, and have a passion for serving the public and would like to be on the forefront of innovation to enhance operational efficiency and effectiveness, this is an opportunity for you to join our dedicated Business Analytics Team! To view the full job descriptions, click on the following links: Minimum Qualifications Required Education (for both levels): Bachelor's degree in statistics, mathematics, computer science, data science, business/public administration, social sciences, economics, or a closely related field. Note: A copy of your college diploma or official transcripts must be included with your application. Required Experience : Data Analyst I: None. Data Analyst II: One (1) year of progressively responsible full-time equivalent experience in data/statistical analysis and reporting, working with database systems and creating visualizations and reports. Substitution Options: Four (4) years of full-time equivalent data analyst experience may substitute for the education requirement. Master's degree or higher in one of the areas stated above may substitute for a total of one (1) year of experience. Note: To receive substitution credit, a copy of your college diploma or official transcripts must be included with your application. Desirable Knowledge, Skills, Abilities and Experience : Strong interpersonal skills, including: extensive experience in working with and supporting leadership teams. the ability to thrive within the unit and work collaboratively with various units within the organization. the ability to work with various levels of staff. strong verbal skills and the ability to present to audiences of various sizes. Experience in establishing requirements, and collecting, extracting & analyzing data from large data systems Knowledge of software applications and/or languages utilized for extracting, presenting, and/or analyzing data (e.g., SPSS, SQL, Excel, SAS, R, Python, Tableau, Power BI) Experience in performing program evaluations, developing outcome measures, and designing surveys Knowledge of the principles and practices of court administration Experience working with the Judicial Branch Statistical Information System data Additional Information Application Process All applicants are required to submit a completed online application and supplemental questionnaire. To learn more about how to create an account/application, click HERE . Résumés will not be accepted in lieu of the required application and supplemental questionnaire. Human Resources will review applications to identify candidates who meet the minimum qualifications; therefore, it is to your benefit to include all current and previous related work experience. Selection Process Step 1: Applications will be reviewed to identify candidates who meet the minimum qualifications and/or desirables; those candidates will be referred to step 2 in the selection process. Step 2: Candidates' supplemental question responses may be evaluated and ranked. Depending on the number of applications, assessments and/or screening interviews may be conducted. If any part of the assessment process consists of proctored, in-person tests, candidates will be required to appear in person regardless of where they reside. Note: Though candidates may live outside of the State of California while participating in a recruitment process, individuals must reside within the State to be eligible for Court employment. Step 3: Those candidates who are successful in the review/assessment may be placed on the eligible list. Placement on the eligible list is not a guarantee of interview or employment. All candidates will be notified via email of their status at each step of the process. Additional steps for the selection process will include a local background and reference check. Background Check A thorough background check will be conducted, including but not limited to work experience, education, certifications, driving record, criminal record, litigation judgment or verdict, and financial/credit information. Fingerprints of candidates are also taken as part of our background check process. Reasonable Accommodations Orange County Superior Court provides reasonable accommodations for applicants with disabilities, upon request. Please contact the Human Resources Department at if you feel that you will need a reasonable accommodation for any aspect of the selection process. Eligible List This recruitment will be used to establish an eligible list for current and future vacancies. The eligible list will remain active until the list is exhausted or a new recruitment opens. Status Notifications You will be notified by email during the process of this recruitment through . Please check your email spam/junk folders and accept emails ending with and . If your information changes, please update your profile at eVerify Superior Court of California, County of Orange participates in the eVerify program. Questions? For questions on this recruitment, please contact Monica Budd at . For general employment information, please click HERE . Orange County Superior Court is an Equal Opportunity Employer F ollow us on social media! LinkedIn | Facebook | X MEDICAL INSURANCE: Employees have an option to enroll in one of five medical plans; three HMO's (Cigna Select, Cigna Choice, and Kaiser Choice) and two PPO's (Wellwise Choice or Sharewell Choice), both administered by Blue Shield. The employee contributions toward the HMO or PPO insurance vary based on plan, coverage level and participation in the annual wellness credit program. To view health plan rates and summaries of benefits and coverage, click HEALTH REIMBURSEMENT ARRANGEMENT: The Court will contribute $60.00 per pay period into individual employee Health Reimbursement Arrangement (HRA) accounts for eligible full-time employees ($30 per pay period for part-time). This Court contribution will increase 2.5% annually each first full pay period in July, beginning July 2024. DENTAL INSURANCE: The Court pays the premiums for Indemnity dental plan. Co-payments, deductibles, and caps on major dental services apply. Spouse and children less than 26 years old are eligible dependents. VISION INSURANCE: The Court pays the premiums for employee only vision insurance coverage provided by VSP. Employees may elect to purchase coverage for spouse and dependent children less than 26 years old. LIFE INSURANCE: The Court pays for employee basic life insurance policy of $100,000. Additional voluntary life insurance can be purchased for employee, spouse, and dependent children. ACCIDENTAL DEATH AND DISMEMBERMENT (AD&D) INSURANCE: The Court pays for employee basic AD&D insurance policy in the same amount as term life insurance. Additional voluntary coverage can be purchased for employee and family. SHORT-TERM DISABILITY (STD) PLAN: The Court provides STD which provides 60% of regular monthly income (no maximum) for 12 months (reduced by income from other sources). Benefits begin after all sick leave has been used or 7 days, whichever is greater. The Court continues to pay same amount of medical, life, and AD&D insurance premiums while employee is receiving STD benefits. LONG-TERM DISABILITY (LTD) PLAN: The Court provides LTD which provides 60% of regular monthly income (up to a maximum benefit of $20,000 per month) until age 65 if the employee is not able to return to work similar occupation (reduced by income from other sources). Benefits begin immediately after STD expires. OTHER VOLUNTARY BENEFITS: Employees may elect to enroll in additional voluntary plans administered by Unum. Available plans include Accident Insurance, Critical Illness/Cancer Insurance and Hospital Confinement Insurance. Coverage may be purchased for employee, spouse, and dependent children. LONG-TERM CARE: CalPERS Long-Term Care coverage is available to current and former California public employees, retirees, their spouses, parents, parents-in-law, children, siblings (including stepbrothers and stepsisters), grandparents, grandchildren, nieces, nephews, aunts, uncles, sons-in-law, daughters-in-law between the ages of 18 and 79 when they apply. Eligible family members may apply even if the public employee or retiree who makes them eligible does not apply or is not approved for coverage. NOTICE: CalPERS has temporarily suspended open enrollment for the Long-Term Care Program due to current uncertainty in the long-term care market. Therefore, until further notice, CalPERS will no longer accept new applications for coverage at this time. OPTIONAL BENEFIT PLAN (OBP): The Court provides employees $3,500 per calendar year (pro-rated for new employees) which can be received as cash (taxable) or allocated to several benefits ranging from health, County 457 Defined Contribution Plan and AD&D premiums (non-taxable). RETIREMENT: Defined Benefit, fully qualified plan based on the County Employees Retirement Law of 1937 (Government Code Section 31450 et. al.). Employee and Court contributions are based on several variables including age, hire date, and salary. The plan is administered by an independent agency, Orange County Employees Retirement System (OCERS), and has reciprocity with various California systems. Currently, eligible new employees hired on or after January 1, 2013, will be enrolled in a defined benefit retirement plan referred to as Plan U (2.5% at 67 formula). *If you were employed by an OCERS employer or reciprocal agency prior to January 1, 2013, you have less than a six-month break in service, and reciprocity is established, you may be eligible to select from two other retirement pension formula options (Plan J or Plan P). See website for more information. DEFERRED COMPENSATION: Optional deferred compensation 457 & Roth 457 Deferred Contribution Plans are available. VACATION ACCRUAL: 0-3 years, 120 hours per year; 4-9 years, 160 hours per year; 10 or more years, 200 hours per year. Maximum accrual of hours: 0-9 years, 360 hours; 10 or more years, 480 hours. Part-time employees accrue vacation on a prorated basis. HOLIDAYS: 14 paid holidays per year. SICK LEAVE: 0-3 years accrue 72 hours of sick time per year as full-time employees. After 3 years, full-time employees accrue 96 hours per year. Part-time employees accrue sick leave on a prorated basis. Unlimited accrual. Some sick leave maybe converted to cash or vacation time. COMP TIME: All employees receive compensatory time every March. Full-time employees receive 4 hours and part-time employees receive 2 hours. BEREAVEMENT LEAVE: 5 days of paid leave per qualifying instance. UNEMPLOYMENT INSURANCE: The Court pays into county administered insurance fund. WORKERS' COMPENSATION: Administered by the Judicial Council's, third party administrator. EDUCATION REIMBURSEMENT: Court reimburses up to $3,500 per year of tuition for approved, necessary courses, subject to availability of funds. FEDERAL STUDENT LOAN REPAYMENT AND FORGIVENESS PROGRAMS: Employees of the Court may be eligible for Federal Student Loan Repayment and Loan Forgiveness Programs. The Court offers access to GotZoom services at discounted rate; a service provider that identifies, enrolls, and annually re-certifies employees into eligible student loan repayment/forgiveness programs BILINGUAL PAY: Available at additional $0.58/hour for selected classes in selected positions. EMPLOYEE ASSISTANCE PROGRAM (EAP): Court offers EAP confidential services to assist employees with marital, family, emotional, legal, financial, and chemical dependency problems. This service is offered 24 hours a day, 7 days a week. DISCOUNT PROGRAMS: There are numerous discount programs available to Court employees. These include, but are not limited to discounts on hearing aids, pet insurance, local attractions, technology products, wellness services and gym memberships. ONLINE PRIVACY BENEFIT: Employees may elect to enroll in a voluntary online privacy protection plan provided by IronWall360. This benefit helps protect employee's online privacy by searching the Internet and locating any personal information and making sure it is removed. Provisions are subject to terms: 01 INSTRUCTIONS: The information you provide on this questionnaire will be evaluated and used to determine your eligibility to participate in the next phase of the selection process and may also be used in a competitive evaluation of qualifications. Be as specific as possible and include all information requested. If you do not have experience in an area, please answer "N/A". Statements such as "see application," will not be accepted in lieu of a response. All employers referenced on this questionnaire must be listed on your you understand these instructions? Yes No 02 A résumé MAY NOT be submitted in lieu of the employment application (or completion of the work history section of the application). A résumé may be submitted in addition to the employment application, but applicants are selected for an interview and/or testing based primarily on information supplied by the application and supplemental forms. Do you understand these instructions? Yes No 03 RESIDENCY/WORK ELIGIBILITY REQUIREMENT : I understand that I may live outside of the State of California while participating in a recruitment process, however if am selected for a position, I must reside within the State to be eligible for Court employment. In addition, work performed while working for the Court, even remote work, must be done within the State of California. I also understand that the Orange County Superior Court does not provide US visa or employment sponsorship. Yes No 04 Do you have a degree from an accredited college or university in statistics, mathematics, computer science, data science, business/public administration, social sciences, economics, or a closely related field? Yes, I have a Master's degree or Doctorate in statistics, mathematics, computer science, data science, or a closely related field. Yes, I have a Master's degree or Doctorate in business/public administration, social sciences, economics or a closely related field. Yes, I have a Bachelor's degree in statistics, mathematics, computer science, data science, or a closely related field. Yes, I have a Bachelor's degree in business/public administration, social sciences, economics or a closely related field. I have a Bachelor's or higher level degree, but not in one of the fields above. I do not have a Bachelor's, Master's or Doctorate. 05 I understand that a copy of my college transcript or diploma is required AND I have attached it to my application. Note: Indicating completion of a Bachelor's or Master's degree in your application or resume is NOT sufficient. Applications that do not have a college diploma or transcript attached will not move forward in the process. The only exception is if applicants have at least 4 years of data analyst experience to substitute for the required education. Yes No 06 Describe your work experience in data/statistical analysis and reporting, working with database systems and creating visualizations and reports. Please include the job setting, your title, dates of employment and your employer. If you do not have experience in this area, type "N/A" in the text box below 07 Check the box(es) for the following software applications and/or languages in which you have experience, training or education: SPSS SQL Excel SAS R Python Tableau Power BI None of the above 08 Describe your experience, training or education in the software applications and/or languages indicated in the question above. Be sure to state if your experience includes extracting, presenting, and/or analyzing data. If not applicable, write "N/A" in the box below. 09 Are you currently or have you ever been an employee of a trial court? Yes No 10 If you answered 'Yes' to the question above, list the name of the court, the department (ex. Court Operations, IT, HR, Finance, etc), and your position title, for each position held. 11 Indicate the court case types and/or operational areas in which you have worked. Select all that apply. Appellate Division Civil Criminal/Traffic Family Law Juvenile Mental Health Probate Alternate Defense Collaborative/Treatment Courts Collaborative/Treatment Courts - Juvenile Court Reporter Services Family Court Services Language Access Services Pretrial Services Records & Exhibits Management Self-Help Services None of the above Required Question

Created: 2024-11-05