Data System Analyst 4 (2)

Involves technical acumen for planning, designing, developing, implementing and administering data-based systems that acquire, prepare, store and provide access to data and metadata. Maintains and optimizes systems and migrates data and systems as needed. Ensures integrity and completeness of data and workflow, manages and / or develops data practices, databases and information systems as well as guidelines, dictionaries, registries and / or services. May include interpretation of scientific research data artifacts as well as mediation across science and technology domains and long-term data care. As information architect and data steward, designs systems, data products and / or data production processes while focusing on data curation, data exchange, data security, data integrity and information environments. Reevaluates frameworks, strategies, standards and standards-making activities. May involve work with a project-level data repository, a center or an archive.

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. Having significant experience, the Data Systems Analyst, Pharmacy Analytics applies advanced data / information management concepts and medical center objectives to resolve highly complex issues where analyses of situations, information or data require an in-depth evaluation of variable factors. The Data Systems Analyst, Pharmacy Analytics selects methods and techniques to obtain desired results, managing projects at all levels of complexity and scope. Additionally, the Data Systems Analyst, Analytics has a high degree of knowledge in revenue cycle functions and is a recognized expertise in data analytics; 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. Department Overview: The Department of Pharmaceutical Services provides a full range of contemporary services for patients cared by the UCSF Medical Center, as well as its providers and payers. The UCSF Pharmacy Enterprise encompasses Inpatient Pharmacy Services, Ambulatory Care Services, Specialty Drug Pharmacy, Pharmacy Business Services, Pharmacy Informatics, Medication Safety and Regulatory Compliance, Oncology Infusion Services, 340B Management, Pharmacy Revenue Cycle and Central Pharmacy Production and Repackaging Services. The Department of Pharmaceutical Services is fully responsible for the medication use process across the health system. The services provided by pharmacy include, but are not limited to, drug procurement, drug storage and security; safe, accurate and timely preparation and distribution of drugs; clinical pharmacy services for patients; drug information services for clinicians and patients; retail specialty drug pharmacy services; ambulatory care pharmacy services; oversight of sate medication practices; antimicrobial stewardship; pharmacy oncology infusion services; pharmacy revenue cycle; central drug production and distribution with state-of-the-art automation; and development and management of drug use policies and procedures within the Medical Center. The Departmentis integrated with theDepartment of ClinicalPharmacy, an academic campus unit within the School of Pharmacy,which has a primary responsibility for teaching professional courses in the PharmD curriculum, research, and publicservice. Department of Pharmaceutical Services provides inpatient pharmacy services for Moffitt Long Hospital at Parnassus, Benioff Children’s Hospital in Mission Bay and Mount Zion Hospital. The inpatient pharmacies provide clinical and drug distribution services to the associated clinics and medical offices of each hospital. Responsibilities

% Time Essential Function Yes/No 35% YES Designs, deploys, and manages SQL Server reports to meet the automated monitoring needs of various stakeholders. Develops and maintains Tableau dashboards to facilitate data-driven decision-making across the Pharmacy Enterprise. Designs, maintains, and recommends improvements for MS SQL Server databases, including those that support the Pharmacy Analytics web application. 15% YES Plans and conducts data analysis efforts for highly complex small and medium-sized projects that may include managing partnerships between multiple institutions. Establishes or maintains information documentation standards such as data naming standards and value domain descriptions. Schedules and conducts analysis sessions. Documents ownership, custody and access requirements for data subject areas. 10% YES Creates and implements SQL Server Integration packages to automate data integration, migration, and transformation tasks 15% YES Performs advanced data analyses to extract actionable insights from pharmacy clinical and revenue cycle data 5% YES Manages Pharmacy Analytical Tools to identify potential data and/or data integrity issues to reduce claim denials and improve revenue capture. 5% YES Collaborates with stakeholders to understand reporting requirements and translates them into effective data analysis solutions 5% YES Documents best practice guidelines to assure consistency across projects within the Pharmacy Analytics Team 5% YES Participates in various workgroups serving as the subject matter expert as it relates to pharmacy data. 5% YES Works with Information Technology to define needs and system enhancements. Design models, using input from departments, operational experience, and best practice research. Statistical and financial results in departments and on the workflows and system efficiencies. 100% 100% (To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%.)

Qualifications

Required Qualifications: Experience designing and creating reports, scorecards, and dashboards using Tableau, Power BI, or any data visualization tools.

In-depth understanding of the issues, processes, reporting instruments, metrics, dashboard design, and other tools and techniques involved with measuring and analyzing the revenue cycle.

Advanced organizational and project management skills, and ability to lead a team, prioritize tasks, and see projects through from inception to completion on schedule.

Advanced skills in report development, dashboard design, and various software tools specific to healthcare revenue cycle management. Skills in common database, spreadsheet and presentation software.

Advanced communications skills, with the ability to interpret and convey complex clinical finance information in a clear, concise manner. Ability to prepare compelling and informative reports and presentations to all levels of staff and management.

Advanced analytical and problem-solving skills, with the ability to evaluate the effectiveness of workflows and systems in revenue cycle program areas, to identify weaknesses and develop innovative solutions and process improvements.

Advanced interpersonal skills, with the ability to collaborate effectively on highly-complex projects in a team environment with a wide variety of business and clinical areas.

Strong ability to advise management, serving as a technical expert, providing proposals for improvement and guidance on regulatory changes and industry trends and developments in revenue cycle management.

Thorough knowledge of issues in pharmacy revenue cycle, billing, claims processing and reimbursement.

Knowledge of Pharmacy Revenue Management Tools. Skills to effectively utilize the tools to produce meaningful findings and actionable intelligence.

In-depth knowledge of the practices, procedures, and concepts of the healthcare revenue cycle and its component operations, including billing, collections, charge capture, contractual adjustments, third-party reimbursements, and cash management.

High degree of knowledge of MS Excel required; Experience with MS Application (e.g. Word, Visio, PowerPoint, SQL Server/Access)

Three (3) years of experience

Preferred Qualifications: Knowledge of and experience working with Healthcare specific EMR, Decision Support, and Financial accounting software. (e.g. Epic, Tag Bio or similar).

About UCSF The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world’s leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells. Pride Values UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence – also known as our PRIDE values. In addition to our PRIDE values, UCSF is committed to equity – both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available here. Join us to find a rewarding career contributing to improving healthcare worldwide. Equal Employment Opportunity The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law. Salary Information The final salary and offer components are subject to additional approvals based on UC policy. Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement. To learn more about the benefits of working at UCSF, including total compensation, please visit: