Data Analyst I

Description: The position of Data Analyst is primarily responsible for data analysis and delivering information to support specialized accreditation, campus literacy, reporting needs, and strategic decisions. The core duties of the Data Analyst include determining the logical flow of a project, developing scripts for data management and validation, conducting analysis and reporting, and delivering information via business intelligence and analytics tools. Ability to communicate effectively, work independently and in a team with a results-oriented approach, create and maintain collegial working relationships with customers and co-workers, contribute to a positive and inclusive work environment, and be a productive team member is expected. This position reports to the Director of Institutional Effectiveness.Further role responsibilities include but are not limited to:-Program and Institutional Accreditation Support: Support the accreditation process by working collaboratively with faculty, staff, and administrators to compile and prepare reports supporting self-studies and other accreditation-related reports and requirements. Develop and maintain an ongoing library of key data and documentation as evidence of compliance. Work closely and collaboratively with lead University personnel to identify compliance responsibilities, advise on efficient methods of operation, and coordinate the collection and organization of narratives, materials, and evidence that documents processes.

Data management and quality control: Ensure accurate use of data for analysis and reporting. Identify issues and take actions to correct inconsistencies in the datasets. Run queries, manipulate and analyze data using applications such as SQL , R, SAS , etc. This may require collaborations with various university departments as necessary to gather and deliver information.

Data visualization: Identify information needs, integrate data elements, and create datasets in preparation for data visualization. Develop and maintain Tableau dashboards of institutional data to support campus data literacy and the efforts related to planning, assessment, and institutional effectiveness. The dashboard examples include institutional fact book, accountability metrics/score cards, and projects in support of strategic planning, program review, and accreditation activities.

Data analysis and reporting: Support data analysis, reporting needs (internal and external), and ad hoc data requests using appropriate analytical methods and tools.

Complete additional tasks as assigned.

We have multiple positions available within the Institutional Effectiveness & Accreditation Your application will receive consideration for positions 009915, 009918, and 009922 posted on this site. Primary Function of Organizational Unit: The Office of Strategic Planning and Institutional Effectiveness ( OSPIE ) fosters student success and the University’s effectiveness by facilitating evidence-based decision-making. OSPIE serves as the primary source of official data reported from all major administrative systems across the University, conducts objective research and analysis for decision-makers, prepared reports that improve understanding of institutional and program performance, builds data collections, facilitates access to institutional data and advocates for data quality and integrity. OSPIE supports student learning assessment, the development and evaluation of academic programs and administrative functions, and institutional and program accreditation.Internal job number: 009918Requirements: Bachelor’s degree in Computer Science, Data Science, Analytics, Information Science, Statistics, or related fields; or equivalent combination of education and two years experience in data analysis.Demonstrated skills in database programming of SQL Demonstrated skills to develop data visualization using Business Intelligence (BI) tools. Tableau preferred.Advanced proficiency in Microsoft Office applications.Well-developed interpersonal, communication, and problem-solving skills.Ability to be productive and creative, and to work collaboratively with colleagues in a team environment.Preferred: Advanced degree (master’s or doctoral).Proficient in developing more advanced and complex SQL queries.Extensive experience in building dashboards and proficiency with Tableau.Strong skills with data analysis software packages such as SAS , R, SPSS .Working knowledge of Banner Student, Financial Aid, Human Resources modules.Working knowledge of the Student Data Mart ( SDM ), Human Resources Data Marts ( HRDM ) databases, and the Insight dashboards used by the University of North Carolina System Office.Three or more years of experience working in an Institutional Research/Institutional Effectiveness or similar office.