Population Health Report Developer - Ambulatory Care

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:

• A general salary increaseof 3.5 effective December 22 2024.
• Educational Incentive An educational incentive of 2.5 for completion of an associate degree 3.5 for completion of a bachelors degree OR 5 for completion of a graduate degree.
• Annual Leave Redemption The ability to cash in or 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 A candidate selected for this position will earn 208 hours per year increasing to 288 hours after 5 years of service (based on a fulltime schedule; hours are prorated for parttime schedules).
• Deferred Compensation Eligible to participate in the Countys 401(k) Shared Savings Plan and/or the Section 457 Plan. This position is eligible for up to a 3 match on your 401(k) contributions.
• Health Insurance You are afforded a flexible credit allowance for purchasing medical dental and/or vision insurance from a group of authorized plans.
• Flexible Spending Accounts Pretax benefit towards eligible medical dental and vision care expenses.
• Pension Plan Participation in the Countys defined pension plan. If eligible you may establish reciprocity with other public retirement systems such as CalPERS.
• Holidays12 paid days per year which includes a floating holiday.
• Hybrid Work Schedule Teleworking days may be available for staff who have completed training and maintain performance expectations.

Duties may include but are not limited to the following:

• Designs tests implements and maintains complex technical solutions in SQL and CCL to support critical quality and operational programs;
• Manages the development lifecycle of technical solutions including gathering requirements designing and developing technical solutions testing the solutions and packaging the deliverables for use by the requester;
• Maintains existing reports and solutions ensuring that they utilize the most current metric specifications and value sets;
• Troubleshoots issues with existing reports and optimizes code to improve report performance;
• Works closely with the quality operations and whole person care teams in ambulatory care to develop reports and dashboards in support of large reporting programs such as MediCal Quality Incentive Pool (QIP) CalAIM Uniform Data System (UDS) and the Global Payment Program (GPP);
• Plans organizes and manages large analytics reporting and/or operational data projects including collaborating with team members helping troubleshoot issues and being accountable to established deadlines;
• Collaborates with Information Technology teams to ensure that database infrastructure will support the requirements for key quality and operational programs;
• Serves as a liaison with external and internal stakeholders to transmit and receive ingest and manage data related to membership assignment enrollment quality and operations;
• Utilizes Cerner including frontendmillenniumfunctions and backend report writing;
• Uses advanced formulas to manipulate large quantities of data from multiple files in Excel and other BI tools;
• Develops client specific business glossary data dictionary technical documentation and process documentation as required for activities within the data workstream to include an outline of the process key deliverables expectations and project scope; and
• 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:
Requires a Bachelors degree in information technology business administration health care administration public administration or a related field AND five 5 years of recent paid professionallevel experience working with Cerner EHR data models and developing technical reports.

Relevant work experience may be substituted for the degree requirement on a yearforyear basis.

Necessary Special Requirements:

• Advanced proficiency with Cerner Electronic Health Record (EHR) systems including data models
• Intermediate proficiency using MS Excel functions and formulas
• Experience developing complex SQL/CCL reportsto extract clinical data
• Intermediate to Advanced proficiency in SQL or CCL development
• Excellent written communication skills showcased in application submission

• Experience developing reports for large programs like the MediCal Quality Incentive Pool Program (QIP) CalAIM GPP Office of Statewide Health Planning and Development (OSHPD) California Maternal Quality Care Collaborative (CMQCC) or Health Resources and Services Administration (HRSA) UDS;
• Familiarity with health care operations ideally in an ambulatory care setting
• Experience with data visualization tools like Power Business Intelligence (Power BI) and Tableau

FINAL FILING DATE: This is a continuous recruitment and may close at any time; therefore apply as soon as possible if you are interested. Your application must be received by County of Ventura Human Resources in Ventura California no later than 5:00 p.m. on the closing date.

To apply online please refer to our web site at ventura/jobs. If you prefer to fill out a paper application form please callfor application materials and submit them to County of Ventura Human Resources 800 South Victoria Avenue L1970 Ventura CA 93009.

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 practical examination.

TRAINING & EXPERIENCE EVALUATION 50
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.

NOTE: 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 providing all information requested.

PRACTICAL EXAM 50: Applicants will be required to complete several jobrelated tasks where essential job duties and the job environment are simulated. The method of completing the tasks the time required and the final product will be scored and evaluated.

Examinees must earn a combined score of seventy percent 70 or higher to qualify for placement on the eligible list.

If there are three 3 or fewer qualified applicants an oral exam 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 preemployment 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 email 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.