Additional Info

General Position Information


Department Name: Enterprise Data Solutions Team UNCAWorking Title: Data Analyst
FLSA Designation: Exempt - Skilled IT professionalFTE: 100.00

Position Description Details


Responsibilities and Duties


RESPONSIBILITYTIME SPENT PERCENTAGEESSENTIAL FUNCTIONTASKS
100X

Complete regular reporting requirements for the Office of the President

Fulfill ad hoc data requests from both internal and external stakeholders

Maintain and create data dashboards

Extract data from an enterprise database

Summarize data using descriptive statistics and visualizations that aid in end users’ interpretation and utilization of the data

Work closely with team members to build and model data that meet data reporting needs

Ensure the security of highly confidential data

Other duties as assigned


Zone Definition Factors


Knowledge Skills and Abilities


The Data Analyst must possess excellent written and verbal communication skills, the ability to work cooperatively with an interdisciplinary team, and excellent problem-solving and listening skills. The Data Analyst uses visualization tools, knowledge of basic statistics, and data from a variety of sources (e.g., enterprise databases, spreadsheets, text files) to provide data and analyses to various stakeholders while ensuring appropriate data security and confidentiality.  The Data Analyst should be familiar with performing calculations in Microsoft Excel (e.g., SUMIF, lookups via V/H LOOKUP, INDEX & MATCH), as well as using SQL to write simple queries that join tables and extract data from an enterprise data warehouse. Furthermore, the Data Analyst needs to have a solid understanding of summarizing data using descriptive statistics (e.g., mean, median, standard deviation, distribution, etc.) and visualizations. The Data Analyst should also know how to use Tableau or other similar software to connect to a database and summarize/visualize data.


Problem Solving - Decision Making


The Data Analyst must be able to manage multiple projects with competing deadlines while maintaining the flexibility needed to answer unanticipated data requests with quick turnarounds. Decisions regarding the prioritization of tasks and data requests often change and need to be made quickly to meet aggressive customer demands. With guidance from the Director, the Data Analyst is expected to work through obstacles, adapt to changing technology and reporting requirements, identify opportunities for increasing efficiencies and effectiveness, and anticipate future questions and needs.


Impact


Leaders at the University of Nebraska rely on the Data Analyst to provide some of the data that guides their policy decisions and evaluations. Under the guidance and coordination of the Director of the Enterprise Data Solutions team, the Data Analyst ensures that the University of Nebraska complies with and meets all mandatory reporting requirements, such as those from the state and federal government, as well as credit agencies.


Interactions


Data requests are often vague and subject to interpretation, so the Data Analyst needs to be able to communicate and work with stakeholders to clarify, better understand, and ultimately meet their data needs. The Data Analyst must be able to work with others on the Enterprise Data Solutions team to learn how to use the data, seek guidance regarding more complex data requests, and model data for reporting needs. Additionally, the Data Analyst needs to be able to work with people at various levels within the University of Nebraska (technology staff, business stakeholders, end users, management) and others outside the organization.


Supervision Received


This position receives guidance and supervision from the Director of Enterprise Data Solutions.


Supervision Exercised


Does this position supervise?:

No


Work Environment & Physical Demands


Working Environment


Office


Activity Frequency


Sit: Frequently (34-66%)Bending: 
Stand: Occasionally (1-33%)Kneeling: 
Walk: Occasionally (1-33%)Reaching: 
Drive Motor Vehicle: Crawling: 
Squatting: Climbing: 

Use of Hands/ Wrists


Keyboard: YESPipefitting: 
Fine Manipulation: Grasping: 
Repetitive Motion: 

If other use of hands/ wrists, please explain:

Standard operation of office and computer equipment