Business Analytics Developer - Ambulatory Care

About the Role

Key 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.
• Assists in automating reporting processes to improve efficiency and timeliness, 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.
• Performs other related duties as required.

Requirements

• 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.
• 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.

Nice to Have

• Experience developing reports for large programs like the Medi-Cal Quality Incentive Pool Program (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 used to build dashboards.

Qualifications

• Bachelor's degree in relevant field or equivalent experience.
• Two (2) years of professional experience in data extraction and report development from healthcare systems.

Benefits & Perks

• Attractive compensation and benefits package.
• Educational Incentive of 2.5% for associate degree, 3.5% for bachelor's degree, or 5% for graduate degree.
• Annual Leave Redemption up to 100 hours per year.
• Annual Leave Accrual of 208 hours per year, increasing to 288 hours after 5 years of service.
• Participation in the County's 401(k) Shared Savings Plan and/or Section 457 Plan with up to a 3% match.
• Flexible credit allowance for medical, dental, and vision insurance.
• Pre-tax benefits for medical, dental, and vision care expenses.
• Participation in the County's defined pension plan.
• 12 paid holidays per year including a floating holiday.
• Hybrid work schedule with teleworking options after training and performance expectations are met.