People Analytics Data Analyst

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

Job summary

State of Missouri seeks a data analyst to extract, analyze, and visualize government personnel data for diverse stakeholders. The role emphasizes data quality, dashboards, and clear communication of findings to executive and legislative partners.

You will collaborate with HR professionals, experience management resources, and vendors to enhance HR support experiences for state employees across touchpoints. A strong analytical mindset and attention to detail are essential.

Qualifications

• A bachelor’s degree and three years of data analysis information experience preferred.
• Comprehensive knowledge of SAM II HR and data warehouse.
• Demonstrated proficiency using SQL for ad hoc queries, report generation, and cleaning data.

Responsibilities

• 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, dashboards and data issues.

Skills

Communication

MS Access

Tableau

Excel

PowerPoint

SQL

Data visualization

Data analysis

Training

Project planning tools

Education

Bachelor’s degree

Tools

SQL

Tableau

MS Access

Excel

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.

[e-mail]