Total Rewards Data And Decision Analyst - Remote

Duke Health | Durham, NC, United States

Applying to this job will open a new window on the employer's web site to apply there.

Posted Date 12/19/2022

This position will have an opportunity to work remotely. All Duke University remote workers must reside in one of the following states or districts: Arizona; California; Florida; Georgia; Hawaii; Illinois; Maryland; Massachusetts; Montana; New Jersey; New York; North Carolina; Pennsylvania; South Carolina; Tennessee; Texas; Virginia or Washington, DC.

Occupational Summary

As a member of the Compensation project and data team and in collaboration with other areas across Duke such as Payroll, HR, and ASM, responsible for: 1) the completion of day-to-day data analysis and transaction work for Duke’s workforce, 2) significant project work related to the completion and analysis of salary surveys, and 3) in collaboration with the Benefits team, is accountable for the development of meaningful Total Rewards decision analytics tools, selection of appropriate benchmarks, the interpretation of the findings, and the development of appropriate recommendations.

A primary responsibility of the position is ensuring the data integrity of applicable pay data and supporting the day to day data needs of the Compensation team, inclusive of creating reports, completing data implementations, performing QA analysis and testing on large data sets, and monitoring the accuracy of Compensation communications such as accuracy of hiring guidelines and pay ranges on our HR website, within SAP, as well as our internal/external interfaces, and documentation of processes.

An additional responsibility of the position is leading the collection, compilation, and interpretation of data in the development of applicable Total Rewards metrics, collaborating with others across Duke reviewing for trends and patterns related to pay and benefits, with attention to recruitment, turnover, and other indicators related to the effectiveness of Duke’s Total Rewards programs, costs, and return on investment.

Develops meaningful professional relationships such as HR, payroll, and SAP partners across the enterprise to be thought partners on new initiatives as well as enable project implementations from thought to implementation. Builds consensus on shared data elements and reporting needs across entities/departments.

Evaluates and completes salary surveys to assure the continued robust data set to benchmark Duke’s positions, leads periodic uploads to survey library as applicable, collaborates with R&R team to assure matches are accurate, and regularly reviews results to identify significant midyear salary movement.

Seek tools and strategies for improving data and administrative processes and supporting strategic initiatives and programs.

May conduct or assist with conducting classification audits to ensure that jobs are properly classified as exempt or nonexempt.

Ensures compliance with data privacy regulations and best practices.

Required Qualifications at this Level


Work requires a Bachelor's degree, preferably in Business Administration or a similar quantitative field.


Five years of progressively responsible experience within a large, complex organization. Demonstrated expertise managing large data sets to enable leadership decision making.


Demonstrated advanced skills in MS Excel inclusive of queries, Vlookups, pivot tables, graphing, and similar analytics to enable decision support required.

Proficient in MS Access database development, queries and maintenance required.

Proficiency with Tableau and/or other visual software or willingness to develop such proficiency required.

The intent of this job description is to provide a representative and level of the types of duties and responsibilities that will be required of positions given this title and shall not be construed as a declaration of the total of the specific duties and responsibilities of any particular position. Employees may be directed to perform job-related tasks other than those specifically presented in this description.

Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.

Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.

Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essentialjob functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.

Healthcare & Public Health

Share this job