Junior Level Data Analyst, Excel, Pharma Reporting

Full Time
Parsippany, NJ 07054
Posted
Job description

**You MUST live within 1 hours driving distance to the Parsippany, NJ area to be considered.**

CMK Select, a specialized consulting firm dedicated exclusively to the Pharmaceutical industry is hiring a Junior Level Data Analyst / Research Analyst with very strong MS Excel skills to support our client, a global Pharmaceutical company. In this role, you will provide analysis support to our client related to root cause, data and spreadsheet data delivery to aid in managing compliance for payments to Healthcare Practitioners (HCPs) and Healthcare Organizations (HCOs).

This is a unique opportunity for someone with strong Research skills and strong Data Analysis skills to break into the Pharma industry!

Our client’s business unit focuses on Regional, Local and National Pharmaceutical Conventions, Congresses and Events. 3rdparty payments have been identified as an area of risk for services across areas such as sponsorships, grants, fees for services (ie. Fair Market Value – FMV), and Ad Board activities.

A heavy level of research and investigational skills will be applied to uncover answers to questions such as: 1) are we paying a single entity? 2) is this a valid organization we are paying? 3) Is the organization reputable?

There are over 1,000 organizations that will need to go through the vetting process mentioned above. This vetting process will require conducting research/background checks on various organizations, looking at their websites & Board of Director profiles to prevent conflicts of interest, and reviewing escalated programs (this could include venues where events were held, looking up charities, confirming where payments will be sent, etc).

The Data Analyst / Research Analyst will work closely with our client’s Pharmaceutical Sampling Representatives, Line Managers and Directors to understand the programs submitted, determine why an initiative was flagged, communicate directly with associations to obtain missing information, and review letters of agreement for specific terms. The Data Analyst / Research Analyst will be the final line of defense to close the loop on everything that is being looked at to determine if our Pharma client can work with a particular organization and remain in Compliance.

These data validation activities will provide support to Pharma transparency reporting initiatives and ensure the company has a comprehensive understanding of complete company event execution activities.

Requirements of the Junior Level Data Analyst / Research Analyst:

  • Proficiency in spreadsheet analysis data delivery
  • Strong proficiency with MS Excel (pivot tables, formulas, functions)
  • Strong attention to detail
  • Strong data analysis experience
  • Strong research skills
  • Must be good with unraveling information, looking for answers, and identifying items that do not seem correct and going to the next level to find out why
  • Self-starter, able to manage multiple tasks in parallel
  • Bachelor’s Degree

This is a long-term project opportunity with multi-year potential and is a great way to put your education & 1-2 years of business experience to valuable and immediate use.

The position will be hybrid based, requiring 2-3 days onsite in our client's Morris County, NJ area office for key, recurring meetings.

CMK’s comprehensive benefits package includes Medical/Dental/Vision/LTD/STD benefits coverage, Paid Holidays, Paid Time Off, and 401k in addition to generous salaries.

Job Type: Contract

Pay: $50,000.00 - $57,000.00 per year

Benefits:

  • 401(k)
  • Health insurance
  • Life insurance
  • Paid time off
  • Vision insurance

Schedule:

  • 8 hour shift

Ability to commute/relocate:

  • Parsippany, NJ 07054: Reliably commute or planning to relocate before starting work (Required)

Education:

  • Bachelor's (Required)

Experience:

  • Microsoft Excel: 2 years (Required)
  • Data analysis skills: 1 year (Required)

Work Location: Hybrid remote in Parsippany, NJ 07054

johnandkristie.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, johnandkristie.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, johnandkristie.com is the ideal place to find your next job.

Intrested in this job?

Related Jobs

All Related Listed jobs