Hybrid Data Analyst – Compensation & Execution Operations

at OneTrust

• Job title: Data Analyst – Compensation & Execution Operations
• Job type: Full Time
• Experience level: Junior
• Salary: $65,000 - $104,650 per year
• Degree requirement: Bachelor's Degree
• Location requirements: Hybrid, West Chester, United States

About the role

• Data Analyst role at Johnson & Johnson focusing on compensation data analysis and systems support. Engaging with sales leaders and delivering actionable insights through reporting and visualization.

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.

Requirements

• A minimum of a Bachelor’s degree is required.
• Relevant Co-Op, internship, or 0-2 years work experience is required
• 10% domestic travel may be required
• 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

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 period
• Volunteer Leave – 32 hours per calendar year
• Military Spouse Time-Off – 80 hours per calendar year