Population Health Report Developer – Ambulatory Care

Ventura County

Population Health Report Developer – Ambulatory Care

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

Apply



Population Health Report Developer – Ambulatory Care

Salary

$81,629.99 – $128,450.31 Annually

Location

and may be required to travel throughout Ventura County, CA

Job Type

Full-Time Regular

Job Number

0748HCA-24AE (NW)

Department

Health Care Agency

Division

Ambulatory Care

Opening Date

10/04/2024

Closing Date

Continuous

Description

Benefits

Questions

Description

THE POSITION: The Ventura County Health Care Agency’s Ambulatory Care Population Health Department seeks a Report 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 for this position is someone with 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 also 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 the 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:

A general salary increase of 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 full-time schedule; hours are pro-rated for part-time 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 – Pre-tax 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.

Holidays – 12 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.

PAYROLL TITLE: Program Administrator III/Sr. Program Administrator

APPROXIMATE SALARIES:

Program Administrator III: $81,630 – $114,293 Annually

Sr. Program Administrator: $91,741 – $128,450 Annually

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 – 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 these positions only. There are currently two (2) Regular vacancies.

NOTE: If appointed at the lower level, incumbent may be promoted to the higher level without further examination upon meeting the minimum requirements, demonstrating satisfactory performance, and in accordance with the business needs of the department.

TENTATIVE SCHEDULE

OPENING DATE: 10/4/24

CLOSING DATE: Continuous and may close at any time; therefore, the schedule for the remainder of the process will depend upon when we receive a sufficient number of qualified applications to meet business needs. It is to your advantage to apply as soon as possible.

Examples Of Duties

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 Medi-Cal Quality Incentive Pool (QIP), Cal-AIM, 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 front-end millennium functions and back-end 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.

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:

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 professional-level experience working with Cerner EHR data models 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 Cerner 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 the Medi-Cal 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

Knowledge, Skills, and Abilities:

Considerable to thorough knowledge of: Cerner Electronic Health Records (EHR) data models; SQL or CCL development; Microsoft Excel; the principles of program management; application of office automation to business processes.

Working ability to: analyze administrative and organizational problems; prepare a variety of reports and recommendations; manage projects and programs; and communicate effectively in an oral and written manner.

Recruitment Process

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 on-line, please refer to our web site at ventura.org/jobs (https://www.governmentjobs.com/careers/ventura?sort=PositionTitle%7CAscending) . If you prefer to fill out a paper application form, please call (805) 654-5129 for application materials and submit them to County of Ventura Human Resources, 800 South Victoria Avenue, L-1970, 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 (http://vcportal.ventura.org/CEO/HR/docs/LateralTransfer.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 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 job-related 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 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 nathan.wood@ventura.org 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

MANAGEMENT

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 FAQs (https://vcportal.ventura.org/CEO/benefits/docs/RETIREMENT%20-%20FAQs.pdf)

Memorandum of Agreement

Union Codes: MB3, MB4, MS, MT, MCC, MU

01

Describe your recent paid professional-level experience working with Cerner EHR data models and developing technical reports. 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

What is your proficiency level using Cerner data models?

Basic

Intermediate

Advanced

Expert

I am not proficient using Cerner data models

03

Describe your experience developing complex SQL/CCL reports to extract clinical data. 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.”

04

What is your proficiency level with SQL or CCL development?

Basic

Intermediate

Advanced

Expert

I am not proficient with SQL or CCL development

05

Please describe your experience supporting or leading large reporting or operational projects or programs, including examples of your resourcefulness, strong organizational skills, and ability to collaborate. If you have experience with programs like the Medi-Cal 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, be sure to highlight such experience in your response.

06

Describe your experience using Microsoft Excel, including the formulas and functions you have experience with. In your response, include the workplace and/or academic institution where you gained this experience, the types of reports created, how the data was obtained, and the business use case for the reports.

07

What is your proficiency level using data visualization tools like Power Business Intelligence (Power BI) and Tableau.

Basic

Intermediate

Advanced

Expert

No experience using data visualization tools

08

Please provide one example of code you have developed in SQL/CCL. The sample(s) can be uploaded in the “Attachments” section of your application. Have you attached a work sample of code you have developed in SQL or CCL?

Yes

No

09

Please provide one example of a report you developed in Microsoft Excel. The samples can be uploaded in the “Attachments” section of your application. Have you attached a report you have developed in Microsoft Excel?

Yes

No

Required Question

Agency

Ventura County

Address

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

Phone

(805) 654-5129

Website

http://hr.ventura.org

Apply

Please verify your email address Verify Email

Show Full Vacancy