Senior Data Analyst SAS Pricing

Job Title: Senior Data Analyst SAS Pricing
Job Type: Full Time
Job Location: Remote, USA

The senior data analyst is responsible for supporting internal and external clients through planned strategic analyses of pharmacy claims data. This position will utilize analytic tools to provide insight that allows the company and our clients to make better-informed decisions in various areas such as pharmacy benefit plan performance, claims forecasting, pricing savings analyses, member disruption, key initiatives, and auditing. The position will work with various individuals within the organization, including sales, account management, and consultants, in developing and executing analytic deliverables.

Essential job responsibilities include
Develop and maintain Excel-based tools with advanced VBA to streamline data workflows and reporting.
Build and enhance SAS programs for claims repricing, rebate projections, and performance benchmarking.
Aggregate and manipulate pharmacy claims data from multiple PBM pricing products (e.g., CVS, Optum, Express Scripts).
Create dynamic, template-driven solutions to standardize outputs across varying account structures and formats.
Collaborate with cross-functional stakeholders to support rebate forecasting, contract modeling, and business strategy.
Troubleshoot issues related to data access, file locking, and macro compilation in SAS environments.
Maintain version control and documentation for reusable code libraries and analytical frameworks.
Design and implement QC checks to ensure data integrity throughout transformation pipelines.
Support ad-hoc analysis for internal leadership and external partners.

Required Skills / Experience:
Bachelor's degree in Data Science, Computer Science, Public Health, Statistics, or related field.
5+ years of experience data analytics experience, specific to Pharmacy / PBM industry.
Proficiency in SAS and Python, including macro development, data step processing, and Excel export/import automation.
Advanced Excel skills, including VBA scripting and dynamic template design.
Strong analytical and problem-solving skills, with a keen attention to detail.
Experience working with large datasets and multi-step processing pipelines.
Excellent written and verbal communication skills.

Preferred Skills/Experience:
Expertise in pharmacy claims data and PBM contract structures.
Experience with Jira or other ticket management systems for tracking analytical requests.
Working knowledge of Python, Snowflake, SQL, or other database querying tools