At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues - caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day. Position Summary:
The Sr. Analyst, Pharma Reporting will be responsible for ensuring the successful delivery of pharmaceutical manufacturers' (Pharma) contractual reporting requirements and providing post-production support for Pharma's data and reports. Key responsibilities include:
Want more jobs like this?
Get jobs in Albany, NY delivered to your inbox every week.
- Reviewing and redlining Pharma's data reporting contracts to ensure that reporting requirements, including data quality and specifications, are clearly understood and adequately captured within the contract.
- Assessing the feasibility of delivering data according to Pharma's contractual needs by conducting necessary research within our Specialty Pharmacy systems and collaborating with our Specialty data systems partners.
- Collaborating with CVS Specialty & Retail Trade teams to understand upcoming data project needs and product pipelines while providing relevant updates on project implementations and support activities.
- Creating and maintaining business requirements documentation based on Pharma's contractual data specifications and ensuring that the requirements are clearly communicated to the project team and other internal stakeholders.
- Acting as the designated point of contact for Pharma and their third parties (HUBs and Data Aggregators) during contract redlining, project implementation, and ongoing support of Pharma's data and reports. Leading any data-related discussions and addressing data-related questions.
- Thoroughly reviewing and investigating any data issues, concerns, or questions in a timely manner, and ensuring that any data issues are addressed according to contractual SLAs.
- Partnering with external and internal teams as needed to address data questions and issues.
- Conducting root cause analysis of incoming data concerns that do not comply with Pharma contracts to remediate the issue and prevent it from occurring again in the future.
- Executing and modifying simple and moderately complex SQL queries to combine, parse, extract, and manipulate data to aid in the analysis and resolution of complex data requests/issues.
- Collaborating with the development team and Account Managers to analyze and collect meaningful metrics and insights for Quarterly Business Review meetings with Pharma.
- Closely tracking Pharma reporting projects/intake for successful delivery.
- Handling other responsibilities that may arise related to servicing data requests for our Pharma clients.
Creating and reviewing business and technical documents and contract language pertaining to data reporting requests by pharmaceutical manufacturers to demonstrate understanding of data commitments and implications for the business (15%). Ensuring production inquiries are resolved in a timely manner, reviewing, problem-solving, and conducting root cause analysis of incoming data concerns that do not comply with Pharma contracts (20%). Analyzing data and reporting information from data feeds and warehouses to determine the feasibility of data reporting requests from pharmaceutical manufacturers (10%). Tracking project implementations or intake for data-related changes (30%). Executing proper maintenance and centralized storage of key project documentation, including business requirements, technical specifications, design documents, test plans, etc. (10%). Writing and executing simple and moderately complex SQL queries to combine, parse, extract, and manipulate data to aid in data reporting (15%). Required Skills:
- 1+ year of SQL experience or other relevant programming experience.
- Intermediate MS Excel knowledge.
- 2+ years of experience working in a professional services environment with clients/stakeholders, preferably in reporting requirements, data reconciliation, and root cause analysis.
- Ability to influence and build effective working relationships with all stakeholders.
- Must have a "can do" attitude and effective oral and written communication skills.
- Intermediate analytical and problem-solving skills.
- Knowledge of requirements documentation (business requirements, functional requirements, solution requirements, etc.).
- Experience reviewing and redlining contractual documents.
- 1+ years of healthcare experience; specialty pharmacy experience a plus
- 2+ years of experience working in a client-facing role.
- Knowledge of Teradata, Google Big Query, Snowflake, and Oracle databases.
Bachelor's Degree with a concentration in Information Systems, Mathematics, Computer Science, Statistics, Analytics, Accounting, or other scientific-related field of study, or 4 years of equivalent work experience. Anticipated Weekly Hours
40Time Type
Full timePay Range
The typical pay range for this role is:$46,988.00 - $112,200.00This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.Great benefits for great peopleWe take pride in our comprehensive and competitive mix of pay and benefits - investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:
- Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.
- No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
- Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.