UCSF Prima Clinics - 0657 - BUS SYS ANL 4 - Senior Programmer Analyst Population Health - T51736 (648602)
Previous Job
UCSF Prima Clinics - 0657 - BUS SYS ANL 4 - Senior Programmer Analyst Population Health - T51736 (648602)
Ref No.: 18-02643
Location: California
Start Date / End Date: 09/03/2018 to 02/28/2019
Job Function Summary:
Involves technology-based analysis of business practices, processes and problems; developing solutions which may involve process design, data and information architecture, software development and policy or procedural changes; creating specifications for systems to meet requirements; validating requirements against needs; designing details of automated systems; developing user interface design; planning and executing unit integration and end-user acceptance testing; may develop training materials for system implementation. May lead cross-functional teams to solve complex business or systems issues.

Generic Scope):
Technical leader with a high degree of knowledge in the overall field and recognized expertise in specific areas; problem-solving frequently requires analysis of unique issues / problems without precedent and / or structure. May manage programs that include formulating strategies and administering policies, processes, and resources; functions with a high degree of autonomy.

Custom Scope
The Senior Analyst position in the Office of Population Health and Accountable Care (OPHAC) is an exciting new role that combines advanced analytic skills with strategic planning. Our mission in Population Health is to meet health system goals for our ambulatory clinics, focusing on performance tracking and quality improvement in-patient populations for which we are financially at risk. Our projects involve internal collaboration with Quality, Faculty Practice, and Population Health leadership, as well as external partnerships with health plans, medical groups, and other key stakeholders.

In partnership with the analytic team, OPHAC leadership, and other departments, the Senior Analyst builds the reporting strategy to support new and ongoing clinical needs. In addition, the Senior Analyst will play a key role in supporting the Population Health data warehouse in accordance with clinical and business initiatives (e.g. building clinical registries). The Senior Analyst builds methods to predict health outcomes for our patient populations, with an initial focus on optimizing OPHAC clinical programs. By creating assessment tools to predict the right intervention for the right patient at the right time, s/he will optimize our ability to identify patient care needs and increase patient engagement and satisfaction.

The Senior Analyst will partner with the Population Health analytic team with primary responsibilities including: data collection, benchmarking, performance and health outcome measurement, segmentation of populations, and risk stratification. The Senior Analyst is passionate about quality improvement and eager to collaborate with key clinical and business partners to identify new ways to improve care delivery for our patients.

Department Overview
The Office of Population Health and Accountable Care (OHPAC) leads and facilitates the implementation of population-based at-risk contracts, developing the internal infrastructure and external relationships to further CLIENT Health System's ability to engage in and successfully manage ACO and other risk-based contracts and provide high value care to a defined population of patients.

Key Responsibilities
Develop sophisticated SQL (structured query language) queries to support and report templates for ad hoc and ongoing report requests. Extract and analyze data from CLIENT's electronic medical record system (Epic/APeX)
Produces in-depth forecasts, analyses, reports, data sets, and recommendations to leadership and stakeholders.
Develop predictive modeling tools to identify and address key health outcomes for patient populations across ambulatory care
Collaborate with key clinical and business personnel and management on advanced project teams to identify appropriate analytic objectives and solutions
Support ETL processes (extract, transform, load) for data warehouse needs
Meticulously document work to assure ability for replication and cross-training

Knowledge Skills and Abilities (KSAs)
In-depth knowledge of key clinical quality standards (CMS QI standards and other regulatory requirements), QI models, tools, and techniques, including collection, abstraction, validation, analysis, and reporting of data, and use of performance and benchmark indicators. Required
Advanced critical thinking and problem-solving skills to manage multiple levels of highly-complex information and responsibilities, to quickly assess problems, and to develop and implement timely and effective solutions. Required
Advanced interpersonal skills for collaborating effectively with a broad range of clinical and technical staff Required
Advanced skills in written and verbal communications, with the ability to convey complex clinical andtechnical information in a clear and concise manner, and to produce high-quality reports, documentation, and presentations. Required
Strong knowledge of and proficiency in Epic, Clarity, and software applications (Word, Excel, PowerPoint, Access) Required
Advanced technical skills to lead highly-complex projects, developing sophisticated SQL (structured query language) queries and report templates, and producing in-depth forecasts, analyses, reports, data sets, and recommendations to support and enhance clinical and business processes Required
Advanced technical skills to support and maintain the data warehouse environment Required
Highly proficient in SQL and one of the following: Excel VBA, R, Python, Tableau Required
Discretion, confidentiality, tact, and ability to deal with sensitive data involving patient health information Required
Proficiency with data extraction and analysis of Allscripts Preferred

Education, Licenses and Certifications:
Master's Degree in biostatistics, applied statistics, operations research or other relevant field, with 5-7 years of healthcare experience.
PhD with 2-5 years related experience. Preferred

Certified in at least one Epic Clarity module (preferred: Ambulatory or Inpatient) Preferred