Large arrow graphic

Excel SQL Data Analyst (Entry level) - temporary

Updated: December 12, 2017
Location: Somerset, NJ, United States
Job ID: 66975
Share:

Overview
You're driven, resourceful, and above all else - remarkably smart.
 
You love a good challenge. You are the first to roll up your sleeves and work with relentless energy until you solve the unsolvable, beat the unbeatable and you always come out on top. Passable doesn't cut it - you've got fire in your belly to learn more, do more and be more. For you, the sweetest success is shared success and you're known for your good nature. You'll fit right in at INC Research/inVentiv Health where we surround ourselves with the most talented and agile professionals in the industry, but we check our egos at the door.
 
Why INC Research/inVentiv Health? Join our groundbreaking global network of more than 22,000 employees with the ability to service clients in over 110 countries. As part of the only fully integrated biopharmaceutical solutions organization, you'll be connected to a multitude of career paths and employment opportunities. You'll be supported with comprehensive resources based on today's emerging technologies, data, science and knowledge - instead of practices from the past. Teaming with some of the most talented professionals in the industry, you'll gain exposure and work with endless energy in a dynamic environment to over-deliver and outperform. You'll integrate seamlessly with our clients and do what's best for their success. In a recent five-year period, INC Research/inVentiv Health has helped to develop or commercialize 82% of novel new drugs approved by the FDA and 70% of products granted marketing authorization by the EMA.
 
Here, there's no shortage of challenging work, learning and opportunities. Because we offer many services to varied clients, our knowledgeable professionals gain experience across a large section of the industry. Our client roster consists of more than 550 organizations including all 50 of the largest global biopharmaceutical companies.

Responsibilities
This opportunity is with our Selling Solutions team, which partners with top tier pharmaceutical, medical device and biotechnology companies to provide better, smarter, faster solutions for the industry. Take part in leading the transformation of healthcare by joining the largest provider of outsourced commercial solutions to the healthcare industry. This role will be responsible for analyzing, interpreting and messaging data for the purpose of incentive compensation administration. Responsibilities include compensation program analysis, report creation, maintenance and administration of incentive processes and programs. In addition, the position is responsible for data analysis and reporting and provides necessary professional and/or technical level support and guidance. This person will code and run SQL queries to validate data calculations. Must be detail oriented and be strong with MS-Office, especially Excel. Visual Studio is a plus. This is a internal temporary position. We will consider recent grads with strong Excel and SQL.

More specifically:

Key Job Responsibilities:
(Duties may include, but not limited to all or some of the following)
  • Analyze and perform quality control functions on all incentive compensation deliverables and supporting data elements.
  • Analyze existing policies & processes and make recommendations to improve operational efficiencies.
  • Research and respond to customer inquiries regarding IC.
  • Work independently to process information and data to create reports on activities, trends, and projections regarding incentive plan performance, efficiencies, and possible improvements.
  • Prepare detailed workflow charts and diagrams that describe input, output, and logical operation
  • Create case studies identifying business trends regarding sales force metrics as they pertain to IC.
  • Act as contact with other inVentiv departments to gather information for analysis and data utilized in the IC Process.
  • Prepare management reports and analyses as requested.
  • Other projects as deemed necessary by Management.

Required Knowledge, Skills and Abilities:
  • Must demonstrate advanced proficiency in the use of Microsoft Excel, including the ability to create complex models, formulas, pivot tables and power pivot reports.
  • Database query skills - SQL
  • Proficiency with standard Microsoft Office applications (Access, Word, Power Point, Outlook)
  • Ability to set and maintain multiple priorities in a fast-paced and deadline-oriented environment with shifting priorities while providing deliverables in a timely fashion.
  • Must be well-organized with excellent time management skills, attention to detail and accuracy.
  • Ability to develop/create professionally formatted summary materials (e.g. spreadsheets, tables, charts).
  • Strong verbal and written communication skills.
  • Ability to identify and understand broad-scope issues while simultaneously attending to details.
  • Must be a team player with excellent follow-up and customer service skills.
  • Must be self-motivated and results oriented; take ownership of projects and produces results.
  • Pro-active, goal-oriented and able move quickly to resolution.
  • Proven strong analytical, critical thinking and problem solving skills, and ability to synthesize information and data from a variety of sources.
  • Ability to apply sound judgment to solve problems, make defensible recommendations.
  • Understand how compensation impacts other company departments.


Requirements
Along with demonstrated initiative, uncompromised integrity and a results-oriented mindset, the ideal candidate has:
 
Minimum Education:  Bachelor's degree in human resources, finance/accounting, or a business-related field. Master's Degree in a directly-related field preferred
 
Minimum Experience:   
  • Professional-level work experience in the incentive compensation preferably in the Pharmaceutical arena.
  • Strong data analysis/financial analysis skills; SQL, IC tool, advanced Microsoft Office (i.e. Excel, Access, Word, and PowerPoint) skills. 
  • Previous IC reporting experience is mandatory.
  • The drive for self-development, the ability to collaborate, and an action-oriented work ethic
 
Preferred: Experience with industry IC Tools
 
 
Make your work matter everywhere. Be a driving force in a rapidly evolving healthcare industry.
 
INC Research/inVentiv Health is an affirmative action/equal opportunity employer (Minorities/Females/Vet/Disabled)  

Position Type/Category
Administrative

Minimum Education Level
Bachelor's Degree

Employment/Job Type
Temporary

Employment Type
INC Research/inVentiv Health position

“INC Research/inVentiv Health is a place where I can get things done, ensure my client is successful and make a difference for patients.