Data Analyst

Job Locations US-NC-Morrisville
Posted Date 4 days ago(9/14/2021 12:05 PM)
# of Openings


As a Data Analyst, you will join our team on a journey to help eliminate barriers for patients, increase their access to medications, and help them receive lifesaving treatments while working in an environment that nurtures you.


The Data 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 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.



  • Manage requirements gathering, specifications development, and development of ad-hoc and standardized, production-level reports using MicroStrategy,, and any other applicable software platform
  • Build reports using templates, documents and free-form SQL
  • Act as Subject Matter Expert to provide recommendations and expertise for all TrialCard data and reporting capabilities for assigned programs and/or clients
  • Track and manage Program suite of reports, both standard, custom and outgoing data feeds
  • May track and manage inbound data feeds and manage restatement requests based on program needs
  • Own Level of Effort (LOE) for our reporting services, identifies when a report is chargeable, and recommends cost to Account Team
  • Identify additional data, reporting, and analytic needs of the assigned pharmaceutical clients and the scope work necessary to fulfill them.
  • Communicate with the Account and/or Program Leadership Team on required deliverables, provide timelines and recommendations based on best practices, and prioritize work by accounts as necessary
  • Routinely interact with the Analytics & Reporting Marketing Manager to identify new data and reporting needs and provide updates to Marketing for service capabilities.  Varies by Program
  • Identify, define, and coordinate with other departments to connect our data and reporting to improve TrialCard’s suite of products and services
  • Collaborate with Data Architects and ETL Developers to design or enhance data warehouse for the purpose of high-performance reports
  • Develop new and innovative data, reporting and analytic products and services, as necessary
  • Work with programming environments, SQL, SSRS, MS Excel,, and MicroStrategy platforms
  • Provide leadership and training to other team members on fundamental data mining and report creation techniques and applications
  • Develop metrics and provide data for process measurement
  • Identifying indicators for future process improvement opportunities
  • Any other tasks or projects as assigned by immediate supervisor




·       Bachelor’s degree in Math, Statistics, Economics, Finance, Computer Science, Engineering or similar discipline.

·       Must have 2+ years of client-facing 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)

·       Intermediate MS PowerPoint skills

·       Proficiency in MS Outlook, MS Windows

·       Understanding of dimensional data modeling concepts, as well as data warehousing design highly desirable.

·       Experience designing and implementing enterprise business intelligence solutions using MicroStrategy,, Microsoft SSRS or similar highly desirable

·       Knowledge of the pharmaceutical industry, direct marketing or finance 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