Ventura County
Business Analytics Developer - Ambulatory Care
Ventura County, Ventura, California, United States
THE POSITION
The Ventura County Health Care Agency’s Ambulatory Care Department seeks a Business Analytics Developer. Under general direction the incumbent will be responsible for developing reports and conducting complex analysis to inform department business decisions, drive quality improvement, optimize clinic operations, and ensure completion of reporting for quality and operational programs valued at over $100 million annually. THE IDEAL CANDIDATE
The ideal candidate has significant Cerner Electronic Health Record (EHR) experience including expert knowledge of back-end table structures, Cerner Command Language (CCL), and the Cerner Advanced Enterprise Data Warehouse. This person is skilled in developing complex reports in CCL, Structured Query Language (SQL), and Microsoft Excel following highly technical specifications. They understand and interpret complex programmatic information and are comfortable working with non-technical business owners to gather technical requirements and translate objectives into reports. WHAT WE OFFER
The County of Ventura offers an attractive compensation and benefits package. In addition to the salary, an employee within this position will also be eligible for the following: Educational Incentive - 2.5% for completion of an associate degree, 3.5% for a bachelor’s degree, or 5% for a graduate degree. Annual Leave Redemption - The ability to redeem up to 100 hours of Annual Leave per year after using 80 hours of annual leave within the previous 12 months. Annual Leave Accrual - 208 hours per year, increasing to 288 hours after 5 years of service (full-time schedule; hours pro-rated for part-time). Deferred Compensation - Eligible to participate in the County's 401(k) Shared Savings Plan and/or the 457 Plan. Up to a 3% match on 401(k) contributions. Health Insurance - Flexible credit allowance for purchasing medical, dental, and/or vision insurance from authorized plans. Flexible Spending Accounts - Pre-tax benefit toward eligible medical, dental, and vision care expenses. Pension Plan - Participation in the County's defined pension plan; may establish reciprocity with other public retirement systems (e.g., CalPERS). Holidays - 12 paid days per year including a floating holiday. Hybrid Work Schedule – Teleworking days may be available after training and with satisfactory performance. PAYROLL TITLE:
Program Administrator III/Sr. Program Administrator APPROXIMATE SALARIES:
Program Administrator III: $84,487 - $118,293 Annually; Sr. Program Administrator: $94,952 - $132,946 Annually EDUCATIONAL/BILINGUAL INCENTIVE:
Eligible for educational incentive of 2.5%, 3.5%, or 5% based on degree; bilingual incentive may apply depending on operational need and certification. DEPARTMENT/AGENCY:
Health Care Agency – Ambulatory Care Program Administrator III / Sr. Program Administrator are management classifications and are not 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. There is currently one regular vacancy. NOTE:
If appointed at the lower level, incumbent may be promoted to the higher level without further examination upon meeting minimum requirements, showing satisfactory performance, and in accordance with department needs. TENTATIVE SCHEDULE
OPENING DATE:
6/25/25 CLOSING DATE:
Continuous and may close at any time; apply as soon as possible. DUTIES
Designs, tests, implements, and maintains complex technical solutions in SQL and CCL to support critical operational initiatives. Manages the development lifecycle of technical solutions, including gathering requirements, design, development, testing, and packaging deliverables for requester use. Collaborates with clinical, operational, and financial stakeholders to understand KPIs and business objectives. Develops, maintains, and optimizes dashboards, reports, and data visualizations using Power BI or Tableau. Conducts data analysis to identify trends, variances, and opportunities for improvement in clinic workflows, patient throughput, revenue cycle processes, and quality outcomes. Partners with IT and data teams to ensure accurate data integration, modeling, and governance across systems (e.g., EHRs, billing, scheduling). Provides actionable insights through root cause analysis, predictive modeling, and performance measurement. Supports the development and maintenance of performance scorecards and operational benchmarks. Stays current on healthcare industry trends, regulations, and best practices in data analytics and quality reporting. Assists in automating reporting processes to improve efficiency and timeliness; troubleshoots issues with existing reports and optimizes code for report performance. Utilizes Cerner, including front-end Millennium functions and back-end report writing. Develops client-specific business glossary, data dictionary, technical documentation, and process documentation as required for activities within the data workstream, including process outline, deliverables, expectations, and project scope. Performs 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
Any combination of education, training, and experience comparable to a Bachelor’s degree in information technology, business administration, health care administration, public administration or a related field AND two years of recent, paid professional-level experience extracting data from an electronic healthcare system (preferably Cerner) and developing technical reports. Relevant work experience may be substituted for the degree requirement on a year-for-year basis. Necessary Special Requirements: Advanced proficiency with Electronic Health Record (EHR) systems, including data models Intermediate proficiency using MS Excel functions and formulas Experience developing complex SQL/CCL reports to extract clinical data Intermediate to advanced proficiency in SQL or CCL development Excellent written communication skills showcased in application submission DESIRED: Experience developing reports for large programs like Medi-Cal Quality Incentive Pool (QIP), CalAIM, GPP, OSHPD, CMQCC, or HRSA UDS Familiarity with health care operations in an ambulatory care setting Experience with data visualization tools like Power BI and Tableau KNOWLEDGE, SKILLS, AND ABILITIES Considerable to thorough knowledge of: EHR data models SQL or CCL development Microsoft Excel Principles of program management Office automation in business processes Extracting data from EHR systems Healthcare data analysis (clinical, financial, operational) Proficient skills in: Power BI or Tableau Working ability to: Analyze administrative and organizational problems Prepare reports and recommendations Manage projects and programs Communicate effectively in oral and written form Translate complex data into actionable insights and clear visualizations Collaborate with cross-functional teams and stakeholders FINAL FILING DATE:
This is a continuous recruitment; apply soon. Your application must be received by County of Ventura Human Resources in Ventura, California, by 5:00 p.m. on the closing date. To apply online, visit ventura.org/jobs. For a paper application, call (805) 654-5129 for materials and submit to County of Ventura Human Resources, 800 South Victoria Avenue, L-1970, Ventura, CA 93009. Note to Applicants:
Complete all sections of your application and supplemental questionnaire thoroughly. A resume or related documents may be attached to supplement the information, but 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 similar position, appointment by lateral transfer may be possible. For more information, click here. SUPPLEMENTAL QUESTIONNAIRE – Qualifying:
All applicants must complete and submit the questionnaire at filing. It may be used to determine qualifications and acceptability for the position. APPLICATION EVALUATION – Qualifying:
All applications will be reviewed to determine if requirements are met. Those meeting the requirements will be invited to the practical examination. TRAINING & EXPERIENCE EVALUATION – 50%:
A T&E evaluates materials and responses. It is not a sole determinant of qualification. Candidates are ranked by how well they meet business needs. A higher pool quality may result in lower rankings for some qualified candidates. PRACTICAL EXAM – 50%:
Applicants complete job-related tasks; scoring is based on performance. A combined 70% or higher qualifies for placement on the eligible list. Eligible lists last one year. BACKGROUND INVESTIGATION:
A thorough pre-employment background investigation may be required. For more information, contact Nathan Wood at nathan.wood@ventura.org or (805) 677-5232. EQUAL EMPLOYMENT OPPORTUNITY The County of Ventura is an equal opportunity employer to all, regardless of age, ancestry, color, disability, gender, gender identity, marital status, medical condition, national origin, political affiliation, race,religious creed, sex, and sexual orientation.
#J-18808-Ljbffr
The Ventura County Health Care Agency’s Ambulatory Care Department seeks a Business Analytics Developer. Under general direction the incumbent will be responsible for developing reports and conducting complex analysis to inform department business decisions, drive quality improvement, optimize clinic operations, and ensure completion of reporting for quality and operational programs valued at over $100 million annually. THE IDEAL CANDIDATE
The ideal candidate has significant Cerner Electronic Health Record (EHR) experience including expert knowledge of back-end table structures, Cerner Command Language (CCL), and the Cerner Advanced Enterprise Data Warehouse. This person is skilled in developing complex reports in CCL, Structured Query Language (SQL), and Microsoft Excel following highly technical specifications. They understand and interpret complex programmatic information and are comfortable working with non-technical business owners to gather technical requirements and translate objectives into reports. WHAT WE OFFER
The County of Ventura offers an attractive compensation and benefits package. In addition to the salary, an employee within this position will also be eligible for the following: Educational Incentive - 2.5% for completion of an associate degree, 3.5% for a bachelor’s degree, or 5% for a graduate degree. Annual Leave Redemption - The ability to redeem up to 100 hours of Annual Leave per year after using 80 hours of annual leave within the previous 12 months. Annual Leave Accrual - 208 hours per year, increasing to 288 hours after 5 years of service (full-time schedule; hours pro-rated for part-time). Deferred Compensation - Eligible to participate in the County's 401(k) Shared Savings Plan and/or the 457 Plan. Up to a 3% match on 401(k) contributions. Health Insurance - Flexible credit allowance for purchasing medical, dental, and/or vision insurance from authorized plans. Flexible Spending Accounts - Pre-tax benefit toward eligible medical, dental, and vision care expenses. Pension Plan - Participation in the County's defined pension plan; may establish reciprocity with other public retirement systems (e.g., CalPERS). Holidays - 12 paid days per year including a floating holiday. Hybrid Work Schedule – Teleworking days may be available after training and with satisfactory performance. PAYROLL TITLE:
Program Administrator III/Sr. Program Administrator APPROXIMATE SALARIES:
Program Administrator III: $84,487 - $118,293 Annually; Sr. Program Administrator: $94,952 - $132,946 Annually EDUCATIONAL/BILINGUAL INCENTIVE:
Eligible for educational incentive of 2.5%, 3.5%, or 5% based on degree; bilingual incentive may apply depending on operational need and certification. DEPARTMENT/AGENCY:
Health Care Agency – Ambulatory Care Program Administrator III / Sr. Program Administrator are management classifications and are not 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. There is currently one regular vacancy. NOTE:
If appointed at the lower level, incumbent may be promoted to the higher level without further examination upon meeting minimum requirements, showing satisfactory performance, and in accordance with department needs. TENTATIVE SCHEDULE
OPENING DATE:
6/25/25 CLOSING DATE:
Continuous and may close at any time; apply as soon as possible. DUTIES
Designs, tests, implements, and maintains complex technical solutions in SQL and CCL to support critical operational initiatives. Manages the development lifecycle of technical solutions, including gathering requirements, design, development, testing, and packaging deliverables for requester use. Collaborates with clinical, operational, and financial stakeholders to understand KPIs and business objectives. Develops, maintains, and optimizes dashboards, reports, and data visualizations using Power BI or Tableau. Conducts data analysis to identify trends, variances, and opportunities for improvement in clinic workflows, patient throughput, revenue cycle processes, and quality outcomes. Partners with IT and data teams to ensure accurate data integration, modeling, and governance across systems (e.g., EHRs, billing, scheduling). Provides actionable insights through root cause analysis, predictive modeling, and performance measurement. Supports the development and maintenance of performance scorecards and operational benchmarks. Stays current on healthcare industry trends, regulations, and best practices in data analytics and quality reporting. Assists in automating reporting processes to improve efficiency and timeliness; troubleshoots issues with existing reports and optimizes code for report performance. Utilizes Cerner, including front-end Millennium functions and back-end report writing. Develops client-specific business glossary, data dictionary, technical documentation, and process documentation as required for activities within the data workstream, including process outline, deliverables, expectations, and project scope. Performs 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
Any combination of education, training, and experience comparable to a Bachelor’s degree in information technology, business administration, health care administration, public administration or a related field AND two years of recent, paid professional-level experience extracting data from an electronic healthcare system (preferably Cerner) and developing technical reports. Relevant work experience may be substituted for the degree requirement on a year-for-year basis. Necessary Special Requirements: Advanced proficiency with Electronic Health Record (EHR) systems, including data models Intermediate proficiency using MS Excel functions and formulas Experience developing complex SQL/CCL reports to extract clinical data Intermediate to advanced proficiency in SQL or CCL development Excellent written communication skills showcased in application submission DESIRED: Experience developing reports for large programs like Medi-Cal Quality Incentive Pool (QIP), CalAIM, GPP, OSHPD, CMQCC, or HRSA UDS Familiarity with health care operations in an ambulatory care setting Experience with data visualization tools like Power BI and Tableau KNOWLEDGE, SKILLS, AND ABILITIES Considerable to thorough knowledge of: EHR data models SQL or CCL development Microsoft Excel Principles of program management Office automation in business processes Extracting data from EHR systems Healthcare data analysis (clinical, financial, operational) Proficient skills in: Power BI or Tableau Working ability to: Analyze administrative and organizational problems Prepare reports and recommendations Manage projects and programs Communicate effectively in oral and written form Translate complex data into actionable insights and clear visualizations Collaborate with cross-functional teams and stakeholders FINAL FILING DATE:
This is a continuous recruitment; apply soon. Your application must be received by County of Ventura Human Resources in Ventura, California, by 5:00 p.m. on the closing date. To apply online, visit ventura.org/jobs. For a paper application, call (805) 654-5129 for materials and submit to County of Ventura Human Resources, 800 South Victoria Avenue, L-1970, Ventura, CA 93009. Note to Applicants:
Complete all sections of your application and supplemental questionnaire thoroughly. A resume or related documents may be attached to supplement the information, but 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 similar position, appointment by lateral transfer may be possible. For more information, click here. SUPPLEMENTAL QUESTIONNAIRE – Qualifying:
All applicants must complete and submit the questionnaire at filing. It may be used to determine qualifications and acceptability for the position. APPLICATION EVALUATION – Qualifying:
All applications will be reviewed to determine if requirements are met. Those meeting the requirements will be invited to the practical examination. TRAINING & EXPERIENCE EVALUATION – 50%:
A T&E evaluates materials and responses. It is not a sole determinant of qualification. Candidates are ranked by how well they meet business needs. A higher pool quality may result in lower rankings for some qualified candidates. PRACTICAL EXAM – 50%:
Applicants complete job-related tasks; scoring is based on performance. A combined 70% or higher qualifies for placement on the eligible list. Eligible lists last one year. BACKGROUND INVESTIGATION:
A thorough pre-employment background investigation may be required. For more information, contact Nathan Wood at nathan.wood@ventura.org or (805) 677-5232. EQUAL EMPLOYMENT OPPORTUNITY The County of Ventura is an equal opportunity employer to all, regardless of age, ancestry, color, disability, gender, gender identity, marital status, medical condition, national origin, political affiliation, race,religious creed, sex, and sexual orientation.
#J-18808-Ljbffr