Junior Analyst (Advanced Excel) - $30/hour (Contract/Will Train)

Job Type: 
Professional Services
Accounting and Finance
Other Professional Positions
Life Sciences
Other Life Science Positions
Employment Category: 

Our client, a Raleigh-based pharmaceutical company in high growth mode, has an immediate need for a very sharp and detail-oriented candidate to join its Financial Operations team.

This company is a global provider of generic pharmaceutical products. Customers include wholesalers, retail pharmacies, insurance companies, hospitals, clinics, government agencies, etc. and volume is exceptionally high.

When products expire, they are returned to the company and destroyed.  Customers are issued credits for expired product.  Because of the high volume and the regulations surrounding pharma products, tracking the activity related to expiries is complex and important.  This Jr Analyst will be the point-person for that work.

Key Things to Note:

  • Expired product is sent to the destruction company to be destroyed, and the destruction company shares the related data with this Analyst.  The Analyst then compiles, qualifies and analyzes the data to validate, calculate and issue credit memos.  It is high impact, high dollar work.
  • The product details are voluminous and need to be processed meticulously.  Seek candidates with a keen eye for detail and who are quality-driven.
  • The company uses Excel to track and analyze all data. Advanced Excel is needed. SAP would be a plus.
  • This Analyst will regularly interface with vendors and colleagues from other departments in order to investigate discrepancies, clarify questions, etc.  Seek collaborator with strong communication skills.
  • This is a contract role that is expected to last 5-6 months.  It is an immediate need.
  • The company works on a “hybrid” schedule (3 days in Raleigh office; 2 days home-based). The initial ~ 2-week training period may be in-office a bit more.

Selected Duties:

  • Process all Expiry returns promptly and accurately
  • Interact with destruction companies regarding issues with the data or their timeliness of sending the data
  • Interact with the wholesalers regarding the discrepancies with the credit issued.  Resolve discrepancies
  • Work with the Finance team to understand what the open items are and then get those resolved / closed in the accounting records
  • Work with other departments to ensure that all the data is relayed to the wholesalers and all the systems reconcile at the end of each month
  • Prepare reports summarizing Expiry activity as requested.

Targeted candidate will offer a related degree and 1+ years handling detailed, analytic work.  Will consider recent grads who bring financial degrees and some related internships.  Excellent analytical skills will be essential.

Other priorities include:

  • Advanced Excel
  • Keen attention to detail
  • Good numerical acumen
  • Excellent communication skills
  • Strong juggling skills
  • Outstanding work ethic including job ownership, reliability and team orientation.

This is an immediate need. Please forward Word resume for prompt consideration.