Our unique approach to pharmacy benefits helps more than 20 million patients get access to life changing and often lifesaving medications.
Elixir was born from a desire to create a better way for people to get the prescription drugs they need. Over the years, we’ve been thoughtful about our growth and now own all of the pieces needed to optimize the full pharmacy care experience. As a part of the Rite Aid Corporation- one of the nation’s leading drugstore chains- Elixir is poised to maintain our rapid growth and continuous innovation.
Job Summary
The Lead Data Analyst is responsible for performing analysis and developing tools and automation to support and drive efficiency for Elixir’s rebate aggregator operations process, involving file transfers, reporting, rejection management, trending, and rebate reconciliation. This position has no direct reports.
Responsibilities
The associate is responsible for the functions below, in addition to other duties as assigned:
- Support Elixir’s rebate aggregator operations process involving file transfers, reporting, rejection management, trending, and reconciliation by performing analysis and developing automation to facilitate improved file submissions/tracking, rejection reporting, trend management and reconciliation.
- Provide and/or develop consultation regarding trends, forecasting and reconciliation.
- Develop departmental dashboards/scorecards for executive leadership using sophisticated tools (Tableau or similar).
- Conduct ad-hoc and recurring analysis using SQL, Excel, Tableau, and Alteryx.
- Participate in development and implementation of initiatives, as needed, to improve processes and procedures
- Understand and learn key rebate revenue and cost drivers with the ability to recognize and communicate impact of contractual changes through variance and what-if analysis.
- Conduct and/or report on special studies and investigations.
- Other duties as assigned.
REQUIREMENTS:
- Bachelor’s degree required, preferably in business, mathematical, statistical, financial, or health administration discipline
- Minimum 2 to 5 years’ experience in a financial and/or statistical reporting capacity preferably in the healthcare, insurance, or PBM industry
- Advanced skill in SQL queries and Excel modeling.
- Strong data analysis and presentation skills
- A proactive individual with a strong desire to create, learn, and share their work
- Ability to collaborate with colleagues, team, and organization to ensure collective success
- Demonstrated ability to manage multiple priorities and deadlines
- A well-organized and self-directed individual who is able to work with minimal amount of supervision
- Sound technical skills, analytical ability, good judgment and strong operational focus
- Proficient in Microsoft Office and industry related software programs
PREFERRED QUALIFICATIONS:
- SQL, Tableau, Alteryx, Crystal, MS Access
WORK ENVIRONMENT:
Includes a typical office environment, with minimal exposure to excessive noise or adverse environmental issues.
PHYSICAL REQUIREMENTS:
Ability to sit for prolonged periods of time.
Qualifications
The typical starting pay range for this position is between $63,252.75 to $99,845.25 although wages can vary based on experience and geography.
Fair Chance Act
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Pursuant to the Los Angeles Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Pursuant to the California Fair Chance Act, we will consider qualified applicants with a criminal history. You do not need to disclose your criminal history or participate in a background check until a conditional job offer is made to you. After making a conditional offer and running a background check, if we identify a conviction that is directly related to the job, you will be given the chance to explain the circumstances surrounding the conviction, provide mitigating evidence, or challenge the accuracy of the background report. Find out more about the Fair Chance Act by visiting the Civil Right’s Department Fair Chance Act webpage.
For more detailed information around city/state required notices, click here to access a list of disclosures.
New Jersey Law Against Discrimination (LAD)
The New Jersey Law Against Discrimination (LAD) prohibits unlawful employment discrimination based on an individual’s race, creed, color, national origin, nationality, ancestry, age, sex (including pregnancy), familial status, marital/civil union status, religion, domestic partnership status, affectional or sexual orientation, gender identity and expression, atypical hereditary cellular or blood trait, genetic information, liability for military service, and mental or physical disability (including perceived disability, and AIDS and HIV status).
EEO Statement
Rite Aid is an equal opportunity employer and is committed to cultivating a diverse work environment where individual differences are appreciated and respected. It is our policy, through responsible management, to recruit, hire, train, and promote associates regardless of their race, color, national origin, religion, sex, sexual orientation, disability, age, or any other basis protected by state or federal law. The objective of this policy is to ensure conformity with the principles of equal opportunity employment when making employment decisions and administering compensation, benefits, transfer, and social and recreational programs. Rite Aid prohibits unlawful retaliation against any person who reports harassment or discrimination.
ms-access crystal-reports Tableau SQL data-management Microsoft Excel alteryx