Technical Reporting Analyst

Essential Job Responsibilities Include:

• Develop and maintain Excel-based tools with advanced VBA to streamline data workflows and reporting.
• Build and enhance SAS or data 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 data 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.
• Focus on list management, ensuring that all lists for PBM pricing are accurate and up to date. Ability to analyze list changes and report out on significant differences between versions.

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, SAS or other database querying tools

Based on relevant market data and other factors, the anticipated hiring range for this role is $80,000 - $95,000 annually. Final compensation rates will be determined based on various factors, including but not limited to experience, skills, knowledge, and internal equity considerations. This role is also short-term incentive eligible. Incentive amounts will vary by individual and business goals. 

We are committed to fair and equitable compensation practices. The final salary offered to the selected candidate may vary from the posted range due to individual qualifications. Our goal is to ensure that all teammates are compensated fairly and competitively based on their contributions to our organization.

RxBenefits is also committed to providing best in class benefits to our teammates.  We offer a robust total rewards package that includes:

• Remote first work environment
• Choice of a HDHP or PPO Medical plan, we pay 100% of the premium for the HDHP for you and your eligible family members
• Dental, Vision, Short- and Long-Term Disability, and Group Life Insurance that we also pay 100% of premiums (for your family too on Dental and Vision)
• Additional buy-up options for Short- and Long-Term Disability and Life Insurance
• 401(k) with an employer match up to 3.5% available after 60 days
• Community Service Day to give back and support what you love in your community
• 10 company holidays including MLK Day, Juneteenth, and the day after Thanksgiving plus a floating holiday to use as you like
• Reimbursements for high-speed internet, we’ll send you a computer and monitors to help you do your best work
• Tuition Reimbursement for accredited degree programs
• Paid New Parent Leave that can be used for adoption or birth
• Pet insurance to protect your furbabies
• A robust mental health benefit and EAP service through Spring Health to support you when you need it most