Pharmaceutical Reporting Senior Analyst

Key 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.

Primary duties and responsibilities

• 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%).

Education

[R] 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.

Prior Work Experience

[R] 1+ years of SQL experience or other relevant programming experience.
[P] 2+ years of experience working in a client-facing role.
[R] 2+ years of experience working in a professional services environment with clients/stakeholders, preferably in reporting requirements, data reconciliation, and root cause analysis.
[P] 1+ years of healthcare experience.

Required Skills

• 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.).

Preferred Skills

• 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.