Senior 340B Data Analyst

Primary Function/General Purpose of Position

The Senior 340B Data Analyst is responsible for development and management of the Structured Query Language (SQL) database queries and Microsoft Access Visual Basic for Applications (VBA) macros related to 340B auditing activities. Under the leadership of the 340B Program Manager, this role is tasked with project management, configuration, and maintenance of software systems, automation of manual program auditing tasks, and other projects as assigned.  The Senior 340B Data Analyst is responsible for translating and programming vast amounts of data into understandable, relevant, and actionable information. It is essential for this role to be actively engaged in developing and promoting effective data governance through documentation and adherence of standards to assure that the information produced and provided by the 340B team is accurate and trusted as the source of truth. 

Essential Job Functions

• Creates and maintains monthly reports and dashboards of 340B program metrics and financial savings

• Translates data needs of the program and organization executive leadership to structure and provide recurring data extracts or develop custom solutions for strategic initiatives

• Serves as the split billing software expert in order to troubleshoot software or data issues and continually improve software functionality

• Partners with appropriate teams to ensure that the 340B software is coordinated and integrated with the clinical information system software, including the electronic interface between the electronic health records and the virtual accumulator and any interface between the organization and contract pharmacy providers and administrators

• Ensures integrity of split billing software and reviews applicable software reports to identify areas of improvement

• Triages live-site issues within the split billing software, electronic medical record, or charge master as it relates to 340B 

• Collaborates with EPIC charge team and charge master managers on process improvement initiatives and implementation of any necessary changes

• Coordinates covered entity issue resolution process with split billing software vendor and ensures appropriate split billing software configurations are in place and continually updates software to ensure alignment with revenue cycle, charging practices, EPIC build, and Organizational Policies

• Participates in the development, documentation, and on-going maintenance of a data governance operation 

• Develops effective auditing and validation processes between the source systems and the centralized data warehouse to assure accurate and timely availability of data

• Develops, tests, and delivers reports and extracts from the centralized data warehouse using appropriate business intelligence (BI) tools

• Solves complex data problems to deliver insights that helps our ministry achieve our goals

• ​Partners with business analysts and solutions architects to develop technical architectures for strategic enterprise projects and initiatives.

This document is not an exhaustive list of all responsibilities, skills, duties, requirements, or working conditions associated with the job. Employees may be required to perform other job-related duties as required by their supervisor, subject to reasonable accommodation.

Licensing/Certification

340B University Certificate - Apexus (required)

340B Advanced Operations Certificate - Apexus (preferred)

Education

Bachelors' Degree in Healthcare Administration, Business, Finance, Information Technology, Analytics, Pharmacy, Computer Science, Management Information Systems, or a related field (required)

Work Experience

Minimum of 2 years’ experience with pharmacy 340B (required)

Minimum of 3 years’ experience in business, analytics, or auditing (preferred)