HR Data Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

Columbia University · 1 day ago

HR Data Analyst

Columbia University is seeking an HR Data Analyst who will provide compensation analyses and support for the Human Resources department. The role involves data analytics, reporting, and enhancing operations to support informed decision-making within the university's HR functions.

EducationHigher EducationMedicalTrainingUniversities

Responsibilities

Prepare annual compensation survey submissions for Willis Towers Watson, Mercer, Western Management, and others, as needed
Support the review of daily requests regarding additional compensation payments
Support the annual merit increase process and the development of salary ranges. Prepare and test the system used to process compensation changes, maintain user tables, prepare data loads and audit reports
Evaluate and classify job descriptions using institutional job architecture and technology-enabled tools, applying consistent leveling across the university
Partner with HR Business Partners by providing precedent, comparative analysis, and trend insights to support consistent job description management across schools and departments
Work with HR Business Partners to provide data analysis related compensation in support of strategic client initiatives
Prepare CUHR financial and administrative reports
Work with the Recruitment team to provide data and analysis to support Talent Search Services recruitment and hiring program’
Develop and maintain dashboards and recurring reports on headcount, turnover, engagement, and other workforce metrics
Work with IT and HR to improve system processes, workflows, and reports
Contribute to the development, writing, editing and modification of operating policies, guidelines and procedures
Perform audits to verify adherence to governance, regulatory, and confidentiality standards, including audits related to FLSA and NYSDOL, external surveys and regulatory filings
Create ad hoc analyses and provide recommendations to support HR decision making and operational improvements

Qualification

HR analyticsCompensation analysisSQL queriesData visualizationExcel proficiencyProcess managementData insightsTechnology applicationCollaborationCommunication skillsAttention to detailOrganizational skills

Required

Bachelor's degree or its equivalent
A minimum of 3 years of related experience
3+ years of experience in HR analytics, Compensation, and/or HRIS
Proficiency with Excel and experience using HR systems (PeopleSoft preferred)
Strong analytical skills and attention to detail
Ability to effectively collaborate with colleagues across HR functions
Excellent organizational, verbal, and written communication skills
Maintains professionalism in handling sensitive HR information
Ability to manage multiple priorities in a collaborative, fast-paced environment
Comfortable discussing complex data with both technical and non-technical audiences
Advanced Microsoft Excel Skills, including pivot tables, VLOOKUP/XLOOKUP, Power Query, macros, and data validation
Data visualization (e.g., Power BI, Tableau)
Ability to translate data into insights for non-technical audiences
Experience applying technology and emerging tools, including artificial intelligence (AI)

Preferred

Experience with process management/improvement preferred
Experience with running SQL queries in AQT and/or SQLDeveloper
Experience with compensation benchmarking tools (e.g., MarketPay, CompAnalyst)

Company

Columbia University

company-logo
Columbia University is a research institution and Ivy League school for undergraduate and graduate students across various fields

Funding

Current Stage
Late Stage
Total Funding
$21.84M
Key Investors
ValeNational Institutes of HealthNational Science Foundation
2024-09-24Grant· $0.02M
2023-08-17Grant
2023-05-04Grant· $20M

Leadership Team

leader-logo
Jeannette Wing
Executive Vice President for Research and Professor of Computer Science
linkedin
leader-logo
Asaf Cidon
Assistant Professor, EE and CS
linkedin

Recent News

Company data provided by crunchbase