Associate Data Analyst - DUAL POSTING with JOID 50711

at  University of Missouri

JOB DESCRIPTION

The Associate Data Analyst position is within the University Data, Analytics, and Institutional Research division and will be responsible for collecting, analyzing, and reporting on institutional data in support of the universities decision-making and planning. The position also assists with integrating data across all institutional information systems, the collection of data to complete internal and external surveys, data reports and projects, responding to ad hoc data requests and perform/create various reports and analyses.

Key Responsibilities

• Support operational business analytics through business intelligence development, data modeling, analyses, support documentation, reports, and deliverable maintenance for a variety of stakeholders throughout the campus.
• Uses basic statistical methods to analyze data and generate useful reports (e.g., distributions, variance, etc.). Uses data visualization tools to present results and information. Ability and desire to learn and use new software applications.
• Well-developed verbal and written communication skills, including the ability to relay data issues in an organized and easily understandable manner. Strong interpersonal skills with a customer-service orientation, and the ability to work independently as well as collaboratively in a fast-paced environment. Assists with developing, preparing, delivering and interpreting department or unit specific data sets. Prepares routine reports, apps, dashboards, presentations, and proposals that are easy to read and interpret.
• Provides basic subject matter expertise about data quality, task suitability, and availability. Complete and present data reports and dashboards requested by the college, departments and offices explaining complex information including recommendations based on findings from the analysis of data.
• Establish relationships with internal departments to inform data analysis and reporting.
• Design and suggest tables needed to develop automated reports and dashboards to deliver timely and up to date information delivery.
• Produce ad hoc and periodical reporting by utilizing university data, primarily by writing SQL and using Microsoft Power BI. Extensively use Excel’s advanced functionality, such as pivot tables, formulas, to develop and optimize routine reporting.
• Assist with developing short- and long-term analytics goals for stakeholders and units. Maintain documentation for data management, analysis and reporting activities.

Applicants must be authorized to work in the United States. The University will not sponsor applicants for this position for employment visas.

MINIMUM QUALIFICATIONS

Bachelor’s degree or an equivalent combination of education and relevant experience is necessary

PREFERRED QUALIFICATIONS

• Demonstrated ability in using the Microsoft 365 Office Suite, including an intermediate or advanced knowledge of Excel (i.e., pivot tables, formulas, etc.).
• Familiarity with data visualization tools (e.g., Microsoft Power BI, Tableau, Cognos) as well as experience with programmable software.
• Well-developed verbal and written communication skills, including the ability to relay data issues in an organized and easily understandable manner.
• Strong interpersonal skills with a customer-service orientation, and the ability to work independently as well as collaboratively in a fast-paced environment.
• Excellent time management and organizational skills with a keen orientation to detail and concern for accuracy, as well as the ability to handle multiple tasks simultaneously and meet deadlines.
• Ability and desire to learn and use new software applications.

• Support operational business analytics through business intelligence development, data modeling, analyses, support documentation, reports, and deliverable maintenance for a variety of stakeholders throughout the campus.
• Uses basic statistical methods to analyze data and generate useful reports (e.g., distributions, variance, etc.). Uses data visualization tools to present results and information. Ability and desire to learn and use new software applications.
• Well-developed verbal and written communication skills, including the ability to relay data issues in an organized and easily understandable manner. Strong interpersonal skills with a customer-service orientation, and the ability to work independently as well as collaboratively in a fast-paced environment. Assists with developing, preparing, delivering and interpreting department or unit specific data sets. Prepares routine reports, apps, dashboards, presentations, and proposals that are easy to read and interpret.
• Provides basic subject matter expertise about data quality, task suitability, and availability. Complete and present data reports and dashboards requested by the college, departments and offices explaining complex information including recommendations based on findings from the analysis of data.
• Establish relationships with internal departments to inform data analysis and reporting.
• Design and suggest tables needed to develop automated reports and dashboards to deliver timely and up to date information delivery.
• Produce ad hoc and periodical reporting by utilizing university data, primarily by writing SQL and using Microsoft Power BI. Extensively use Excel’s advanced functionality, such as pivot tables, formulas, to develop and optimize routine reporting.
• Assist with developing short- and long-term analytics goals for stakeholders and units. Maintain documentation for data management, analysis and reporting activities