Institutional Data and Reporting Analyst

Job DetailsJob Location: Allentown, PA 18104Position Type: Full TimeEducation Level: 4 Year DegreeSalary Range: $45,000.00 - $55,000.00 Salary/yearJob Category: StaffThis is an on-site position at our Allentown, PA Campus. The College seeks a detail-oriented and analytical professional to serve as Institutional Data and Reporting Analyst responsible for extracting, cleaning, maintaining, and analyzing institutional data to support strategic planning, accreditation, external reporting, and academic operations. This is a technical data analytics position therefore, candidates must have demonstrated hands-on experience writing SQL or another relational database query language and developing dashboards using Power BI, Tableau, or a similar business intelligence platform. Reporting to the Director of Institutional Effectiveness/Registrar, the Institutional Data and Reporting Analyst provides timely and accurate data to internal and external constituents while ensuring compliance with FERPA and institutional data governance standards. The successful candidate serves as a collaborative partner across the institution, working with colleagues to identify challenges, developing data-informed solutions, and supporting outcomes that advance the College's mission and strategic priorities. Essential Responsibilities · Extract, analyze, and interpret data from the College's Student Information System and related databases using SQL, MS Access, or related tools. · Develop and maintain institutional dashboards and reports using Power BI. · Coordinate external reporting and survey submissions, including IPEDS, the Common Data Set, U.S. News, College Board, NCAA, and NC-SARA. · Maintain data repositories and reporting structures that support longitudinal analysis, institutional effectiveness, and strategic planning. · Provide analytical support for accreditation activities, academic program review, benchmarking studies, and departmental projects. · Produce academic reports and academic calculations, including Dean's List, honor society eligibility, and academic standing reports. · Administer course evaluation and student survey systems and analyze resulting data. · Conduct data audits and quality assurance reviews to ensure accuracy, consistency, and compliance with FERPA and institutional policies. · Demonstrate ownership of projects and outcomes by proactively identifying issues, recommending solutions, and working collaboratively across departments to resolve challenges that affect institutional operations. · Remain informed about emerging technologies, analytics practices, and artificial intelligence tools that can improve efficiency, reporting, and institutional effectiveness.  QualificationsRequired Qualifications · Bachelor's degree in computer science, data analytics, data science, statistics, or a related field. · Advanced, hands-on experience writing SQL queries (or an equivalent relational database query language) against databases containing multiple related tables to extract, join, manipulate, validate, and analyze data for reporting and analysis. · Demonstrated hands-on experience developing and maintaining interactive dashboards using Power BI, Tableau, or a similar business intelligence platform. Candidates should be able to independently develop dashboards from underlying data sources, including data preparation, visualization, and ongoing maintenance. · Advanced spreadsheet skills, including pivot tables and data analysis functions. · Ability to communicate analytical findings clearly and effectively to a variety of audiences. · Strong organizational, problem-solving, and project management skills. · Ability to manage multiple priorities and meet strict deadlines while maintaining a high degree of accuracy. · Demonstrated curiosity, adaptability, and willingness to continuously develop skills related to data analytics, artificial intelligence, and emerging technologies. Preferred Qualifications · Experience in higher education, institutional research, or academic operations. · Familiarity with higher education reporting requirements and accreditation processes. · Knowledge of student information systems such as Jenzabar, Banner, Colleague, or similar enterprise systems. · Experience with statistical software such as SPSS. The successful candidate will possess exceptional attention to detail, strong analytical abilities, intellectual curiosity, and a commitment to providing accurate, ethical, and actionable information in support of the College's mission.     What We Offer  Be Part of a Purpose-Driven Community: Your work will help create a safe, beautiful, and inviting campus that supports learning, leadership, and civic engagement.   Work in a Unique Setting: Our campus is a certified arboretum, offering the opportunity to care for a diverse collection of trees and green spaces in a historic and inspiring environment.   Comprehensive Benefits: In addition to health, dental, vision, and retirement benefits, we offer a unique tuition benefit for employees and their families. While Cedar Crest is a women’s college, men can access certain classes on campus and others at partner institutions, making this benefit flexible and valuable for all.   Support for Growth: We encourage professional development and provide training opportunities for team members.   Campus Culture: Cedar Crest is a place where your story is valued. We see you, and we’re here to help you shape your future.     How to Apply  For full consideration, please submit:   Current resume   Cover letter highlighting your relevant experience   Contact information for three professional references     Cedar Crest College’s excellent safety and security record is attributable to the location   of the college in a low crime area, its efforts to ensure the safety of students, faculty and   staff, and to the cooperation of the entire campus community.     The annual security report is available to all students, faculty, and staff online at:  http://www.cedarcrest.edu/ca/security/SecurityBooklet01-06 low.pdf