Data Analyst - Pharmacy

AscellaHealth•Berwyn, PA

2d•Hybrid

About The Position

AscellaHealth is seeking a Data Analyst to join their dynamic team. This role will design and build data transformation workflows, analytical datasets, and reporting solutions to support reliable, scalable analytics across the organization. The Data Analyst will operate 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.

Requirements

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

Nice To Haves

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

Responsibilities

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.