Data Analyst - Pharmacy

We're seeking a Data Analyst to join our dynamic team at AscellaHealth, where your expertise will directly contribute to improving health outcomes for patients with complex, chronic conditions and rare diseases. This role offers the opportunity to develop and maintain data products that support both business operations and decision-making while working alongside industry leaders in specialty pharmaceutical services.

This role designs and builds data transformation workflows, analytical datasets, and reporting solutions that enable reliable, scalable analytics across the organization. The Data Analyst operates across the transformation and analytical serving layers, ensuring data is accurate, structured, and consumable for both system integration and end-user reporting. This role partners with senior analysts and business stakeholders to translate business needs into data products that drive insight and performance.

This role is based at AscellaHealth's headquarters in Berwyn, PA, and will be a hybrid role with 3 days per week in the office after an initial training period.

Join AscellaHealth - Where innovation Meets Patient Care

About the role

Critical parts of the job/Key Responsibilities

Data Transformation & Pipeline Development

• Design, build, and maintain data workflows using tools such as Alteryx and SQL to extract, transform, enrich, and validate data from multiple sources.
• Develop curated datasets that serve as reliable inputs for both operational systems and analytical reporting.
• Implement data quality checks and validation logic within workflows to ensure accuracy and consistency.
• Optimize data workflows for scalability, reliability, and efficiency.

Analytical Data Products

• Design and maintain dashboards, reports, and analytical outputs using tools such as Power BI.
• Translate business requirements into structured reporting solutions and KPIs.
• Ensure analytical outputs are consistent, accurate, and aligned with defined business logic.

Operational Data Products

• Develop and support data outputs that feed operational systems (e.g., adjudication platforms, CRM systems).
• Ensure data structures, formats, and delivery mechanisms meet system requirements.
• Collaborate with business and technical teams to align data outputs with operational workflows.

Data Analysis & Insight Support

• Perform structured analyses on claims, patient, and operational datasets.
• Identify trends, variances, and key performance drivers.
• Support Senior Data Analysts in developing deeper diagnostic insights and recommendations.

Data Quality & Validation

• Validate outputs from transformation workflows and ensure alignment with business rules.
• Investigate discrepancies and perform root cause analysis.
• Partner with Specialists to ensure upstream execution and data quality standards are met.

Operational Support & Coverage

• Provide backup support for recurring analytics operations, including workflow execution and report refreshes, during periods of high volume or resource constraints.
• Assist with data validation and quality checks on outputs as needed.
• Support testing and validation of system-related data processes in coordination with Specialists and the Business Solutions team.
• Perform other related duties as assigned or as necessary; remain flexible and adaptable in work schedules and work assignments as defined by departmental and organizational needs.

• Adept at managing multiple projects and completing deliverables on schedule.
• Excellent, transparent, and persuasive communication and presentation skills.
• Ability to thrive in a fast-paced environment with constantly changing and competing priorities.
• Excellent analytical skills and the ability to provide solutions to complex problems.
• Ability to be highly transparent, ethical, and driven.
• Relentless attention to detail, and the ability to be a creative self-starter and team player.
• Excellent written and verbal communication skills and interpersonal skills required.
• A passionate and curious person who looks to continuously learn and embraces the adoption of new technologies that impact business, markets, and user experiences.
• Comfortable learning new software and utilizing multiple programs at once to accomplish complex tasks.
• Ability to communicate with all levels within an organization and with clients, customers, and vendors.
• Ability to think and act independently, formulate, and support new ideas, champion new initiatives within and beyond the scope of own responsibilities.

Qualifications

• Bachelor's degree preferred (Analytics, Business, Healthcare, Information Systems, or related field of study)
• 2 or more years of experience in data analysis, reporting, or analytics is required

Preferred Qualifications

• Experience in healthcare, pharmacy, or PBM environment preferred
• A pharmacy tech certificate (CPhT) preferred

Ready to make an impact? Join us on our mission to transform specialty pharmaceutical services and improve patient lives. We're looking for passionate professionals who share our commitment to excellence and innovation. Apply today and become part of a team that's shaping the future of healthcare.

AscellaHealth is a mission-driven, global healthcare company focused on solving challenges across the complex specialty and retail pharmaceutical ecosystem-always with patients at the center of what we do. We partner with payers, pharmaceutical manufacturers, and healthcare stakeholders to improve access to critical therapies through technology-enabled solutions that span the full pharmaceutical lifecycle, from commercialization and specialty pharmacy to care coordination, distribution, and pharmacy management. Supporting more than 450 health partners and 1.2 million patients worldwide, our work makes a meaningful difference every day. What sets AscellaHealth apart is our culture. We are a collaborative, entrepreneurial team that values transparency, continuous learning, and shared purpose. Employees are encouraged to bring ideas forward, take ownership of their work, and grow alongside a company recognized by Inc. and the Financial Times for sustained success. At AscellaHealth, you'll find a supportive environment where your contributions matter and your work helps shape the future of specialty healthcare.