Note: The job is a remote job and is open to candidates in USA. CVS Health is committed to building a world of health around every individual, and they are seeking a Pharmaceutical Reporting Senior Analyst. The role involves ensuring the successful delivery of pharmaceutical manufacturers' reporting requirements and providing support for data and reports, including reviewing contracts, collaborating with teams, and executing SQL queries.
Responsibilities
- 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
Skills
- 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
- 1+ years of SQL experience or other relevant programming experience
- 2+ years of experience working in a professional services environment with clients/stakeholders, preferably in reporting requirements, data reconciliation, and root cause analysis
- Experience working in a client-facing role
- Ability to influence and build effective working relationships with all stakeholders
- A 'can do' attitude
- Effective oral and written communication skills
- Intermediate analytical and problem-solving skills
- Intermediate MS Excel knowledge
- Working knowledge of SQL or other similar programming languages
- Knowledge of requirements documentation (business requirements, functional requirements, solution requirements, etc.)
- 2+ years of experience working in a client-facing role
- 1+ years of healthcare experience
- Experience reviewing and redlining contractual documents
- Experience working in the healthcare industry
- Knowledge of Teradata, Google Big Query, Snowflake, and Oracle databases
- Strong working knowledge of data reconciliation, reporting, and analysis
Benefits
- Eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.
- This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families.
- The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility.
Company Overview