Human Resources Generalist, Data & Reporting

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: $85,000 - $95,000

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.


Position Summary


The Office of Alumni Relations and Development partners with alumni, donors, and friends who share a dedication to furthering Columbia's global impact. The Human Resources and Talent Management (HRTM) teamfocuses on all areas of the employee life cycle to contribute towards an engaged workforce and to help the department and the University meet its mission and goals. The HRTM team is a resource for managers and staff, providing support, project-based initiatives, and strategic planning.


Reporting to the Executive Director of Human Resources and Talent Strategy, the HR Generalist - Data & Reporting serves as a key member of the HRTM team, supporting core HR functions across the employee lifecycle while leading the department's HR data, reporting, and systems administration.


This role serves as the HR systems and reporting lead for the Office of Alumni Relations & Development (OAD), managing HR reporting, dashboards, and data integrity while serving as a business owner for HR technology platforms used to support the department. The HR Generalist partners with HR leadership to provide accurate and timely workforce data, metrics, and reporting that inform decision-making, support strategic initiatives, and ensure effective HR practices across the department.


Responsibilities


HR Data, Systems and Reporting

• Support the performance review process by developing reports on performance reviews, ratings, and compensation.
• Partner with the Executive Director of HRTM and DVP of Administration to manage timelines, key dates, and data distribution related to the annual compensation process by ensuring that reports are up to date and deadlines are met for the processing of all transactions in PeopleSoft.
• Manage HR data collection across multiple platforms and conduct regular audits to ensure data integrity and accuracy of information.
• Design, develop, and maintain standard weekly, monthly, quarterly, and annual reports and dashboards while responding to customized ad hoc data requests from HR leadership and senior management.
• Analyze workforce data across the employee life cycle including recruitment, turnover rates, compensation, promotions, vacancy, and position history to analyze trends and support workforce planning.
• Manage internal HRMIS system and serve as the business owner for all internal HR systems, partnering with Information Technology and Administration Team colleagues on troubleshooting and best practices.
• Provide HR data for annual and ad hoc surveys and reports for HRTM colleagues, internal stakeholders, senior leadership, and external business partners.
• Review salary benchmarking and develop job family compensation reports.
• Serve as the main and technical point of contact for various HR systems, including the planning and performance tool, Engagedly, providing user support and training, and system administration. Lead communications related to performance management and the use of Engagedly.
• Maintain data integrity across systems and ensure accurate reporting and documentation.
• Recommend short-term and long-term goals, milestones, and benchmarks for key performance metrics.

HR Generalist and Operations Support

• Manage day-to-day operational tasks and partner with HRTM team members to address staff and manager inquiries, identifying solutions and assisting with processing as needed.
• Assist with the day-to-day and comprehensive HR functions and processes which include recruitment, hiring, onboarding, performance management, compensation, employee relations, voluntary and involuntary departures, employee engagement, succession planning, leave management, TLAM, and payroll.
• In partnership with the HRTM team, maintains up-to-date records of HR policies and employee information.
• Assist with onboarding and orientation of new hires, and offboarding.
• Create, maintain, and update email distribution lists for OAD staff and the Alumni Relations and Development community.
• Monitor and manage the Salesforce HR inquiry queue as needed.
• Provide updates, resources, and information on the department's internal social business platform, LionsDen.
• Liaise with Central HR and other departments throughout the University.
• Assist in developing and implementing strategic communications to ensure that staff have timely resources and information.
• Support additional HR initiatives, projects, and operational needs as assigned.

Minimum Qualifications

• A bachelor's degree and/or its equivalent is required.
• A minimum of three (3) to five (5) years of related experience in Human Resources required.
• Excellent analytical skills and exceptional computer proficiency are required, including experience with Microsoft Office Suite, Google Workspace, Salesforce, and payroll applications. Advanced Excel skills (e.g., VLOOKUP, XLOOKUP, macros, and pivot tables) are essential, along with a strong desire to learn, problem-solve, and troubleshoot technical issues.
• Must be detail oriented, with excellent organizational, interpersonal, written, and oral communication skills.
• The ability to maintain the highest degree of confidentiality and diplomacy at all times is essential.
• Must possess a high level of professionalism and a customer service mindset.
• Must be capable of working independently with little supervision, as well as serve as a productive team member serving a high-profile department.
• Must have a high level of attention to detail, with the ability to handle and prioritize multiple tasks and work well under tight deadlines.
• Must be able to identify priorities within multiple assignments and possess a strong foundation of knowledge in core HR best practices.

Preferred Qualifications

• Experience with performance management platforms, such as Engagedly, is desirable, as well as experience with Salesforce, Peoplesoft, or other Human Resources Information Management Systems.
• Excellent knowledge of databases is desirable. Human Resources certification (SHRM-CP or SHRM-SCP) is also preferred.

Other Requirements

• Subject to business needs, the Office of Alumni Relations and Development supports a hybrid work arrangement for this position. Options will be discussed during the interview process.

Equal Opportunity Employer / Disability / Veteran


Columbia University is committed to the hiring of qualified local residents.