Edtech.com's Summary

Columbia University is hiring an HR Data Analyst to provide compensation analyses and support for HR administrative processes within the central Human Resources group. The role involves data analytics, reporting for various HR functions, collaborating with HR Business Partners, and improving operational decision-making through data insights.

Highlights

Prepare annual compensation survey submissions and support daily requests for additional compensation payments.
Manage annual merit increase processes, salary range development, and compensation system audits.
Evaluate and classify job descriptions using institutional frameworks and technology tools.
Collaborate with HR Business Partners to support job description management and strategic compensation initiatives.
Develop dashboards and recurring reports on workforce metrics such as headcount, turnover, and engagement.
Partner with IT and HR teams to enhance system processes, workflows, and reporting capabilities.
Conduct audits related to governance, regulatory compliance, and confidentiality standards.
Bachelor's degree with a minimum of 3 years of related experience required; preferred experience includes process improvement and SQL query execution.
Proficiency in Excel (pivot tables, VLOOKUP/XLOOKUP, Power Query, macros), data visualization tools (Power BI, Tableau), HR systems (PeopleSoft preferred), and compensation benchmarking tools.
Strong analytical, organizational, and communication skills with the ability to convey complex data to technical and non-technical audiences.

HR Data Analyst Full Description

Job Type: Officer of Administration
Bargaining Unit:
Regular/Temporary: Regular
End Date if Temporary:
Hours Per Week: 35
Standard Work Schedule:
Building:
Salary Range: $80,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

Reporting to Associate Director of Compensation, the HR Data Analyst is a key contributor within the central Columbia University Human Resources (CUHR) group, primarily providing compensation analyses and support related to the department’s administrative processes. In addition, the role will be involved in data analytics and reporting for these and other HR functions. The ideal candidate possesses strong analytical skills, meticulous attention to detail, and a collaborative approach to enhancing operations and supporting informed decision-making.

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.

Minimum Qualifications

Bachelor's degree or its equivalent.
A minimum of 3 years of related experience.

Preferred Qualifications

Experience with process management/improvement preferred.
Experience with running SQL queries in AQT and/or SQLDeveloper

Other Qualifications

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).
Experience with compensation benchmarking tools (e.g., MarketPay, CompAnalyst).
Ability to translate data into insights for non-technical audiences.
Experience applying technology and emerging tools, including artificial intelligence (AI)

Equal Opportunity Employer / Disability / Veteran

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

Original Job Description

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

Position Summary

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.

Minimum Qualifications

Bachelor's degree or its equivalent.
A minimum of 3 years of related experience.

Preferred Qualifications

Experience with process management/improvement preferred.
Experience with running SQL queries in AQT and/or SQLDeveloper

Other Qualifications

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).
Experience with compensation benchmarking tools (e.g., MarketPay, CompAnalyst).
Ability to translate data into insights for non-technical audiences.
Experience applying technology and emerging tools, including artificial intelligence (AI)

Equal Opportunity Employer / Disability / Veteran

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

Let me find your next job.

Thanks - you're signed up.

HR Data Analyst

Edtech.com's Summary

HR Data Analyst Full Description

Data Analyst - Power BI Specialist

Staff Data Engineer - Craft Education

Business Intelligence Analyst

Director, Revenue Insights & Analytics

Senior Manager of Data Engineering