Data Analyst - Pharmacy Berwyn, PA

Ascella Health | Berwyn, PA | Hybrid work schedule (3 days in office)

Shape the Future of Healthcare

We’re seeking a Data Analyst to join our dynamic team at Ascella Health, 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 Ascella Health’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 Ascella Health – Where innovation Meets Patient Care

• 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.

• 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.

• 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.

• 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.

• 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.

• 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…