Posted to MedZilla on 1/13/2018


inVentiv Health

Excel SQL Data Analyst (Entry level) - temporary 66975-MZ


 
 

City Somerset
State New Jersey [NJ]
Title Excel SQL Data Analyst (Entry level) - temporary
Job ID 66975
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 Syneos Health where we surround ourselves with the most talented and agile professionals in the industry, but we check our egos at the door.
 
Why Syneos Health? Join a game-changing global company that is reinventing the way therapies are developed and commercialized. Created through the merger of two industry leading companies - INC Research and inVentiv Health - we bring together more than 21,000 clinical and commercial minds to create better, smarter, faster ways to get biopharmaceutical therapies to patients. Teaming with some of the most talented professionals in the industry, you'll gain exposure and work in a dynamic environment where you'll be supported with comprehensive resources including emerging technologies, data, science and knowledge sharing. Grow your career with a global company committed to shortening the distance from lab to life.
 
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.
 
Syneos Health is an affirmative action/equal opportunity employer (Minorities/Females/Vet/Disabled) 
Position Type/Category Administrative
Recruiting Area TPS
Minimum Education Level Bachelor's Degree
Employment/Job Type Temporary
Employment Type Syneos Health position

Please visit our website at commercialcareers.inventivhealth.com

 
 


* If a direct employer requests that you go to their web site and complete your application there in order to be
  considered, please do so. Applications for all positions are subject to each employer's specific requirements.