Incentive Program Analyst

Healthcare Businesswomen’s Association; Illinois; On-site; USD 63,000 - 93,000; Full time

Job summary

Une organisation à but non lucratif recherche un analyste des primes pour gérer le programme de compensation en utilisant Microsoft Excel et gérer plusieurs projets. Le candidat idéal aura plusieurs années d'expérience dans un environnement d'analyse financière, avec des compétences avancées en outils comme SAP et SQL. Ce poste offre un salaire compétitif et un ensemble d'avantages, y compris une assurance santé et un 401(k).

Benefits

Health insurance

Life and disability insurance

401(k) contributions

Paid time off

Qualifications

• Minimum 2 ans d'expérience en compensation, audit interne ou analyse financière.
• Compétence avancée dans Excel avec des fonctions comme SUMIFS et VLOOKUP.
• Expérience dans la gestion de plusieurs projets en respectant des délais serrés.

Responsibilities

• Calculer et analyser les résultats des primes Formula pour le personnel.
• Créer et distribuer des rapports de performance mensuels.
• Auditer et maintenir l'intégrité des documents utilisés pour les calculs.

Skills

Advanced Excel

Compensation analysis

Financial analysis

Project management

Education

High school diploma

Bachelor’s degree in Accounting or Finance

Tools

SAP

SQL

Power Pivot

Alteryx

Job description

Job Summary

Job Description

JOB SUMMARY:

Calculate and analyze corporate Formula bonus program results and payouts. Serve as point of contact for all employees (including senior leadership) regarding the Formula bonus program.

CORE JOB RESPONSIBILITIES:

1.Compile, process and audit quarterly Formula bonuses for a large corporate employee group.

1a.Track and calculate results for employee specific KPI’s (Sales, Profitability, etc.) on a quarterly basis.

1b. Process, update and adjust for changes in employee compensation to maintain accurate Formula bonus details.

2. Create and distribute monthly performance reports with all supporting documents. This will include fielding questions from employees and management.

3. Audit and maintain the integrity of source documents used in Formula bonus calculations. Reconcile data provided; escalate reconciliation issues with manager.

4. Identify and present opportunities for process improvement; automate Formula bonus worksheets for assigned areas.

5. Calculate monthly Formula bonus accruals for assigned areas.

6. Other Finance duties as assigned.

BASIC QUALIFICATIONS:

Education

High school diploma.

Relevant Work Experience

At least 2 years of work experience in one or more of the following fields: compensation, internal audit, financial analysis and/or accounting.

Additional:

Advanced level skill in Microsoft Excel, including the use of the following functions: SUMIFS, nested IF statements, V/XLOOKUP and leveraging pivot tables).

Experience in controlling and coordinating concurrent projects, competing priorities and critical deadlines

Experience taking the steps to ensure the assignment/project is accomplished within tight timeframes.

PREFERRED QUALIFICATIONS:

Education

Bachelor’s degree in Accounting or Finance.

Relevant Work Experience

Experience working with incentive compensation environment.

Medline work experience.

Additional

SAP experience.

SQL, Alteryx or Power Pivot experience.

Medline Industries, LP, and its subsidiaries, offer a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

The anticipated salary range for this position:

$63,960.00 - $92,560.00 Annual

The actual salary will vary based on applicant’s location, education, experience, skills, and abilities. This role is bonus and/or incentive eligible. Medline will not pay less than the applicable minimum wage or salary threshold.

Our benefit package includes health insurance, life and disability, 401(k) contributions, paid time off, etc., for employees working 30 or more hours per week on average. For a more comprehensive list of our benefits please click here. For roles where employees work less than 30 hours per week, benefits include 401(k) contributions as well as access to the Employee Assistance Program, Employee Resource Groups and the Employee Service Corp.

We’re dedicated to creating a Medline where everyone feels they belong and can grow their career. We strive to do this by seeking diversity in all forms, acting inclusively, and ensuring that people have tools and resources to perform at their best. Explore our Belonging pagehere.

Medline Industries, LP is an equal opportunity employer. Medline evaluates qualified individuals without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, age, disability, neurodivergence, protected veteran status, marital or family status, caregiver responsibilities, genetic information, or any other characteristic protected by applicable federal, state, or local laws.