| Department Name: Enterprise Data Solutions Team UNCA | Working Title: Data Analyst |
| FLSA Designation: Exempt - Skilled IT professional | FTE: 100.00 |
| RESPONSIBILITY | TIME SPENT PERCENTAGE | ESSENTIAL FUNCTION | TASKS |
|---|---|---|---|
| 100 | X | 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 |
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. |
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. |
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. |
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. |
This position receives guidance and supervision from the Director of Enterprise Data Solutions. |
Does this position supervise?:
No |
Office |
| Sit: Frequently (34-66%) | Bending:  |
| Stand: Occasionally (1-33%) | Kneeling:  |
| Walk: Occasionally (1-33%) | Reaching:  |
| Drive Motor Vehicle:  | Crawling:  |
| Squatting:  | Climbing:  |
| Keyboard: YES | Pipefitting:  |
| Fine Manipulation:  | Grasping:  |
| Repetitive Motion:  |
If other use of hands/ wrists, please explain:
Standard operation of office and computer equipment |