Research and Data Analyst

State of Missouri; Jefferson City (MO); On-site; USD 60,000 - 90,000; Full time

Job summary

State of Missouri is seeking a data analyst to maintain and expand the division's research and data analytics programs. The position involves dashboards in Tableau, Smartsheet databases, and turning raw data into clear, actionable visuals to support procurement decisions.

You will collaborate with stakeholders, ensure data accuracy, and help deliver timely insights for budget requests and contract management.

Qualifications

• Bachelor’s degree plus 2+ years of data analysis experience; substitutions allowed.
• Experience with data visualization platforms, especially Tableau, preferred.
• Excellent communication and reporting capabilities.
• Strong attention to detail and analytical thinking.

Responsibilities

• Maintain the division's research and data analysis program including Smartsheet databases and Tableau dashboards.
• Develop and maintain dashboards driving data-based decision making and bid/contract data.
• Translate raw data into clear information using charts, graphs, and slides.
• Create dashboards for the buying process and customer experience for targeted audiences.
• Analyze procurement turnaround times to identify bottlenecks and trends for process improvements.
• Gather contract spend data to inform statewide contract development.
• Validate data accuracy from multiple sources and troubleshoot data issues.
• Extract data from databases to prepare reports for budgets and inquiries.
• Support division data tools and repositories.

Skills

Data analysis

Communication

Attention to detail

Adaptability

Education

Bachelor's degree

Tools

Tableau

Smartsheet

Excel

Access

PowerPoint

SQL

Job description

Location: The office for this position will be located at the Harry S Truman State Office Building, 301 W High Street, Jefferson City, MO 65101.

Why You’ll Love This Position

Do you love researching and transforming data so that it enables informed decision making? Would you enjoy being part of a team who is passionate about making the buying process more efficient for Missouri State Government? Then this is the job for you!

What You’ll Do

• Maintain the research and data analysis program for the division which includes existing databases in Smartsheet and dashboards in Tableau.
• Develop and maintain dashboards that drive data-based decision-making and existing bid and contract databases.
• Convert and validate raw data into clear, meaningful information and tell a story by creatively displaying details in charts, graphs, and slides.
• Build and maintain meaningful dashboards related to the buying process and the customer experience. Develop dashboards to targeted audiences to promote awareness and maintain an open feedback loop for continuous improvement to meet customer needs for timely data-based decision-making.
• Analyze turnaround times in procurement processes to identify bottlenecks and trends to help drive process improvements so that state agency customers obtain the products and services needed to serve their customers in a timely manner.
• Gather contract spend data to identify contract usage trends, off contract spend, and contract gaps to inform future statewide contract development that best serves the needs of state and local government agencies.
• Validate and ensure data accuracy from various data sources in various forms.
• Troubleshoot data integrity, dashboards, and other data issues that arise.
• Extract data from existing databases as necessary to prepare reports needed for budget and respond to other inquiries
• Participate in management and support of division data tools and data repositories.

Minimum Qualifications

A Bachelor’s degree and at least two years of data analysis information experience are preferred. Substitutions allowed.

Preferred Qualifications

• Experience with data visualization platforms, such as Tableau, is preferred.
• Excellent communication skills to interact with customers and determine reporting requirements.
• Outstanding attention to detail, analytical skills, and reporting capabilities.
• Ability to adapt to changing priorities and complete tasks with a sense of urgency.
• High level of proficiency in Tableau Desktop, Tableau Prep Builder, Smartsheet, Access, Excel, and PowerPoint.
• Experience with data warehouses, writing queries, developing reports and presentations, and using SQL.

More Reasons To Love This Position

The State of Missouri offers an excellent benefits package that includes a defined pension plan, generous amounts of leave and holiday time, and eligibility for health insurance coverage. Your total compensation is more than the dollars you receive in your paycheck. To help demonstrate the value of working for the State of Missouri, we have created an interactive Total Compensation Calculator. This tool provides a comprehensive view of benefits and more that are offered to prospective employees. The Total Compensation Calculator and other applicant resources can be found here.

If You Have Questions About This Position Please Contact

[e-mail]

The State of Missouri is an equal-opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.