Business Intelligence Analyst

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

EDUCATIONAL / BILINGUAL INCENTIVE : Incumbents may be eligible for educational incentive of 2.5% 3.5% or 5% based on completion of an Associates Bachelors or Masters 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 andfuture Regular (including Temporary and Fixed-term) Intermittent and Extra Helpvacancies 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 :

Proficient skill in :

Working ability to :

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 If you prefer to fill out a paper application form please call 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 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 applicants 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 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 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 or by telephone at .

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.

Required Experience :

IC

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Data Visualization,ssrs,Tableau,SSIS,Data Modeling,Data Warehouse,Data Analysis Skills

Employment Type : Full-Time

Experience : years

Vacancy : 1

Yearly Salary Salary : 91657 - 121728