People Analytics Data Analyst

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. Responsibilities - What you’ll do

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

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

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.

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. Contact Details - If you have questions or require any accommodations to participate in the application or interview process please contact:

OARecruiters@oa.mo.gov The State of Missouri is an equal opportunity employer and is committed to developing and maintaining a talented workforce.