"Professional Services Specialist 2 (Lead Data Analyst)"

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

Company: Kean University

Job Location: Union, 07083

Category: Institutional Research and Planning

Type: Full-Time

Job Number: R3938

TITLE:

Professional Services Specialist 2 (Lead Data Analyst)

LOCATION:

Kean University, 1000 Morris Avenue, Union, NJ 07083

DUTIES:

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.

EDUCATION/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; 2 years of experience must include the following: 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.

Please apply at: https://kean.wd503.myworkdayjobs.com/Kean Refer to #R3938. Please submit your cover letter, resume/CV and contact information for three professional references. Official transcripts are required prior to the starting date of employment.

In compliance with New Jersey's Pay Transparency Law, the designated annual salary for this position is $99,754.02. This position may also be eligible for a comprehensive benefits package, including health and dental insurance, a retirement plan and benefits for work life balance. For a full overview of our benefits offerings, please refer to our Kean University Benefits website.