County of Ventura
Payroll Title
Office Systems Coordinator IV
Educational/Bilingual Incentive Eligibility for an educational incentive of 2.5%, 3.5%, or 5% based on completion of an Associate's, Bachelor's, or Master's degree not required for the classification. Eligible for a bilingual incentive based on operational need and certification of skill.
Department/Agency Health Care Agency – Analytics
Schedule Opening Date: 10/15/25
Closing Date: 10/29/25 at 5:00 p.m.
Duties
Design, test, implement, and maintain complex technical solutions in SQL and Power BI to support critical operational initiatives.
Develop, maintain, and optimize dashboards, reports, and data visualizations using Power BI and/or Tableau.
Translate business requirements into design specifications and architect reporting solutions.
Build and maintain complex semantic data models in Power BI/Microsoft Fabric.
Establish best practices and designs to support semantic models for both the BI team and self‑service reporting, including optimal data loading and refresh strategies.
Optimize the performance of BI solutions, including data modeling, system architecture, and report refresh efficiency.
Collaborate with the Data Analytics and Data Platform teams to ensure high data quality, availability, and freshness.
Assist in automating reporting processes to improve efficiency and timeliness and troubleshoot issues with existing reports, and optimize code to improve report performance.
Set up monitoring tools to track performance, lineage, usage, and issues within the Power Platform environment.
Conduct data analysis to identify trends, variances, and opportunities for improvement in clinic workflows, patient throughput, revenue cycle processes, and quality outcomes.
Perform other related duties as required.
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 can also be obtained by completion of pertinent office systems coursework with five (5) or more years of related experience.
Knowledge, Skills, and Abilities
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) systems
Healthcare data analysis such as clinical, financial, or operational
Proficient Skill In
Data visualization tools like 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
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.
Application To apply online, 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, 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 or 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 applicant's qualifications and acceptability for the position. Failure to complete and submit the questionnaire may result in the application being removed from consideration.
Training & 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.
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.
Further Information For further information about this recruitment, please contact Nathan Wood by e‑mail at nathan.wood@venturacounty.gov 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.
#J-18808-Ljbffr
Educational/Bilingual Incentive Eligibility for an educational incentive of 2.5%, 3.5%, or 5% based on completion of an Associate's, Bachelor's, or Master's degree not required for the classification. Eligible for a bilingual incentive based on operational need and certification of skill.
Department/Agency Health Care Agency – Analytics
Schedule Opening Date: 10/15/25
Closing Date: 10/29/25 at 5:00 p.m.
Duties
Design, test, implement, and maintain complex technical solutions in SQL and Power BI to support critical operational initiatives.
Develop, maintain, and optimize dashboards, reports, and data visualizations using Power BI and/or Tableau.
Translate business requirements into design specifications and architect reporting solutions.
Build and maintain complex semantic data models in Power BI/Microsoft Fabric.
Establish best practices and designs to support semantic models for both the BI team and self‑service reporting, including optimal data loading and refresh strategies.
Optimize the performance of BI solutions, including data modeling, system architecture, and report refresh efficiency.
Collaborate with the Data Analytics and Data Platform teams to ensure high data quality, availability, and freshness.
Assist in automating reporting processes to improve efficiency and timeliness and troubleshoot issues with existing reports, and optimize code to improve report performance.
Set up monitoring tools to track performance, lineage, usage, and issues within the Power Platform environment.
Conduct data analysis to identify trends, variances, and opportunities for improvement in clinic workflows, patient throughput, revenue cycle processes, and quality outcomes.
Perform other related duties as required.
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 can also be obtained by completion of pertinent office systems coursework with five (5) or more years of related experience.
Knowledge, Skills, and Abilities
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) systems
Healthcare data analysis such as clinical, financial, or operational
Proficient Skill In
Data visualization tools like 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
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.
Application To apply online, 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, 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 or 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 applicant's qualifications and acceptability for the position. Failure to complete and submit the questionnaire may result in the application being removed from consideration.
Training & 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.
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.
Further Information For further information about this recruitment, please contact Nathan Wood by e‑mail at nathan.wood@venturacounty.gov 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.
#J-18808-Ljbffr