Data System Analyst 4 (2)

UCSF Health; San Francisco (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

UCSF Health is seeking a Data Systems Analyst, Pharmacy Analytics to design and administer data-based systems, ensuring data integrity and timely reporting for revenue cycle workflows.

The role requires advanced data management, dashboard development, and cross-functional collaboration across Pharmacy Services and IT, contributing to clinical finance insights and process improvements in a leading academic medical center setting.

Qualifications

• Experience designing and creating reports, scorecards, and dashboards using Tableau, Power BI, or any data visualization tools.
• In-depth understanding of revenue cycle metrics and dashboard design.
• Strong organizational and project management skills with ability to lead a team and deliver on schedule.
• Advanced report development and dashboard design for healthcare revenue cycle and related tools.
• Ability to interpret clinical finance information clearly for all staff and management.
• Analytical and problem-solving skills to optimize workflows and systems.

Responsibilities

• Design and maintain dashboards and scorecards for revenue cycle analytics.
• Interpret and communicate complex financial data to management and stakeholders.
• Lead analytics projects across Pharmacy Analytics and related departments.
• Collaborate with IT and clinical teams to ensure data integrity and governance.
• Support data quality initiatives and improve data production processes.

Skills

Tableau

Power BI

SQL/Database

MS Excel

Data Visualization

Revenue Cycle

Project Leadership

Communication

Tools

SQL Server/Access

MS Access

Job description

Job Description

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.

Job Description

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.

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 Us

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: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html