Professional Services Specialist 2, Division of Strategic Analytics and Data Illumination (SADI)

Kean University•Union, NJ

2d•$99,754

About The Position

Responsible for the gathering, assessment, cleaning, aggregating and analysis of data from a wide range of stakeholder groups across the university to ensure Kean University is fulfilling its mission and meeting its strategic goals. This is a highly collaborative position that works closely with a diverse team of administrators, faculty, staff and students to enhance institutional effectiveness through data democratization. As such, this position communicates and collaborates across the institution to develop best practices for data analysis and visualization in accordance with the University’s policies and procedures. Build interactive, dynamic, and effective data visualizations and data dashboards to drive actionable insights and democratize data across the university community. Partner with various departments, including but not limited to the Office of Research and Sponsored Programs, the Nancy Thompson Learning Commons, and the Division of General Education and Interdisciplinary Studies, to help address their strategic and tactical business needs on appropriate data management, data structure, data quality, and utilize best practices on reporting requirements, and business process analysis. Collaborate with the Institutional Research (IR) team to develop and maintain reporting systems, data validations, and data models using business intelligence (BI) tools and Database Management System (DBMS). Generate ad hoc reports and run queries on research data, students, and other university related data from platforms such as Ellucian Colleague, Advise CRM, and Informer on a regular basis for internal reporting purposes. Develop a platform and business intelligence (BI) insights to optimize the processes by which research and sponsored programs data is gathered, validated, and reported in a standard format required for the annual NSF HERD Survey in support of R2 designation. Serve as a lead and a central hub of data requests from a wide range of client groups across the university and support the collection, analysis, and delivery of data via a cloud-based project management platform. Maintain the Enrolled but Not Registered (ENR) user dashboard, which updates daily, to provide data on student registration patterns to university stakeholders in support of campus-wide retention initiatives. Design, develop, implement, and maintain strategic competency-based education related metrics and reports and assist in decision making at all levels and in all areas of the university, including presenting to senior leadership. Manage and update the Exit Survey Report and associated dashboard, which is shared with the department chairs and college deans in coordination with the Office of Accreditation and Assessment. Monitor and report on the outcomes of student learning experiences and faculty involvement with student assessment through course evaluations in collaboration with the Office of Accreditation and Assessment. Assist with data preparation, formatting, and reporting of specialized accreditation programs for the Office of Accreditation and Assessment. Serve on the University Data Governance Committee. Other duties that support the Division of Strategic Analytics and Data Illumination.

Requirements

Position requires a Master’s degree (or foreign equivalent) in Information Management, Information Systems, Data Analytics or a related field.
2 years of post-bachelor’s experience analyzing data in an institution of higher education, in education or a field that is directly related to data collection, analysis and reporting
Microsoft Excel: Experience with advanced MS Excel functions: conditional formatting, advanced charting, data validation, pivot tables, and data modeling.
Microsoft Access: Knowledge of creating data models and writing queries on MS Access to store, organize, and retrieve data.
Power Query: Ability to incorporate the volume of data from various external sources; append or merge data models or queries; clean and transform data; synthesize data and create uniformity.
SQL: Skilled in writing complex queries, ability to join multiple tables, stored procedures, T-SQL, and Knowledge of database structures and ad-hoc reporting using SQL Server Management Studio (SSMS).
Data Analysis Expressions (DAX): Strong working knowledge of DAX expressions/queries to create measures, calculated columns, and calculated.
PowerBI: Strong proficiency in creating interactive and dynamic dashboards/visualizations in Power BI Desktop and Power BI Service.

Responsibilities

gathering, assessment, cleaning, aggregating and analysis of data
Build interactive, dynamic, and effective data visualizations and data dashboards
Partner with various departments to help address their strategic and tactical business needs on appropriate data management, data structure, data quality, and utilize best practices on reporting requirements, and business process analysis.
Collaborate with the Institutional Research (IR) team to develop and maintain reporting systems, data validations, and data models using business intelligence (BI) tools and Database Management System (DBMS).
Generate ad hoc reports and run queries on research data, students, and other university related data from platforms such as Ellucian Colleague, Advise CRM, and Informer on a regular basis for internal reporting purposes.
Develop a platform and business intelligence (BI) insights to optimize the processes by which research and sponsored programs data is gathered, validated, and reported in a standard format required for the annual NSF HERD Survey in support of R2 designation.
Serve as a lead and a central hub of data requests from a wide range of client groups across the university and support the collection, analysis, and delivery of data via a cloud-based project management platform.
Maintain the Enrolled but Not Registered (ENR) user dashboard, which updates daily, to provide data on student registration patterns to university stakeholders in support of campus-wide retention initiatives.
Design, develop, implement, and maintain strategic competency-based education related metrics and reports and assist in decision making at all levels and in all areas of the university, including presenting to senior leadership.
Manage and update the Exit Survey Report and associated dashboard, which is shared with the department chairs and college deans in coordination with the Office of Accreditation and Assessment.
Monitor and report on the outcomes of student learning experiences and faculty involvement with student assessment through course evaluations in collaboration with the Office of Accreditation and Assessment.
Assist with data preparation, formatting, and reporting of specialized accreditation programs for the Office of Accreditation and Assessment.
Serve on the University Data Governance Committee.
Other duties that support the Division of Strategic Analytics and Data Illumination.