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

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 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. #J-18808-Ljbffr The City University of New York