Sr Entitlement Analyst

Michaels Stores•Irving, TX

1d•Onsite

About The Position

The Sr Entitlement Analyst is responsible for the financial management of Michaels vendor allowance programs. The role calculates, tracks, and submits invoice deductions; monitors and maintains more than 800 Vendor Partnership Agreements (VPAs); analyzes and executes rebate programs with diverse structures; and monitors back-end merchandising allowances. Working with vendors and merchandise procurement staff, the analyst develops purchase and entitlement forecasts for corporate planning. The role provides buyers with vendor comparison data to support negotiation of VPA terms, along with periodic reporting and analysis of results. It also tracks receipt of entitlement funds and allocates entitlement credits to the appropriate internal merchandise departments. The position oversees entitlement programs and monthly billing, supports financial reporting and month-end close, and maintains and enhances an Access-based entitlement application and invoice register in collaboration with Information Systems and outside consultants. The role also supervises a Financial Analyst and performs other assigned duties.

Requirements

Bachelor’s or Master’s degree in Accounting or Finance.
4 to 6 years of related work experience.
Supervisory experience.
Strong Excel skills.
Strong Microsoft Access skills.

Nice To Haves

Macros experience.
Sequel experience.

Responsibilities

Track entitlements and monitor Vendor Partnership Agreements.
Address vendor requests and other issues; verify and research vendor reimbursement issues.
Interface with buyers to satisfy vendor needs.
Manage the monthly entitlement billing process and control the vendor entitlement system.
Supervise a Financial Analyst.
Ensure accurate deductions, coding, and accruals.
Prepare monthly and quarterly reports.
Prepare monthly forecasts and annual budgets for entitlements and purchases.
Work with Information Systems and outside consultants to maintain and enhance the Access-based application used to generate entitlement claims and track entitlement data and other key vendor information.
Track receipt of entitlement funds and allocate entitlement credits to the corresponding internal merchandise departments.
Produce purchase and entitlement forecasts with vendors and merchandise procurement staff for corporate planning.
Provide buyers with vendor comparative data to support VPA negotiations and periodic reporting and analysis of results.
Calculate, track, and submit invoice deductions; monitor and maintain more than 800 VPAs; analyze and execute rebate programs; and monitor back-end merchandising allowances.