Data and Reporting Analyst

Job Locations US
Posted Date 6 days ago(9/15/2023 2:00 PM)
# of Openings
Data Reporting and Analytics


Headquartered in Morrisville, North Carolina, TrialCard offers services to the pharmaceutical industries allowing customized data-driven patient access that supports companies in product marketing, programs designed for patient assistance and collaboration, and clinical trials.

The focus of the company is on the brands of the clients and analyzing data and information related to prescription optimization geared towards both insured and uninsured categories of patients. TrialCard provides solutions that are aligned with your marketing strategy and brand goals such as patient compliance, managed care, brand launch, patent expiration, and more. 

The Data and Reporting Analyst must be an excellent communicator (both orally and written) and be able to effectively foster interactive collaboration and discussions among clients and internal TrialCard teams. As a Data and Reporting Analyst,

You are r­esponsible for gaining a full understanding of the assigned program(s) and should have a fluent understanding of report design and configuration.  Must be able to review and analyze data as well as present conclusions in a logical and clear manner.  Must be able to effectively work as part of a team.


  • Assists program managers with ad-hoc and standardized reports through data manipulation and raw data extracts.
  • Works directly with business users and decision-makers to gather and document requirements and define scope to ensure accurate development of reporting solutions.
  • Works primarily within SQL, Excel, and MicroStrategy platforms for data manipulation.
  • Performs continuous audits to ensure standard, consistent, and quality master data in catering systems is valid and correct.
  • Supports and maintains current Quality Assurance Program to ensure continued effectiveness within the department.
  • Identifies additional data, reporting and analytic opportunities to support our pharmaceutical clients and scope work necessary to fulfill them.
  • Maintains master data lists through additions and revisions when identified by the business users.
  • Performs and documents procedures for data preparation including data cleaning, standardization and analysis.
  • Develops and maintains operational dashboards for key decision-makers.
  • Standardizes and cleanses raw data using predefined rules as well as establishing new rules as needed.


  • Bachelor’s degree in Math, Statistics, Economics, Finance, Computer Science, Engineering or similar discipline.
  • Must have 2+ years of related data-management, analytics, or business intelligence experience.
  • Solid technical writing skills; ability to clearly and completely articulate work to be done and describe tasks using proper terminology.
  • Experience interpreting data and presenting meaningful, client-ready business insights.
  • Demonstrated application of analytical skills.
  • Mid-level proficiency in SQL programming and common query optimization techniques for data extraction.
  • Advanced Excel and/or Access skills. (e.g., VLOOKUP, SUMIF, Macros)
  • Understanding of dimensional data modeling concepts, as well as data warehousing design highly desirable.
  • Knowledge of the pharmaceutical industry highly desirable.
  • Knowledge of direct marketing highly desirable.
  • Experience in the healthcare industry is highly desirable.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed