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

The City University of New York; New York (NY); On-site; USD 52,267 - 86,645; Full time

Benefits offered by this job

Health plans

Competitive retirement benefits

Tuition waivers for CUNY graduate study

Generous paid time off

Job summary

A prominent educational institution in New York is seeking an Institutional Research Specialist to design and implement data integration solutions. The role requires collaboration with various departments and involves ensuring data accuracy for decision-making. Ideal candidates will possess a Bachelor's degree and relevant experience in data integration. Competitive salary and benefits offered, commensurate with experience.

Qualifications

• Bachelor's Degree and four years' relevant experience.
• Experience in data integration or database administration.
• Knowledge of CUNY First architecture and reporting practices.

Responsibilities

• Develop and maintain data integration solutions.
• Collaborate with stakeholders to understand data requirements.
• Monitor and troubleshoot data integration workflows.

Skills

Data integration

SQL

Microsoft 365 BI tools

Problem-solving

Collaboration

Education

Bachelor's Degree

Master’s degree in related field

Tools

Power BI

Power Automate

Job description

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

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 months 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 our student body.

Summary

CUNY SoM is seeking a Institutional Research Specialist (Data Integration). The Institutional Research Specialist – Data Integration will be responsible for designing, implementing, and maintaining data integration solutions at the CUNY School of Medicine. This role involves collaborating with multiple departments to ensure seamless data flow and integration. Located within the Office of Institutional Effectiveness, this role supports the office’s institutional research, assessment, accreditation, and strategic decision support activities.

Responsibilities

• 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 updated 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

Required: Bachelor\'s Degree and four years\' relevant experience.

Preferred

• Master’s degree in Mathematics, Statistics, Computer Science, or 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 department\'s 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 in designing methodology for research projects.
• Performs related duties as assigned.

CUNY Title

Higher Education Assistant

FLSA

Exempt

Compensation And Benefits

Salary Range: $52,267 - $86,645. Salary commensurate with education and experience. CUNY\'s benefits contribute significantly to total compensation, supporting health and wellness, financial well-being, and professional development. We offer a range of health plans, competitive retirement/pension benefits and savings plans, tuition waivers for CUNY graduate study and generous paid time off.

(CURRENT CONTRACTUAL SALARY RANGE) CUNY is in the process of implementing salary schedule increases. Once implemented, salaries of eligible employees will be adjusted by 6.09% with additional increases of 3.25% effective 9/1/2025 and 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 the JOB ID# 30754 or Title: Institutional Research Specialist. Select "Apply Now" and provide the requested information. Candidates should provide a resume and cover letter.

Closing Date

Open until filled. Review of resumes will begin on August 18, 2025.

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.