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

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 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.

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. In addition to the summary, the Institutional Research Specialist - Data Integration will be responsible for but not limited to the following:

• 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

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

Preferred:

• Master’s degree 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 tonon-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