Data Analyst II

SOM Applications and Analytics

* Perform assignments and responsibilities of varying degrees of complexity and diversity to support the specialized needs of the university.
* Apply perspectives based on experience in key specialty areas to drive outcomes and impact university-wide initiatives.
* Analyze and process complex datasets to provide actionable insights, visualizations, and statistical modeling while solving technical challenges through regulatory research and expert judgment.
* Use analytical findings to provide strategic recommendations and ensure program compliance across the organization.
* Lead requirements gathering, explain sensitive information to build consensus, and assess projects for substantial security and intellectual property impact on the University.
* Utilize deep knowledge of School of Medicine business processes to develop innovative reporting solutions that impact a wide range of customer and project activities.
* Interpret data trends and track KPIs by utilizing SQL, Python, or R to deliver accurate data storytelling and visualizations through Power BI, Tableau, and Excel.
* Perform data cleaning, transformation, and statistical analysis within relational databases to ensure high-quality reporting and insights.
* Utilize strong knowledge of SharePoint, Agile, and Waterfall methodologies to manage projects and collaborate effectively across teams.
* Manage interoperability across HR, Research, and Education domains using ETL tools such as Active Batch or SSIS.
* Design and maintain full stack web applications using React, C#, RESTful APIs, SQL, UI/UX principles and Git version control.
* Audit manual workflows to implement automated processes and develop AI agents or scripts that drive organizational efficiency and error reduction.
* Manage data integrity and stable connectivity across disparate systems while navigating complex firewall rules and security protocols.
* Balance core senior analyst responsibilities with programming and development tasks as needed to meet evolving organizational goals and technical projects.

Monday - Friday
8:00 a.m. - 5:00 p.m.

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

* Masters Degree in Data Science, Computer Science, or Similar
* Data governance and pipeline optimization
* Data warehousing and architecture, specifically Snowflake
* Familiarity with higher education or healthcare environments
* Proficiency with Adobe Suite or other authoring tools
* Advanced knowledge of database schema and management
* Full stack development experience
* Building AI agents for process improvement

Salary Range: $69,097.60 - $134,950.40 annually
Grade: GGS - 012
University Title: DATA ANALYST II
Internal applicants can determine their university title by accessing the Talent Profile tile in myHR.

In addition to the Online Application, please provide a Cover Letter and Resume.

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

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.