Advertised Summary Job Description: Reporting directly to the Senior Associate Dean, Administration and Planning for Columbia College, the HR Compensation and Analytics manager provides budget and analytical support to track, project and analyze Columbia College's payroll budget as well as prepare HR metric reports. This work will help inform short-term and long-term budget planning needs. This is a full-time, temporary position working 35 hours per week for the period of one year with possibility to extend the period.
A. Maintain comprehensive payroll model to forecast projected expenditures and level of vacancy savings. Recommend and implement enhancements to the payroll model to improve accuracy and efficiency.
-Reconcile budget vs actual payroll activity regularly.
-Identify payroll accounting transactions that need to be processed in order to align budget vs actuals appropriately.
-Work closely with the CC HR team to reflect updates of HR actions with payroll implications to the payroll model.
-Work closely with the CC Finance team to coordinate the updates of payroll in the University's budget tool and internal budget models.
-Serve as a point of contact for determining where salary expenses should be allocated.
B. Update unit specific tracking worksheets to reflect projected expenditures and level of vacancy savings. Create what-if scenarios to inform managers in thinking about future HR actions. Recommend and implement enhancements to worksheets to improve accuracy and efficiency. Identify and develop other routine payroll reports that will bring value-added planning information for managers and senior management and maintain the production of the reports.
C. Conduct regular variance and trend analyses to inform payroll projections and tracking versus budget. Conduct ad hoc analyses as needed to inform future planning and salary equity.
D. Create HR metric reports to help inform how the College is meeting talent acquisition and retention, learning and development, performance management and organization effectiveness goals.
E. Performs other related duties as assigned.
General Minimum Qualifications: A Bachelor's degree and/or its equivalent required. A minimum of 3-5 years of related experience required.
Additional Specific Minimum Qualifications: Strong preference for experience with budgeting or analyzing payroll or HR metrics in higher education, non-profit, and/or complex organization. Detail-orientation with strong organizational and problem-solving skills required. Must be a self-starter and capable of operating with minimal supervision. Demonstrated ability to prioritize and manage multiple projects simultaneously. Excellent interpersonal, verbal and written communication skills with a strong customer service focus essential. Ability to work closely and effectively with a diverse group of administrators. Ability to exercise discretion and handle confidential information is essential. Must be politically savvy and skilled at conducting nuanced conversations with all employee levels. Proficiency in Microsoft Office applications required, especially Excel. Demonstrated ability to compile, manipulate, and analyze data and present data to end users in a clear and functional manner.
**Applications must be submitted with a resume and cover letter to be considered**
Preferred Qualifications: Preference for technical knowledge to automate and produce pre-formatted reports using Excel or similar software. Knowledge of the PeopleSoft HR and/or Financials or a similar enterprise management application preferred.
As a member of the National Collegiate Athletic Association (NCAA) and the Council of Ivy Group Presidents (Ivy League), it is imperative that members of the Columbia University community, in all matters related to the intercollegiate athletics program, exhibit the highest professional standards and ethical behavior with regard to adherence to NCAA, Conference, University, and Department of Intercollegiate Athletics and Physical Education rules and regulations.
Columbia University is an Equal Opportunity/Affirmative Action employer.
Internal Number: 126_175124
About Columbia University
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.