Data Analyst I

MU Analytics

The Data Analyst will gather, analyze, and report on institutional data, supporting decision-making and planning for both campus and graduate school initiatives. Reporting to the Senior Director of Analytics within the University Data Analytics and Institutional Research (UDAIR) division, this role is dedicated to meeting the analytics needs of MU Institutional Research and the Graduate School. The Data Analyst plays a crucial role in integrating data across all institutional information systems, compiling data for internal and external reports and projects, responding to ad hoc data requests, and generating various reports and analyses. This position typically utilizes specialized business intelligence applications and cloud services but may also employ the reporting capabilities of existing ERP, CRM, and database software vendors.

• Conduct high-level analysis of data to identify and understand problems through forecasting, gap analysis, quantitative reporting, research, and statistical analysis. Utilize the data to pinpoint problems and explore solutions. Utilize technical skills including proficiency with tools such as data analytic software (R, SAS, Minitab, SPlus, Power BI, Cognos, Python, Tableau) and data collection services.
• Complete and present data reports and dashboards requested by the college, departments, and support 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 facilitate the development of warehouse 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.
• Produce complex, action-driven, competitive intelligence products based on funding program analyses, faculty data, bibliometric trends, national datasets, etc.
• Effectively communicate in all modalities, explain complex concepts, and tailor communications by audience.
• Thoroughly understand and engage in process improvements for the MU Graduate School and Institutional Research.
• 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.

Typically, 8:00 a.m. to 5:00 p.m. Monday through Friday; however, there may be occasions where extended hours are necessary.

Must be available for reliable and consistent onsite work.

Bachelor's degree or an equivalent combination of education and relevant experience and at least 2 years of experience from which comparable knowledge and skills can be acquired is necessary.

• 4 years experience in a professional setting, preferably at an institution of higher education, experience in data analytics and reporting, as well as prudence in handling sensitive and confidential information.
• Demonstrated ability in using the Microsoft 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.
  

Salary Range: $58,573 - $83,000 yearly
Grade: GGS-011
University Title: Data Analyst I
Internal applicants can determine their university title by accessing the Talent Profile tile in myHR.

Online application, resume, and cover letter. References upon request.

Columbia offers small-town friendliness with big city features and a high quality of life for people of all ages and interests. Founded on education and known as an ideal college town, its location also makes it an attractive spot for businesses and travelers. Located on Interstate 70 and U.S. Highway 63, Columbia is right in the middle of the state and the nation. Just a couple hours' drive from St. Louis and Kansas City, Columbia is Boone County's largest population center offering big-city culture, activities, and resources with a low cost of living. Columbia is home to a variety of restaurants and entertainment venues and hosts more than a dozen cultural festivals each year. If you want to grow your career, continue your education, raise a family, and retire, Columbia is a good place to be!

This position is eligible for University benefits. As part of your total compensation, the University offers a comprehensive benefits package, including medical, dental and vision plans, retirement, paid time off, short- and long-term disability, paid parental leave, paid caregiver leave, and educational fee discounts for all four UM System campuses. For additional information on University benefits, please visit the Faculty & Staff Benefits website at https://www.umsystem.edu/totalrewards/benefits.

Values Commitment

We value the uniqueness of every individual and strive to ensure each person's success. Contributions from individuals with diverse backgrounds, experiences and perspectives promote intellectual pluralism and enable us to achieve the excellence that we seek in learning, research and engagement. This commitment makes our university a better place to work, learn and innovate.

In your application materials, please discuss your experiences and expertise that support these values and enrich our missions of teaching, research, and engagement.

Equal Employment Opportunity

The University of Missouri System is an Equal Opportunity Employer. Equal Opportunity is and shall be provided for all employees and applicants for employment on the basis of their demonstrated ability and competence without unlawful discrimination on the basis of their race, color, national origin, ancestry, religion, sex, pregnancy, sexual orientation, gender identity, gender expression, age, disability, or protected veteran status, or any other status protected by applicable state or federal law. This policy applies to all employment decisions including, but not limited to, recruiting, hiring, training, promotions, pay practices, benefits, disciplinary actions and terminations. For more information, visit https://www.umsystem.edu/ums/hr/eeo or call the Director of Employee and Labor Relations at 573-882-2146.

To request ADA accommodations, please call the Director of Accessibility and ADA at 573-884-7278.