Pharmacy Analytics Data Systems Lead

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

Job summary

UCSF in San Francisco seeks a Data Systems Analyst, Pharmacy Analytics to design and manage data production processes for the pharmacy revenue cycle. You will develop reports and dashboards to monitor clinical and financial performance, collaborate with stakeholders, and ensure data integrity across systems.

The role requires strong SQL/Excel skills, experience with Tableau or Power BI, and the ability to translate complex clinical finance information into actionable insights for leadership.

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.

Responsibilities

• Designs, deploys, and manages SQL Server reports to meet the automated monitoring needs of various stakeholders.
• 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.
• Creates and implements SQL Server Integration packages to automate data integration, migration, and transformation tasks.
• Performs advanced data analyses to extract actionable insights from pharmacy clinical and revenue cycle data.
• Manages Pharmacy Analytical Tools to identify potential data and/or data integrity issues to reduce claim denials and improve revenue capture.
• Collaborates with stakeholders to understand reporting requirements and translates them into effective data analysis solutions.
• Documents best practice guidelines to assure consistency across projects within the Pharmacy Analytics Team.
• Participates in various workgroups serving as the subject matter expert as it relates to pharmacy data.
• 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.

Skills

Tableau

Power BI

Data visualization

Tools

MS Excel

SQL Server

SQL

Access

Word

Visio

PowerPoint

Job description

UCSF in San Francisco seeks a Data Systems Analyst, Pharmacy Analytics to design and manage data production processes for the pharmacy revenue cycle. You will develop reports and dashboards to monitor clinical and financial performance, collaborate with stakeholders, and ensure data integrity across systems.

The role requires strong SQL/Excel skills, experience with Tableau or Power BI, and the ability to translate complex clinical finance information into actionable insights for leadership.