Data Analyst 1 (Remote)

University of Missouri-Columbia; Columbia Township (MO); Remote; USD 70,000 - 77,000; Full time

Benefits offered by this job

Medical plan

Dental plan

Vision plan

Retirement plan

Paid time off

Disability insurance

Parental leave

Caregiver leave

Educational fee discounts

Job summary

University of Missouri System, through Mizzou Online, seeks a Data Analyst I to transform higher-education datasets into actionable insights. The role focuses on turning data into easy-to-use reports and dashboards for stakeholders with a service-oriented mindset.

You will analyze, model, and organize data from various sources, collaborating with stakeholders to produce clear, interpretable outputs and supporting continuous improvement in data practices.

Qualifications

• Bachelor's degree or equivalent with at least 2 years' relevant experience.
• Experience with SQL in cleaning, transforming, and modeling data.
• Experience analyzing, validating, and modeling data for reporting purposes.

Responsibilities

• Analyzes and interprets higher education data to uncover insights, patterns, trends, and associated success metrics.
• Organizes primary data and adds supporting data for use in data visualization, dashboard creation, reporting, and ad hoc requests.
• Coordinates and collaborates with stakeholders to develop and provide basic actionable information in support of improvement initiatives.
• Creates routine reports, dashboards, and presentations that are easy to read and interpret using data visualization tools.
• Maintains documentation for data management, analysis and reporting activities.

Skills

Collaboration

Communication

Data analysis

Attention to detail

Education

Bachelor's degree

Tools

SQL

Data visualization tools

Job description

Hiring Department

Mizzou Online

This recruitment is managed by the Office of Human Resources at the Columbia Campus. For application questions please contact OHR at 573-882-7976.

Job Description

The Solutions and Analytics Team within Mizzou Online delivers scalable, high-performing analytic dashboards, reports, and insights to stakeholders at MU. We are seeking an analyst to help discover actionable data from a variety of higher education sources. The ideal candidate will enjoy transforming data into easy-to-use reports and dashboards, and have a service-oriented mindset with a strong desire to help stakeholders uncover insights from learning-related datasets.

Job Responsibilities

Analyzes and validates data

• Analyzes and interprets data sets specific to higher education to uncover insights, patterns, trends, and associated success metrics.
• Ensures accuracy and validity of queries and the data being produced.

Organizes and models data

• Organizes primary data and adds supporting data for use in data visualization, dashboard creation, reporting, and ad hoc requests.
• Organize and model data using SQL.

Collaborates with stakeholders

• Coordinates and collaborates with stakeholders and other subject matter experts to develop and provide basic actionable information in support of improvement initiatives.
• Promotes the use of data to answer questions in support of unit goals.

Builds reports and presentations

• Using the collected data and information gathered from meeting with stakeholders, creates routine reports, dashboards, and presentations that are easy to read and interpret.
• Uses data visualization tools to present results and information.

Documentation and continuous improvement

• Maintains documentation for data management, analysis and reporting activities.

Performs other job-related duties as assigned.

Knowledge, Skills & Abilities

• Strong collaboration and time management skills
• Ability to communicate data concepts to stakeholders and audiences with varied levels of expertise
• Proven analytical and problem-solving skills with attention to detail and a passion for data accuracy
• Possesses an in-depth conceptual and practical knowledge in the data analysis function and begins to acquire knowledge in other related functions

Shift

8AM-5PM CST Monday - Friday

Minimum Qualifications

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

Preferred Qualifications

• Two or more years of experience with structured query language (SQL) in cleaning and transforming and modeling data.
• Advanced professional experience analyzing, validating, and modeling data for reporting purposes.
• Advanced professional experience in data analysis and reporting including the use of data visualization tools.
• Experience working in Higher Education and/or working with Higher Education datasets.
• Knowledge of data controls and applicable regulatory/legal requirements protecting confidential and/or sensitive data.

Anticipated Hiring Range

Salary Range: $70,000 - $77,000 annually

Grade: GGS-11

University Title: Data Analyst I

Internal applicants can determine their University title by accessing the Talent Profile tile in myHR.

Application Materials

Resume and Cover Letter - In your cover letter, please address the questions below, be specific, using examples from your own experience.

1. What tools to you use to create a data model for a dataset, and what steps do you take to validate your data model?
2. What kinds of higher education datasets are you looking foward to working with in this position and why?

Sponsorship Information

Employment visa sponsorship is not available for this position.

Benefit Eligibility

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
• 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/departments-staff/human-resources/benefits-retirement

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer.

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