Data Analyst - Compensation & Execution Operation

Johnson & Johnson•West Chester, PA

6d•$65,000 - $104,650

About The Position

DePuy Synthes Companies of Johnson & Johnson is the largest, most innovative, and comprehensive orthopedic and neurological business in the world. DePuy Synthes Companies offer an unparalleled breadth and depth of products, services and programs in the areas of joint reconstruction, trauma, spine, sports medicine, neurological, craniomaxillofacial, power tools, and biomaterials. With a focus on activating insights to develop innovative, comprehensive solutions, we are inspired to advance patient care in greater ways than either company could accomplish on its own. DePuy Synthes Companies of Johnson & Johnson is searching for a Compensation and Execution Analyst to be located in West Chester, PA or Raynham, MA. The Analyst provides wide range of business support including analysis and project management across all DePuy Synthes business platforms required to enable business decision support and incentive compensation program administration.

Requirements

A minimum of a Bachelor’s degree is required.
Relevant Co-Op, internship, or 0-2years work experience is required
10% domestic travel may be required

Nice To Haves

Background or education in computer science, finance, statistics, or business preferred
Experience with data visualization tools such as Power BI is preferred
Experience with Macros preferred

Responsibilities

Assemble compensation data in a format that allows for consistent use across the compensation team
Work with Incentive compensation leadership team to identify IC reporting needs to include both internal and external (field) needs
Deliver dashboard reporting to support field sales leaders with KPIs including sales, quota, attainment %, performance vs financial BP and performance vs financial budget
Capture, coordinate, and maintain compensation information in an offline database for easily accessible historical information
Create, maintain, and analyze monthly trend data
Filter and clean data to only show business-critical fields
Use data visualization tools to allow for easy interpretation of data and trends
Act as team SME in leading training analysts on effective use of data repository
Supports team in advising on methods to address business questions and provide insights using technology
Partners closely with compensation system and administration analyst teams to ensure accurate system programming and delivery of compensation across all ortho businesses.
Partners with sales leadership and commercial partners to independently manage financial modeling, and benchmarking activities in support of assigned organizations.
And other tasks and duties, as assigned.

Benefits

Subject to the terms of their respective plans, employees are eligible to participate in the Company’s consolidated retirement plan (pension) and savings plan (401(k)).
This position is eligible to participate in the Company’s long-term incentive program.
Vacation –120 hours per calendar year
Sick time - 40 hours per calendar year; for employees who reside in the State of Colorado –48 hours per calendar year; for employees who reside in the State of Washington –56 hours per calendar year
Holiday pay, including Floating Holidays –13 days per calendar year
Work, Personal and Family Time - up to 40 hours per calendar year
Parental Leave – 480 hours within one year of the birth/adoption/foster care of a child
Bereavement Leave – 240 hours for an immediate family member: 40 hours for an extended family member per calendar year
Caregiver Leave – 80 hours in a 52-week rolling period10 days
Volunteer Leave – 32 hours per calendar year
Military Spouse Time-Off – 80 hours per calendar year