Analyst, Data II - Incentive Compensation N01

Qualifications:

MINIMUM QUALIFICATIONS

• A Bachelor’s degree in Business or related field highly desired but not required.
• 2 to 4 years of data-related analytics, finance/accounting or equivalent experience is preferred.
• Ability to work independently, with general supervision, on day-to-day tasks, prioritization of work and simultaneous deliverables.
• Understanding of master data and structural relationships.
• Know when to escalate issues, seek guidance and communicate with others.
• Strong computer skills including MS Excel, MS Access and Power Point are required.
• Detail oriented with strong analytical and organizational skills.
• Strong verbal, written and interpersonal communication skills.
• Ability to work in team environment.

PHYSICAL DEMANDS

Stand/Sit/Walk 8 hrs a day.

WORK ENVIRONMENT

Travel as needed, less than 5%

Responsibilities:

The Data Analyst II will work under general supervision and be expected to understand the data intricacies within various business processes along with the data requirements and integrity across multiple system solutions. The Data Analyst II will document critical master data management processes, and development of checks and balances for internal control purposes. The Data Analyst II must also support data loads and requests for master data maintenance for all business groups within Client. This role will raise any problems or issues to higher level analysts or managers who will review work for accuracy. They will also collect, calculate, verify and report incentive compensation to the field sales force in accordance with established incentive compensation programs and guidelines.

PRIMARY DUTIES AND RESPONSIBILITIES

• Assist in the creation of thorough documentation for all master data fields within relevant systems. MDM and Sales Compensation data.
• Support and provide input for processes that will allow for master data to be updated consistently and accurately, which will include gaining appropriate approvals.
• Communicate with all interested parties when master data is changed.
• Actively support the MDM team, who will be the central contact point for all data related issues.
• Support OCA data loads through data gathering and completion of load templates. Execution of limited data loads expected. Validate this information is accurate and in compliance with J-SOX controls.
• Gather MDM change data, provide summary level analytics and work with higher level analysts to complete robust analytics.
• Recommend changes to data structures, elements and uses to optimize the flow of information.
• Run monthly incentive compensation processes including manual sales and commission adjustments order/commission splits, transfers of sales/commissions and bonus entries.
• Finalize monthly incentive compensation payable for the Sr Manager to approve and submit to payroll for processing. Coordinate with other analysts to finalize the file and communicate to manager.
• Provide recommendations/solutions to management on process improvement and/or compensation related disputes. Help implement solutions.
• Work with various members of the sales organization to research issues and discrepancies associated with commission/bonus payouts, sales reporting, alignments, compensation plans etc.
• Gather sales compensation committee exception requests and send to Sr/Lead Analyst for the meeting.
• Assist Sales customers in reconciliation of sales credit and incentive compensation as required.
• Understand and provide input on all appropriate incentive compensation policies and SOPs creating new policies or making updates to existing policies when necessary.
• Perform other related duties as assigned.