Data Analyst I

NCAT • Greensboro, NC

4d

About The Position

This is a pooled posting in which the department is recruiting to fill two vacancies for Data Analyst I (#009922 and #009918. Applicants will be considered for both positions and offers will be extended to selected candidates based on the individual’s education and experience.” 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 Research. 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?Power BI 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.

Requirements

• 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.

Nice To Haves

• Advanced degree (master’s or doctoral).
• Proficient in developing more advanced and complex SQL queries.
• Extensive experience in building dashboards and proficiency with Tableau or Power BI
• 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.

Responsibilities

• 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?Power BI 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Number of Employees: 501-1,000 employees