Senior Specialist, Business Consulting

Job Description

This role will work cross-functionally to maximize the value the US Operations group, primarily in working closely with our Sales Incentive team across our company's Animal Health US Commercial business unit. This primarily includes helping to facilitate and understand annual business unit goals, to define incentive program functionality and maintain, design, develop and enhance incentive plans over time. The role will be hands-on and require demonstrated experience in maintaining the Sales Incentive Plans and support the overall animal health commercial organization for all sales reporting.

 

Sales Incentive Plans:

• Administer and manage the company's incentive compensation programs, ensuring all calculations and payments are accurate and delivered in a timely manner.

• Collaborate with cross-functional teams, including Sales, Finance, and Human Resources, to establish and maintain effective incentive compensation processes and policies.

• Develop and maintain a comprehensive understanding of the company's incentive plans, including metrics, targets, and payout structures.

• Collaborate with Sales Operations to ensure accurate and timely data collection, validation, and integration into the compensation system.

• Perform regular audits and analysis of incentive compensation data to identify and resolve any discrepancies or inaccuracies.

• Provide support and guidance to sales representatives and managers regarding incentive compensation plans, calculations, and payouts.

• Generate reports and provide analysis on incentive compensation performance, including tracking individual and team performance against targets.

• Stay up to date with industry best practices and trends related to incentive compensation administration, recommending improvements to current processes and systems.

• Work closely with the IT department to enhance and optimize the compensation system, ensuring its accuracy, functionality, and usability.

• Maintain accurate and confidential records of incentive compensation plans, payments, and related documentation.

 

Database Development and Reporting:

• Build Database views for master data and sales reporting via internal applications and data visualization tools

• Support Spotfire/Power BI dashboards in self-service mode primarily fixing data issues and enhancing backend database views in collaboration with IT

• Create and automate SQL scripts for providing reports/ data to internal (Sales, Marketing, Finance) and Pricing Portal for Distribution

• Create UNIX scripts for automating delivery of operational reports

 

Education:

• Bachelor’s degree required, preferably with a business focus.

 

Required Skills and Experience:

• At least 5 years of relevant work experience, preferably in a Commercial Operations role.

• Experience working with tools and applications such as SQL Loader, Toad, Workbench for AWS Redshift, SQL Developer for Oracle

• Proficiency in using Programming Languages such as SQL, PL/SQL, Oracle DDL, Unix Shell Scripts

• Knowledge of Oracle Databases

• Exposure to Data Stewardship tools like Informatica

• Strong troubleshooting, analytical and problem-solving skills balanced with a creative mindset

• Ability to facilitate continuous improvement efforts collaboratively with team and peers

• Self-starter and be able to handle multiple tasks and priorities

• Work collaboratively across teams to design and build solutions with the IT department

• Provide support to other team members to trouble shoot and resolve data related issues

• Provide end user support for handling data accuracy and quality related questions and for escalating technical issues to appropriate IT support individuals

Required Skills:

Adaptability, Benchmarking, Business Development, Business Process Re-Engineering (BPR), Change Management, Data-Driven Decision Making, Data Stewardship, Incentive Compensation, Incentive Plan Design, Incentive Programs, Information Technology (IT) Support, Information Technology (IT) Support Services, Information Technology Applications, Interpersonal Relationships, Oracle Database, Oracle Scripting, Oracle SQL Developer, Productivity Initiatives, Quality Control Management, Quality Improvement Programs, Six Sigma

Preferred Skills:

Current Employees apply HERE

Current Contingent Workers apply HERE

US and Puerto Rico Residents Only:

Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here if you need an accommodation during the application or hiring process.

As an Equal Employment Opportunity Employer, we provide equal opportunities to all employees and applicants for employment and prohibit discrimination on the basis of race, color, age, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status, or other applicable legally protected characteristics.  As a federal contractor, we comply with all affirmative action requirements for protected veterans and individuals with disabilities.  For more information about personal rights under the U.S. Equal Opportunity Employment laws, visit:

EEOC Know Your Rights

EEOC GINA Supplement​

We are proud to be a company that embraces the value of bringing together, talented, and committed people with diverse experiences, perspectives, skills and backgrounds. The fastest way to breakthrough innovation is when people with diverse ideas, broad experiences, backgrounds, and skills come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively.

Learn more about your rights, including under California, Colorado and other US State Acts

U.S. Hybrid Work Model

Effective September 5, 2023, employees in office-based positions in the U.S. will be working a Hybrid work consisting of three total days on-site per week, Monday - Thursday, although the specific days may vary by site or organization, with Friday designated as a remote-working day, unless business critical tasks require an on-site presence.This Hybrid work model does not apply to, and daily in-person attendance is required for, field-based positions; facility-based, manufacturing-based, or research-based positions where the work to be performed is located at a Company site; positions covered by a collective-bargaining agreement (unless the agreement provides for hybrid work); or any other position for which the Company has determined the job requirements cannot be reasonably met working remotely. Please note, this Hybrid work model guidance also does not apply to roles that have been designated as “remote”.

The salary range for this role is

$106,200.00 - $167,200.00

This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. An employee’s position within the salary range will be based on several factors including, but not limited to relevant education, qualifications, certifications, experience, skills, geographic location, government requirements, and business or organizational needs.

The successful candidate will be eligible for annual bonus and long-term incentive, if applicable.

We offer a comprehensive package of benefits.  Available benefits include medical, dental, vision healthcare and other insurance benefits (for employee and family), retirement benefits, including 401(k), paid holidays, vacation, and compassionate and sick days. More information about benefits is available at https://jobs.merck.com/us/en/compensation-and-benefits.

You can apply for this role through https://jobs.merck.com/us/en (or via the Workday Jobs Hub if you are a current employee). The application deadline for this position is stated on this posting.

San Francisco Residents Only: We will consider qualified applicants with arrest and conviction records for employment in compliance with the San Francisco Fair Chance Ordinance

Los Angeles Residents Only: We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance

Search Firm Representatives Please Read Carefully 
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company.  No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails. 

Employee Status:

Regular

Relocation:

No relocation

VISA Sponsorship:

No

Travel Requirements:

10%

Flexible Work Arrangements:

Hybrid

Shift:

Not Indicated

Valid Driving License:

No

Hazardous Material(s):

N/A

Job Posting End Date:

04/2/2026

*A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.