People Analytics Data Analyst

State of Missouri; Missouri; On-site; USD 65,000 - 90,000; Full time

Job summary

State of Missouri is seeking a data analyst to transform workforce data into meaningful insights for stakeholders. You will export data from warehouses, build reports, and deliver dashboards using SQL, Tableau, and Excel.

Collaborate with HR and leadership to shape data strategies, ensure data accuracy, and support ad hoc requests with clear, visual results. This role emphasizes open communication and data-driven decision making.

Qualifications

• Bachelor’s degree and three years of data analysis information experience preferred.
• Proficiency using SQL for ad hoc queries, report generation, and cleaning data.
• Knowledge of HR data, data warehouses, and reporting best practices.

Responsibilities

• Export information from data warehouse and other applications for routine reports and ad hoc queries.
• Analyze data related to the team member experience and talent management initiatives.
• Convert and validate raw data into clear, meaningful information.
• Communicate results effectively through various mediums and contexts.
• Validate data accuracy from multiple sources and respond to inquiries.
• Provide excellent customer service to state agencies and stakeholders.
• Develop reports, queries, and document processes for recurring and ad hoc requests.
• Collaborate with leaders to facilitate data discussions and data strategies.

Skills

SQL

Tableau

Excel

Data warehouses

Dashboards

PowerPoint

MS Access

Qualtrics

Trello

Monday.com

Education

Bachelor's degree

Tools

Tableau Desktop

Tableau Prep Builder

Excel

PowerPoint

MS Access

Qualtrics

Trello

Monday.com

Job description

Job location: Harry S. Truman State Office Building 301 W. High St., Jefferson City, MO 65101

The Division of Personnel is responsible for providing programs and services to promote recruitment, retention, and development of top talent across the State’s team member enterprise. In collaboration with Human Resources professionals from each of the 17 executive departments, the division develops and carries out initiatives designed to provide a productive and engaged workforce.

We are seeking a team player with the ability to quickly grasp the complexities of government personnel data and deliver excellent results to a wide range of stakeholders, as well as deliver solutions that improve HR support experiences for state team members.

The right person will apply critical thinking to requests for information, identify appropriate data sources, analyze and validate the data, and creatively display the results in a capacity appropriate for the audience. The analyst will collaborate with internal stakeholders, experience management technical resources, and employee experience vendors to deliver a meaningful and positive impact for state team members across all touchpoints.

This is a great opportunity for anyone interested in data, open to new challenges, and looking to improve our government services through supporting the State’s workforce of public servants.

The salary indicated represents a base pay rate. If the individual selected or the position is eligible for a pay differential (e.g., shift, security, or years of service), it will be added to the total compensation in your paycheck. A pay differential does not raise your base pay.

• Export information from the data warehouse and other applications to run routine reports and ad hoc queries.
• Conduct analyses of data related to the team member experience and talent management initiatives.
• Convert and validate raw data into clear, meaningful information.
• Effectively communicate results through various mediums and contexts.
• Validate and ensure data accuracy from various data sources in various forms.
• Respond to inquiries from customer agencies related to data requests, data integrity, dashboards and data issues that arise.
• Provide excellent customer service to the Division’s various customers, including the State Legislature, Governor’s Office, and executive agencies.
• Develop reports, queries, and document processes for recurring and ad hoc requests.
• Collaborate with leaders and facilitate data discussions and the creation of data strategies at all levels of the organization.
• Compile, validate, and ensure accuracy of data for team member salaries, pay plan implementation, media requests, internal/external customer requests, and ad hoc requests.
• Provide statistical and analytical support by conducting research, compiling and analyzing data, and creating and maintaining necessary reports and meaningful data visualizations for projects and presentations.
• Provide technical support, trouble shooting and general administration of various HR related systems.
• Assist in the technical administration of statewide talent management programs.
• Support the survey management operating model to include survey standards, governance, survey performance, closed-loop model, and survey lifecycle.
• Support the Talent Management Help Desk.
• Train other Strategy & People Analytics team members on data processes, as needed.

Minimum Qualifications

• A bachelor’s degree and three years of data analysis information experience preferred.

Preferred Qualifications

• Comprehensive knowledge of SAM II HR and data warehouse.
• Demonstrated proficiency using SQL for ad hoc queries, report generation, and cleaning data.

Knowledge, Skills, And Abilities

• Excellent communication skills to interact with customers and determine reporting requirements.
• Ability to align information technology expertise with knowledge of human resources to optimize human resource practices.
• 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 MS Access, Tableau Desktop, Tableau Prep Builder, Excel, and PowerPoint.
• Experience with data warehouses, writing queries, developing reports and presentations, and using SQL.
• A general understanding of HR, personnel, and compensation related topics. Skilled in researching, analyzing, and reporting on large data sets.
• Experience designing and building surveys with Qualtrics or other survey tools and establishing integrations with other organizational tools.
• Proficiency with Trello, Monday.com, or other project planning software
• Ability to train other team members on data processes.

Lack of post‑secondary education will not be used as the sole basis denying consideration to any applicant.

Successful background check results are required for employment in this position. This may include background checks involving a candidate's name and/or fingerprints and other screenings as needed for the specific position.

Authorization to work in the United States is a prerequisite of employment. The Office of Administration will not sponsor applicants for work visas.

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.