Data Analyst I (Remote)

Summary

The University of Missouri-Columbia is seeking a Data Analyst I to join their Solutions and Analytics Team within Mizzou Online. This role involves analyzing and interpreting higher education data to provide insights and support improvement initiatives through the creation of reports and dashboards.

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 primary data and adds supporting data for use specifically in Power BI
• Organize and model data using SQL
• Uses Dax and M to create fields as needed for Power BI
• 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
• 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
• Maintains documentation for data management, analysis and reporting activities
• Performs other job-related duties as assigned

Skills

• 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
• 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
• Advanced professional experience in data analysis and reporting including the use of data visualization tools (e.g., PowerBI, Tableau, Excel Pivot tables and charts,etc)
• Professional experience using Power BI, specifically using Dax with a working knowledge of M
• Two or more years of experience in working in Higher Education and/or working with Higher Education datasets (e.g., PeopleSoft, Slate, IPEDs)
• Two or more years of experience with structured query language (SQL) to query, analyze, validate and model data
• Knowledge of data controls and applicable regulatory/legal requirements (e.g. HIPAA, FERPA, GLBA, FTC, PCI, etc.) in protecting confidential and/or sensitive data

Qualifications

Must Haves

• 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
• 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

Nice to Haves

• Advanced professional experience in data analysis and reporting including the use of data visualization tools (e.g., PowerBI, Tableau, Excel Pivot tables and charts,etc)
• Professional experience using Power BI, specifically using Dax with a working knowledge of M
• Two or more years of experience in working in Higher Education and/or working with Higher Education datasets (e.g., PeopleSoft, Slate, IPEDs)
• Two or more years of experience with structured query language (SQL) to query, analyze, validate and model data
• Knowledge of data controls and applicable regulatory/legal requirements (e.g. HIPAA, FERPA, GLBA, FTC, PCI, etc.) in protecting confidential and/or sensitive data

Benefits

• 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
• Faculty & Staff Benefits website at https://www.umsystem.edu/departments-staff/human-resources/benefits-retirement