Projections Analyst

State-of-Missour; Jefferson City (MO); On-site; USD 65,000 - 85,000; Full time

Job summary

The State of Missouri seeks a skilled data analyst to produce occupational and industry employment projections for Missouri and its regions. You will generate research reports, analyses, and data visualizations to support workforce planning.

The role includes Tableau dashboards, SQL data handling, and collaboration across IT and external data providers. As part of MERIC, you will communicate findings to diverse stakeholders, participate in regional data initiatives, and continually learn new

Qualifications

• Demonstrated knowledge and professional experience in statistical analysis and research, data analytics, economics, or data science.
• High proficiency in statistical tools, analysis, and tests; forecasting; regression analysis; and confidence intervals.
• Knowledge of SQL, MS SQL Server Management Studio, Database Management Systems, R, Python, APIs, or Tableau.
• Familiarity with labor market information systems, O*NET, SOC and NAICS coding.

Responsibilities

• Run data models using sound statistical methodology to produce projections estimates.
• Analyze, solve, and correct data issues and provide reliable and valid projections data.
• Load, correct, and maintain data flows from public and private data sources for use in the Projections Suite using APIs and other integration tools.
• Create reports, charts, graphs, visualizations, and dashboards for conveying projections and other workforce data.
• Create and maintain Tableau dashboards and visualizations.
• Collaborate with IT, public and private data providers, and business teams using collaboration tools.
• Effectively interpret and communicate complex projections models and datasets to various stakeholders to assist in their data needs.
• Query data using Microsoft SQL Server, SQL, R, and other relevant software programs/programming languages.
• Review occupational employment and wage estimates and produce local area estimates using the Local Employment and Wage Information Systems (LEWIS) software (Training for LEWIS will be provided).
• Apply a broad knowledge of demographic, labor market, economic, workforce, and education data and trends to create relevant and timely research products and publications.
• Clearly present research and data tools to a variety of stakeholders.
• Actively participate as the Missouri representative in the Projections Managing Partnership (PMP).
• Serve as a regional data liaison and respond to regional requests.
• Participate in regular training and learning sessions, particularly regarding projections processes.
• Learn and implement new job-related skills, tools, applications, and programs such as R, Tableau, SQL, Prep, MS 365 products, and Video Studio.
• Perform other related work as assigned.
• Demonstrate regular and reliable attendance.

Skills

Statistical analysis

Data analytics

Forecasting

SQL

Tableau

R

Python

Data visualization

Communication with stakeholders

Tools

MS SQL Server Management Studio

APIs

Job description

You will be joining a Department committed to a culture of TEAMWORK to accomplish our goals together, where we deliver excellence through COLLABORATION with partners and stakeholders, embody ACCOUNTABILITY through trust and professionalism, and embrace WORK-LIFE BALANCE by prioritizing respect, boundaries, and time. While working at DHEWD you will be helping to develop the workforce of the future! Join us as we pursue our vision of “Every Missourian empowered with the skills and education needed for success.”

This position is responsible for producing occupational and industry employment projections for Missouri and its regions, along with creating supporting research and analysis based on those projections. As a part of the Missouri Economic Research and Information Center (MERIC), this position will also conduct a variety of economic, industry, and workforce research through creating reports, analysis, and data visualizations.

To perform this job successfully, an individual must be able to perform each essential function of the job with or without reasonable accommodation.

• Run data models using sound statistical methodology to produce projections estimates.
• Analyze, solve, and correct data issues and provide reliable and valid projections data.
• Load, correct, and maintain data flows from public and private data sources for use in the Projections Suite using APIs and other integration tools.
• Create reports, charts, graphs, visualizations, and dashboards for conveying projections and other workforce data.
• Create and maintain Tableau dashboards and visualizations.
• Collaborate with IT, public and private data providers, and business teams using collaboration tools.
• Effectively interpret and communicate complex projections models and datasets to various stakeholders to assist in their data needs.
• Query data using Microsoft SQL Server, SQL, R, and other relevant software programs/programming languages.
• Review occupational employment and wage estimates and produce local area estimates using the Local Employment and Wage Information Systems (LEWIS) software (Training for LEWIS will be provided).
• Apply a broad knowledge of demographic, labor market, economic, workforce, and education data and trends to create relevant and timely research products and publications.
• Clearly present research and data tools to a variety of stakeholders.
• Actively participate as the Missouri representative in the Projections Managing Partnership (PMP).
• Serve as a regional data liaison and respond to regional requests.
• Participate in regular training and learning sessions, particularly regarding projections processes.
• Learn and implement new job-related skills, tools, applications, and programs such as R, Tableau, SQL, Prep, MS 365 products, and Video Studio.
• Perform other related work as assigned.
• Demonstrate regular and reliable attendance.

Demonstrated Knowledge, Skills, and Abilities

• Demonstrated knowledge and professional experience in statistical analysis and research, data analytics, economics, or data science.
• High proficiency in statistical tools, analysis, and tests; forecasting; regression analysis; and confidence intervals.
• Knowledge of SQL, MS SQL Server Management Studio, Database Management Systems, R, Python, APIs, or Tableau.
• Familiarity with labor market information systems, O*NET, SOC and NAICS coding.

Beneficial education and/or work-related experience includes technical or professional experience in business, personnel, public administration or closely related area, including military service.

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.

The State of Missouri is an equal opportunity employer.

[e-mail]