What are the responsibilities and job description for the Data Analyst position at FountainRx Specialty Pharmacy?
Description of Responsibilities
The Data Analyst supports the operational, clinical, and financial performance of FountainRx's specialty, compounding, and retail pharmacy lines by transforming data into actionable intelligence. Specialty pharmacy operations are the primary focus of this role; compounding and retail are secondary. The Data Analyst works under the direction of the Director of Information Technologies and serves a broad stakeholder base that includes internal leadership and external partners such as pharmaceutical manufacturers, payers, and hub organizations.
This role is responsible for collecting, validating, analyzing, and presenting data across dispensing, revenue cycle, inventory, clinical outcomes, regulatory compliance, and manufacturer and hub reporting functions. The Data Analyst shall maintain a thorough understanding of pharmacy operations and data systems at FountainRx and adhere to all applicable data privacy, security, and compliance requirements.
Responsibilities of the Data Analyst include the following:
Reporting and Dashboard Development
1) Design, build, and maintain recurring and ad hoc reports and dashboards for internal leadership across specialty, compounding, and retail pharmacy operations, with specialty as the primary focus.
2) Translate complex data sets into clear, accurate, and visually effective presentations suitable for executive, operational, and clinical audiences.
3) Develop and deliver standardized data packages for external stakeholders including pharmaceutical manufacturers, payers, hub organizations, and regulatory bodies as required.
4) Ensure all reports are delivered accurately and on schedule; proactively communicate delays or data quality issues to the Director of Information Technologies.
Dispensing and Prescription Operations
5) Analyze prescription volume, dispensing patterns, fill rates, and workflow throughput across specialty, compounding, and retail pharmacy lines.
6) Identify operational trends, bottlenecks, and opportunities for improvement; present findings with supporting data to appropriate stakeholders.
7) Monitor and report on specialty-specific metrics including adherence rates, refill patterns, time-to-fill, and patient retention.
Revenue Cycle and Payer Analytics
8) Support revenue cycle analytics including claims submission rates, adjudication outcomes, denial trends, reimbursement performance, and payer mix.
9) Prepare payer-facing data reports and analyses to support contracting, performance reviews, and reimbursement discussions.
10) Identify claim rejection patterns and collaborate with revenue cycle and operations personnel to surface root causes and improvement opportunities.
Inventory and Purchasing Analytics
11) Analyze inventory levels, purchasing patterns, drug utilization, and cost trends across pharmacy lines to support operational and financial decision-making.
12) Provide data to support formulary management, purchasing negotiations, and inventory optimization initiatives.
13) Monitor and report on drug shortage impacts, substitution activity, and related supply chain metrics.
Clinical Outcomes and Program Reporting
14) Support data collection, analysis, and reporting for clinical programs including the FountainRx Cares program and equivalent specialty clinical initiatives.
15) Compile and present patient outcome metrics, adherence data, disease state reporting, and quality benchmarks for internal clinical leadership and external manufacturer or program requirements.
16) Assist in the development of outcome measurement frameworks and reporting templates as clinical programs evolve.
Manufacturer and Hub Reporting
17) Prepare and deliver required data submissions to pharmaceutical manufacturers and hub organizations, including patient experience feedback, Risk Evaluation and Mitigation Strategy (REMS) reporting, adherence metrics, and program performance data.
18) Maintain accurate records of manufacturer and hub reporting obligations, schedules, and submission history.
19) Serve as a data point of contact for manufacturer and hub partners, responding to data requests in coordination with the Director of Information Technologies and relevant operational leadership.
Regulatory and Compliance Reporting
20) Support preparation of data required for regulatory submissions, accreditation reviews, and compliance audits across specialty, compounding, and retail pharmacy operations.
21) Ensure all data handling, storage, and transmission activities comply with the Health Insurance Portability and Accountability Act (HIPAA), applicable state law, and FountainRx data governance policies.
22) Assist in maintaining data integrity standards and internal controls over reporting processes.
Data Management and Systems
23) Extract, clean, validate, and maintain data from pharmacy management systems, claims platforms, and other operational data sources.
24) Apply proficiency in Excel and Structured Query Language (SQL) to support data retrieval, transformation, and analysis; leverage business intelligence tools as available.
25) Coordinate with the Director of Information Technologies and relevant vendors on data access, system integration, and reporting infrastructure needs.
26) Other projects, activities, or responsibilities assigned at the discretion of the Director of Information Technologies or their designee.
Minimum Qualifications
Physical Requirements and Work Environment
The Data Analyst supports the operational, clinical, and financial performance of FountainRx's specialty, compounding, and retail pharmacy lines by transforming data into actionable intelligence. Specialty pharmacy operations are the primary focus of this role; compounding and retail are secondary. The Data Analyst works under the direction of the Director of Information Technologies and serves a broad stakeholder base that includes internal leadership and external partners such as pharmaceutical manufacturers, payers, and hub organizations.
This role is responsible for collecting, validating, analyzing, and presenting data across dispensing, revenue cycle, inventory, clinical outcomes, regulatory compliance, and manufacturer and hub reporting functions. The Data Analyst shall maintain a thorough understanding of pharmacy operations and data systems at FountainRx and adhere to all applicable data privacy, security, and compliance requirements.
Responsibilities of the Data Analyst include the following:
Reporting and Dashboard Development
1) Design, build, and maintain recurring and ad hoc reports and dashboards for internal leadership across specialty, compounding, and retail pharmacy operations, with specialty as the primary focus.
2) Translate complex data sets into clear, accurate, and visually effective presentations suitable for executive, operational, and clinical audiences.
3) Develop and deliver standardized data packages for external stakeholders including pharmaceutical manufacturers, payers, hub organizations, and regulatory bodies as required.
4) Ensure all reports are delivered accurately and on schedule; proactively communicate delays or data quality issues to the Director of Information Technologies.
Dispensing and Prescription Operations
5) Analyze prescription volume, dispensing patterns, fill rates, and workflow throughput across specialty, compounding, and retail pharmacy lines.
6) Identify operational trends, bottlenecks, and opportunities for improvement; present findings with supporting data to appropriate stakeholders.
7) Monitor and report on specialty-specific metrics including adherence rates, refill patterns, time-to-fill, and patient retention.
Revenue Cycle and Payer Analytics
8) Support revenue cycle analytics including claims submission rates, adjudication outcomes, denial trends, reimbursement performance, and payer mix.
9) Prepare payer-facing data reports and analyses to support contracting, performance reviews, and reimbursement discussions.
10) Identify claim rejection patterns and collaborate with revenue cycle and operations personnel to surface root causes and improvement opportunities.
Inventory and Purchasing Analytics
11) Analyze inventory levels, purchasing patterns, drug utilization, and cost trends across pharmacy lines to support operational and financial decision-making.
12) Provide data to support formulary management, purchasing negotiations, and inventory optimization initiatives.
13) Monitor and report on drug shortage impacts, substitution activity, and related supply chain metrics.
Clinical Outcomes and Program Reporting
14) Support data collection, analysis, and reporting for clinical programs including the FountainRx Cares program and equivalent specialty clinical initiatives.
15) Compile and present patient outcome metrics, adherence data, disease state reporting, and quality benchmarks for internal clinical leadership and external manufacturer or program requirements.
16) Assist in the development of outcome measurement frameworks and reporting templates as clinical programs evolve.
Manufacturer and Hub Reporting
17) Prepare and deliver required data submissions to pharmaceutical manufacturers and hub organizations, including patient experience feedback, Risk Evaluation and Mitigation Strategy (REMS) reporting, adherence metrics, and program performance data.
18) Maintain accurate records of manufacturer and hub reporting obligations, schedules, and submission history.
19) Serve as a data point of contact for manufacturer and hub partners, responding to data requests in coordination with the Director of Information Technologies and relevant operational leadership.
Regulatory and Compliance Reporting
20) Support preparation of data required for regulatory submissions, accreditation reviews, and compliance audits across specialty, compounding, and retail pharmacy operations.
21) Ensure all data handling, storage, and transmission activities comply with the Health Insurance Portability and Accountability Act (HIPAA), applicable state law, and FountainRx data governance policies.
22) Assist in maintaining data integrity standards and internal controls over reporting processes.
Data Management and Systems
23) Extract, clean, validate, and maintain data from pharmacy management systems, claims platforms, and other operational data sources.
24) Apply proficiency in Excel and Structured Query Language (SQL) to support data retrieval, transformation, and analysis; leverage business intelligence tools as available.
25) Coordinate with the Director of Information Technologies and relevant vendors on data access, system integration, and reporting infrastructure needs.
26) Other projects, activities, or responsibilities assigned at the discretion of the Director of Information Technologies or their designee.
Minimum Qualifications
- Bachelor's degree in Data Analytics, Health Informatics, Business, or a related field required.
- Minimum two (2) years of experience in a data analysis or reporting role required; healthcare or pharmacy setting strongly preferred.
- Proficiency in Microsoft Excel and SQL required; experience with pharmacy management systems and business intelligence tools (e.g., Power BI, Tableau) preferred.
- Demonstrated ability to collect, clean, analyze, and present complex data sets to varied audiences including executive leadership and external partners.
- Familiarity with pharmacy operations across specialty, compounding, or retail settings preferred; specialty pharmacy experience a plus.
- Working knowledge of revenue cycle, claims processing, or payer reporting preferred.
- Understanding of HIPAA and healthcare data privacy requirements required.
- Strong organizational skills, attention to detail, and ability to manage multiple reporting deadlines simultaneously.
- Effective written and verbal communication skills; ability to work independently and collaboratively across departments.
Physical Requirements and Work Environment
- The physical requirements and working conditions described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodation will be provided in accordance with applicable law.
- Work is primarily sedentary and performed in an office environment, requiring extended periods of sitting and prolonged use of a computer, keyboard, and monitor.
- Must be able to communicate effectively in person, by telephone, and by video conference, and to read and interpret detailed written and numerical information.
- Occasional standing, walking, and lifting of materials or equipment weighing up to twenty-five (25) pounds may be required.