Business Analytics Developer - Ambulatory Care
Base pay range : $84,487.00 / yr - $132,946.00 / yr
THE POSITION : The Ventura County Health Care Agencys 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 for this position is a person 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
- Educational Incentive - An educational incentive of 2.5% for completion of an associate degree, 3.5% for completion of a bachelor's 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 - 208 hours per year, increasing to 288 hours after 5 years of service (full-time schedule; pro-rated for part-time).
- Deferred Compensation - Eligible to participate in the County's 401(k) Shared Savings Plan and / or the Section 457 Plan with up to a 3% match on 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; potential reciprocity with other public retirement systems such as CalPERS.
- Holidays - 12 paid days per year including a floating holiday.
- Hybrid Work Schedule Teleworking days may be available for staff who have completed training and meet performance expectations.
Payroll Title : Program Administrator III / Sr. Program Administrator
Approximate Salaries
Program Administrator III : $84,487 - $118,293 AnnuallySr. Program Administrator : $94,952 - $132,946 AnnuallyEDUCATIONAL / BILINGUAL INCENTIVE : Incumbents may be eligible for educational incentive based on degree completion and for bilingual incentive depending on 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, Temporary, 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 the minimum requirements, performance expectations, and department needs.
TENTATIVE SCHEDULE
OPENING DATE : 6 / 25 / 25
CLOSING DATE : Continuous and may close at any time. Apply as soon as possible.
Examples Of 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 from requirements gathering to deliverables.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, 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 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 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 data workstream activities.Performs other related duties as required.Qualifications
Education, Training, and Experience : Any combination of education, training, and experience equivalent to a Bachelor's degree in information technology, business administration, health care administration, public administration or a related field AND two (2) years of professional experience extracting data from an electronic health record system (preferably Cerner) and developing technical reports. Relevant work experience may be substituted for the degree requirement on a year-for-year basis.
Advanced proficiency with EHR systems and data modelsIntermediate proficiency with MS ExcelExperience developing complex SQL / CCL reports to extract clinical dataIntermediate to advanced proficiency in SQL or CCL developmentExcellent written communication skillsDesired :
Experience developing reports for large programs (e.g., Medi-Cal QIP, CalAIM, OSHPD, CMQCC, HRSA UDS)Familiarity with ambulatory care operationsExperience with Power BI and TableauKnowledge, Skills, Abilities
Knowledge of EHR data models, SQL / CCL, Microsoft ExcelUnderstanding of program management and data extraction from EHR systemsHealthcare data analysis (clinical, financial, operational)Recruitment Process
Final Filing Date : Continuous recruitment; apply soon. Must be received by 5 : 00 p.m. on the closing date.Online application at ; paper applications available by calling (805) 654-5129.Note to Applicants : Complete all sections of the application and supplemental questionnaire thoroughly. A resume may be attached but not in lieu of the application.Lateral Transfer option may be available for qualified candidates.Supplemental Questionnaire Qualifying : Must be submitted with the application.Application Evaluation Qualifying : All applications reviewed for requirements; qualified candidates invited to practical examination.Training & Experience Evaluation 50% : Evaluates background, experience, and fit for business needs.Practical Exam 50% : Job-related tasks; a minimum combined score of 70% required for placement on the eligible list.Background Investigation : Pre-employment checks may be required.For more information contact Nathan Wood : nathan.wood@ or (805) 677-5232.Equal Employment Opportunity statement included.EEO Notice : The County of Ventura is an equal opportunity employer to all regardless of age, ancestry, color, disability, gender, gender identity, genetic information, marital status, medical condition, national origin, political affiliation, race, religion, sex, or sexual orientation.
Note : Seniority level, employment type, job function, and industries listed in the original posting have been retained only as reflected above where relevant to this role.
#J-18808-Ljbffr