Institutional Research Specialist (Data Integration) - Office of Institutional Research Analysis

The City University of New York; New York (NY); On-site; USD 57,252 - 86,741; Full time

Benefits offered by this job

Health plans

Tuition waivers for CUNY graduate study

Generous paid time off

Competitive retirement benefits

Job summary

The City University of New York seeks an Institutional Research Specialist - Data Integration to design and maintain data integration solutions at the CUNY School of Medicine. The role involves collaborating with multiple departments to support institutional research and ensure data accuracy.

Qualifications include a Bachelor’s Degree and four years of experience, preferably with a Master’s in a related field. Strong skills in data integration and Microsoft 365 BI tools are required.

Qualifications

• Four years’ relevant experience required.
• Knowledge of CUNY First architecture and reporting practices.

Responsibilities

• Design, implement, and maintain data integration solutions.
• Monitor and troubleshoot data integration workflows.
• Ensure compliance with data privacy regulations.

Skills

Data integration

Microsoft 365 BI tools

SQL

Problem-solving

Communication skills

Education

Bachelor’s Degree

Master’s Degree in Mathematics, Statistics, or related field

Tools

Power BI

Power Automate

Job description

POSITION DETAILS

The CUNY School of Medicine (CUNY SoM) located in the heart of Harlem, New York, is the only medical school in the City University of New York system and the only public medical school in Manhattan. Building upon 50 years of success as the Sophie Davis School of Biomedical Education, the institution transitioned to the CUNY School of Medicine (SoM) in 2016. The CUNY SoM offers an accelerated BS/MD degree (7‑year program) and a Physician Assistant Master’s Degree (27‑month program). True to its legacy of access, opportunity, and community transformation, the medical school’s mission remains to recruit highly talented students as diverse as New York City itself. CUNY SoM places a special emphasis on the recruitment of those who are underrepresented in the field of medicine and on training high‑quality, culturally competent health professionals and scientists equipped to address the healthcare needs of New York’s medically under‑served communities. As a major priority, CUNY SoM also seeks to enhance the recruitment and retention of senior leadership, faculty, and staff to more closely reflect the diversity of its student body.

SUMMARY

The Institutional Research Specialist – Data Integration will be responsible for designing, implementing, and maintaining data integration solutions at the CUNY School of Medicine. The role involves collaborating with multiple departments to ensure seamless data flow and integration and supporting the Office of Institutional Research Analysis in institutional research, assessment, accreditation, and strategic decision‑support activities.

• Develop and maintain data integration solutions for student information systems, learning management systems, and other educational technologies, using appropriate tools to extract, transform, and load data.
• Collaborate with stakeholders, including faculty, staff, and administration, to understand data requirements and design integration processes.
• Monitor and troubleshoot data integration workflows to ensure data accuracy and integrity.
• Perform data mapping, transformation, and validation to support academic and administrative needs.
• Document data integration processes and provide training to end‑users.
• Stay up to date with industry trends and best practices in data integration.
• Support data quality by recommending and enforcing data quality standards and procedures.
• Conduct regular data quality assessments and audits to identify and resolve data issues.
• Implement data cleansing and validation techniques to ensure high‑quality data.
• Collaborate with data stewards and other stakeholders to improve data quality across the institution.
• Ensure compliance with data privacy regulations and institutional policies.
• Perform other duties as assigned by the Associate Dean of Institutional Effectiveness and Assessment or designee.

QUALIFICATIONS

Bachelor’s Degree and four years’ relevant experience required.

PREFERRED

• Master’s degree in Mathematics, Statistics, Computer Science, or a related field.
• Five to eight years of experience in data integration, database administration, power analysis estimation, software development fundamentals, or a related field in higher education.
• Proficiency in Microsoft 365 BI tools and languages (Power BI, Power Automate, DAX, M) and SQL.
• Ability to develop and maintain data transformation scripts and workflows.
• Strong understanding of data integration processes to ensure data accuracy and consistency.
• Ability to troubleshoot and resolve data integration issues.
• Knowledge of industry best practices and emerging technologies in data integration.
• Excellent problem‑solving skills and attention to detail.
• Ability to collaborate effectively with IT and other stakeholders throughout the school.
• Strong communication and collaboration skills.
• Must be ethical, have integrity, strong interpersonal and analytical skills.
• Excellent analytical and problem‑solving skills.
• Strong verbal and written communication skills, with the ability to present data findings to non‑technical stakeholders.
• Knowledge of CUNY First architecture and reporting practices.
• Experience working with student learning data from Learning Management Systems (LMS) and other systems.

CUNY TITLE OVERVIEW

• Oversees collection and assessment of data for institutional research purposes.
• Compiles, maintains, and analyzes institutional data in various formats.
• Produces reports and metrics based on departmental needs; responds to time‑critical ad‑hoc requests.
• Loads, extracts, edits, and evaluates data for reporting and analytics.
• Maintains selected databases and document libraries, updating and ensuring data quality and accuracy.
• May participate in internal and external surveys as needed.
• May consult with others to design methodology for research projects.
• Performs related duties as assigned.

FLSA

Exempt

COMPENSATION AND BENEFITS

Salary Range: $57,252 – $86,741. Salary commensurate with education and experience.

CUNY’s benefits contribute significantly to total compensation, supporting health and wellness, financial well‑being, and professional development. Health plans, competitive retirement/pension benefits and savings plans, tuition waivers for CUNY graduate study, and generous paid time off are offered. Staff also benefit from the extensive academic, arts, and athletic programs on campus and the opportunity to participate in a lively, diverse academic community in one of the greatest cities in the world.

(CURRENT CONTRACTUAL SALARY RANGE) CUNY is implementing salary schedule increases. Once implemented, salaries of eligible employees will be adjusted by 3.5% effective 9/1/26, in accordance with the terms of the PSC‑CUNY collective bargaining agreement.

HOW TO APPLY

Please visit www.cuny.edu, access the employment page, log in and create a new user account, and search for this vacancy using JOB ID# 32400 or the Title "Institutional Research Specialist". Select "Apply Now" and provide a resume and cover letter.

CLOSING DATE

Open until filled. Review of resumes will begin on July 13, 2026.

JOB SEARCH CATEGORY

CUNY Job Posting: Managerial/Professional

EQUAL EMPLOYMENT OPPORTUNITY

CUNY encourages people with disabilities, minorities, veterans, and women to apply. At CUNY, Italian Americans are also included among our protected groups. Applicants and employees will not be discriminated against on the basis of any legally protected category, including sexual orientation or gender identity. EEO/AA/Vet/Disability Employer.

JOB ID

32400

LOCATION

CUNY School of Medicine

JOB TYPE

Full‑Time