|State ||New Jersey [NJ]|
|Title ||Excel SQL Data Analyst (Entry level) - temporary|
|Job ID ||66975|
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.
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.
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.
Along with demonstrated initiative, uncompromised integrity and a results-oriented mindset, the ideal candidate has:
Minimum Education: Bachelor's degree in finance/accounting, or a business-related field. Master s Degree in a directly-related field preferred
Strong data analysis/financial analysis skills; SQL, IC tool, advanced Microsoft Office (i.e. Excel, Access, Word, and PowerPoint) skills.
The drive for self-development, the ability to collaborate, and an action-oriented work ethic
Previous IC reporting experience is a plus.
Professional-level work experience in the incentive compensation preferably in the Pharmaceutical arena is a plus.
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|