"Alerted.org

Business Intelligence Analyst

Print (https://www.governmentjobs.com/careers/ventura/jobs/newprint/5108034)

Apply



Business Intelligence Analyst

Salary

$91,657.34 - $121,728.52 Annually

Location

Ventura and may require travel throughout Ventura County, CA

Job Type

Full-Time Regular

Job Number

1621HCA-25AC (NW)

Department

Health Care Agency

Division

HCA IT

Opening Date

10/15/2025

Closing Date

10/29/2025 5:00 PM Pacific

+ Description

+ Benefits

+ Questions

Description

Under general direction, coordinates and monitors the progress of office automation projects from original analysis through final implementation; performs high level systems analysis and provides technical assistance to department/agency personnel by supporting and coordinating tasks related to office automation systems; and may provide supervision to subordinate staff.

The ideal candidate is an experienced Business Intelligence professional with expertise in SQL development, ETL processes, and modern data tools, skilled in designing, implementing, and maintaining complex reporting solutions in Power BI and Tableau. They excel at translating business requirements into scalable dashboards, semantic data models, and optimized reporting processes while ensuring data quality, availability, and performance across systems. With considerable knowledge of Electronic Health Record (EHR) data models and healthcare analytics, they can extract and analyze clinical, financial, and operational data to identify trends, improve workflows, and support quality outcomes. Proficient in data visualization and program management, they are adept at solving organizational challenges, preparing actionable recommendations, and communicating insights effectively. Collaborative and solutions-focused, they bring a balance of technical expertise and analytical skill to drive efficiency, automation, and informed decision-making across cross-functional teams.

PAYROLL TITLE: Office Systems Coordinator IV (https://www.governmentjobs.com/careers/ventura/classspecs/newprint/6249)

EDUCATIONAL/BILINGUAL INCENTIVE: Incumbents may be eligible for educational incentive of 2.5%, 3.5%, or 5% based on completion of an Associate's, Bachelor's, or Master's degree that is not required for the classification. Incumbents may also be eligible for bilingual incentive depending upon operational need and certification of skill.

DEPARTMENT/AGENCY: Health Care Agency – Analytics

Office Systems Coordinator IV is represented by the Services Employees International Union (SEIU) and is eligible for overtime compensation.

The eligible list established from this recruitment may be used to fill current and future Regular (including Temporary and Fixed-term), Intermittent, and Extra Help vacancies for this position only, which is a Regular position.

TENTATIVE SCHEDULE

OPENING DATE: 10/15/25

CLOSING DATE: 10/29/25 at 5:00 p.m.

Examples Of Duties

Duties may include but are not limited to the following:

+ Designs, tests, implements, and maintains complex technical solutions in SQL and PowerBI to support critical operational initiatives;

+ Develops, maintains, and optimizes dashboards, reports, and data visualization using tools such as Power BI and/or Tableau;

+ Translates business requirements into design specifications and architect reporting solutions;

+ Builds and maintains complex semantic data models in Power BI/Microsoft Fabric;

+ Establishes best practices and designs to support semantic models for both BI team and self-service reporting, including optimal data loading and refresh strategies;

+ Optimizes the performance of BI solutions, including data modeling, system architecture, and report refresh efficiency;

+ Collaborates with the Data Analytics and Data Platform teams to ensure high data quality, availability, and freshness;

+ Assists in automating reporting processes to improve efficiency and timeliness and troubleshoots issues with existing reports, and optimizes code to improve report performance;

+ Establishes best practices and designs to support semantic models for both BI team and self-service reporting, including optimal data loading and refresh strategies;

+ Sets up monitoring tools to track performance, lineage, usage, and issues within the Power Platform environment;

+ Conducts data analysis to identify trends, variances, and opportunities for improvement in clinic workflows, patient throughput, revenue cycle processes, and quality outcomes; and

+ Performs other related duties as required.

Typical Qualifications

These are entrance requirements to the exam process and assure neither continuance in the process nor placement on an eligible list.

EDUCATION, TRAINING, and EXPERIENCE:

Progressively responsible experience in automated office systems coordination, which has led to the acquisition of the required knowledge, skills, and abilities. The required knowledge, skills, and abilities also can be obtained by completion of pertinent office systems coursework with five (5) or more years of related experience.

Knowledge, Skills, and Abilities:

Considerable to thorough knowledge of:

+ Electronic Health Records (EHR) data models

+ SQL development, Datawarehouse development (ETL)

+ Data ingestion and modern data tools

+ the principles of program management

+ application of office automation to business processes

+ extracting data from Electronic Health Record (EHR) system

+ Healthcare data analysis such as clinical, financial or operational

Proficient skill in:

+ data visualization tools like Power Business Intelligence (Power BI) or Tableau

Working ability to:

+ analyze administrative and organizational problems

+ prepare a variety of reports and recommendations

+ manage projects and programs

+ communicate effectively in an oral and written manner

+ translate complex data into actionable insights and clear visualizations

+ work collaboratively with cross-functional teams and stakeholders

Recruitment Process

FINAL FILING DATE: Applications must be received by County of Ventura Human Resources, Health Care Agency in Ventura, California, no later than 5:00 p.m. on Wednesday, October 29, 2025.

To apply on-line, please refer to our website at www.venturacounty.gov/jobs. If you prefer to fill out a paper application form, please call (805) 677-5184 for application materials and submit them to County of Ventura Human Resources- Health Care Agency, 646 County Square Drive, Ventura, CA 93003.

Note to Applicants: It is essential that you complete all sections of your application and supplemental questionnaire thoroughly and accurately to demonstrate your qualifications. A resume and/or other related documents may be attached to supplement the information in your application and supplemental questionnaire; however, it/they may not be submitted in lieu of the application.

LATERAL TRANSFER OPTION: If presently permanently employed in another "merit" or "civil service" public agency/entity in the same or substantively similar position as is advertised, and if appointed to that position by successful performance in a "merit" or "civil service" style examination, then appointment by "Lateral Transfer" may be possible. If interested, please click here (http://vcportal.ventura.org/CEO/HR/docs/Lateral\_Transfer.pdf) for additional information.

SUPPLEMENTAL QUESTIONNAIRE – Qualifying: All applicants are required to complete and submit the questionnaire for this exam at the time of filing. The supplemental questionnaire may be used throughout the exam process to assist in determining each applicant's qualifications and acceptability for the position. Failure to complete and submit the questionnaire may result in the application being removed from consideration .

APPLICATION EVALUATION – Qualifying: All applications will be reviewed to determine whether the stated requirements are met. Those individuals meeting the stated requirements will be invited to the written examination.

TRAINING & EXPERIENCE EVALUATION:

A Training and Experience Evaluation (T&E) is a structured evaluation of the job application materials submitted by a candidate, including the written responses to the supplemental questionnaire. The T&E is NOT a determination of whether the candidate meets the stated requirements; rather, the T&E is one method for determining who are the better qualified among those who have shown that they meet the stated requirements. In a T&E, applications are either scored or rank ordered according to criteria that most closely meet the business needs of the department. Candidates are typically scored/ranked in relation to one another; consequently, when the pool of candidates is exceptionally strong, many qualified candidates may receive a score or rank which is moderate or even low resulting in them not being advanced in the process.

ORAL EXAMINATION - 100%: A job-related oral examination may be conducted to evaluate and compare participating examinees' knowledge, skills, and abilities in relation to those factors which job analysis has determined to be essential for successful performance of the job. Examinees must earn a score of seventy percent (70%) or higher to qualify for placement on the eligible list.

NOTE: The selection process may consist of an Oral Exam, which may be preceded or replaced with the score from a Training and Experience Evaluation (T&E), contingent upon the size and quality of the candidate pool. In a typical T&E, your training and experience are evaluated in relation to the background, experience and factors identified for successful job performance during a job analysis. For this reason, it is recommended that your application materials clearly show your relevant background and specialized knowledge, skills, and abilities. It is also highly recommended that the supplemental questions within the application are completed with care and diligence, using proper grammar and complete sentences to showcase your writing skills. Responses such as "See Resume" or "Refer to Resume" are not acceptable and may disqualify an applicant from further evaluation.

If there are three (3) or fewer qualified applicants, a T&E or an Oral Examination will not be conducted. Instead, a score of seventy percent (70%) will be assigned to each application, and each applicant will be placed on the eligible list.

Applicants successfully completing the exam process may be placed on an eligible list for a period of one (1) year.

BACKGROUND INVESTIGATION: A thorough pre-employment, post offer background investigation which may include inquiry into past employment, education, and driving record may be required for this position.

For further information about this recruitment, please contact Nathan Wood by e-mail at [email protected] or by telephone at (805) 677-5232.

EQUAL EMPLOYMENT OPPORTUNITY

The County of Ventura is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

YOUR BENEFITS AS A COUNTY OF VENTURA EMPLOYEE

Service Employees International Union (LOCAL 721)

(SEIU)

To learn more about Benefits, Retirement, and the Memorandum of Agreement (MOA), see links below.

+ Benefits website (https://hr.ventura.org/benefits) or you may call (805) 654-2570.

+ Retirement FAQ's (https://vcportal.ventura.org/CEO/benefits/docs/RETIREMENT%20-%20FAQs.pdf)

+ Memorandum of Agreement

Union Codes: UPA, UPC, UPE, UPH, UPI, UPJ, UPT, UWS

01

Please describe a project or experience where you designed, developed, or optimized a reporting or analytics solution using tools such as Power BI, Tableau, or SQL. In your response, include: Please include the following in your response:

+ Name of employer(s)

+ Dates of employment reflected as MM/YYYY to MM/YYYY or Present

+ Number of hours worked per week

+ Position title

+ Specific duties you performed

NOTE: Do not copy and paste a response to another question. Do not refer to an attached document.

NOTE: This experience must be included in the Work History section on your application.

If you do not have this experience state, "No experience."

02

Describe your experience with SQL development and data warehouse (ETL) processes. Please include an example of how you have designed or optimized queries, data models, or ETL pipelines to improve data quality, performance, or reporting capabilities. If you do not have this experience state, "No experience."

03

Describe a time when you applied office automation tools (e.g., Excel, Power BI, workflow automation, or other digital solutions) to streamline a business process. What problem did you address, what tools or methods did you use, and what was the outcome? If you do not have this experience state, "No experience."

04

Describe your experience with healthcare data analysis (clinical, financial, or operational). Please provide an example of how you analyzed data to identify trends, variances, or opportunities for improvement, and explain the impact of your work. If you do not have this experience state, "No experience."

05

Describe your experience using data visualization tools such as Power BI or Tableau. Share an example of a dashboard or report you developed, including the purpose, key features, and how it supported decision-making or improved outcomes. If you do not have this experience state, "No experience."

06

Provide an example of a time when you translated complex or large-scale data into actionable insights and clear visualizations. How did you determine the key message, what tools or methods did you use, and how did your work influence decisions or outcomes? If you do not have this experience state, "No experience."

Required Question

Employer

Ventura County

Address

800 S. Victoria Avenue LOC. #1970 Ventura, California, 93009

Phone

(805) 654-5129

Website

http://hr.venturacounty.gov

Apply

Please verify your email address Verify Email