County of Ventura · 4 months ago
Business Analytics Developer - Ambulatory Care
Ventura County, CA
Full-time
Hybrid
Entry, Mid Level
$87K/yr - $122K/yr
2+ years expThe County of Ventura is seeking a Business Analytics Developer for its Ambulatory Care Department. The role involves developing reports and conducting complex analyses to inform business decisions and optimize clinic operations, while ensuring completion of reporting for quality and operational programs valued at over $100 million annually.
Association
Responsibilities
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, designing and developing technical solutions, testing the solutions, and packaging the deliverables for use by the requester
Collaborates with clinical, operational, and financial stakeholders to understand key performance indicators and business objectives
Develops, maintains, and optimizes dashboards, reports, and data visualization using tools such as 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 and troubleshoots issues with existing reports, and optimizes code to improve 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 to include an outline of the process, key deliverables, expectations, and project scope; and
Performs other related duties as required
Qualification
Required
Bachelor's degree in information technology, business administration, health care administration, public administration or a related field
Two (2) years of recent, paid professional-level experience extracting data from an electronic healthcare system (preferably Cerner) and developing technical reports
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
Preferred
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 used to build dashboards
Benefits
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 - 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 County's 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 County's 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.
Company
County of Ventura
Ventura County, Calif., is the absolute most desirable place to live in America.
10001+ employees
H1B Sponsorship
County of Ventura has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (2)
2023 (1)
2021 (1)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Bryan Friedman
Program Management Analyst - CEO Office
Christopher Ornelas
CEO Grants Analyst
Company data provided by crunchbase