Columbia University Specialist, Data Integrity in New York, New York

Position Information

Job Title

Specialist, Data Integrity

Job Code Title

Job Requisition Number



1606- CHR CU Human Resources



Job Type

Officer Full-Time Regular

Bargaining Unit

If temporary, indicate duration

Hours Per Week


Job Family

General Administration

Salary Grade


Salary Range

Commensurate with experience

Advertised Summary Job Description

Reporting to the Data Integrity Assistant Director, the Specialist analyzes data to identify and document trends/patterns of errors. Reviews established solutions to identify the best course of action to resolve the error. The Specialist is responsible for working with Senior Analysts in Data Integrity as well as other HRIS/HRPC team members to support the day-to-day operations of the existing PeopleSoft system. Under the guidance of the Assistant Director, provide assistance on the day-to-day maintenance and correction of data, including review of interface files and setup of configuration tables. Troubleshoot production issues and identify improvements to existing audits.

The successful incumbent has strong analytical and technical skills to identify patterns of issues and be creative in finding solutions. Responsibilities include but are not limited to: analyzing data and spotting trends; understanding existing issues and providing a fresh perspective on resolving them. Executing existing queries and reviewing reports to support the normal operations; providing support and data validation for the annual internal and external system audit; daily review of different data query outputs and correcting errors to ensure the integrity of the information in the HCM system. Other special projects and duties as assigned.

Note: A strong internal candidate has been identified for this position.

Minimum Qualifications for Grade

Applicant MUST meet these minimum qualifications to be considered an applicant

Bachelor's Degree or equivalent required. Must have a minimum of two years of related experience, preferably in HRIS and/or Payroll in Higher Education or in other complex organizations. Strong computer skills and experience with PeopleSoft 9.2 or other HCM system required.

Additional Position-Specific Minimum Qualifications

Applicant MUST meet these minimum qualifications to be considered an applicant

Demonstrated ability to work in a high pressured, fast-paced environment. Demonstrated excellence in a variety of competencies including: analytical thinking, teamwork, and client/customer awareness. Ability to work with changing priorities and with multiple projects. Requires excellent oral and written communication and strong interpersonal skills. Ability to be precise and attentive to detail is essential.

Special Instructions

Preferred Qualifications

Some experience with process management/improvement preferred.

Essential Functions

Additional Essential Functions (Limit to 3950 characters.)

Special Indications

This position works with:

HIPAA Compliance training required

No Response

Participation in Medical Surveillance required

No Response

What type of posting? Is this a waiver request?

Standard Posting

Requisition Open Date


Requisition Close Date

Open Until Filled

Quick Link

EEO Statement

Columbia University is an Equal Opportunity/Affirmative Action employer --Race/Gender/Disability/Veteran.

Local Hiring

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