Economic Forecasting & Data Visualization 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

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