Senior Program Specialist/Projections Analyst
Main Purpose/Focus of the Position:
This position is responsible for using a variety of statistical modeling techniques to produce occupational and industry employment projections for Missouri and selected workforce 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 economic, industry, and workforce research through creating reports, analysis, and data visualizations. The analyst will share labor market information expertise through responding to requests and providing occasional presentations and trainings to stakeholders.
What You’ll Do:
To perform this job successfully, an individual must be able to perform each essential function of the job with or without reasonable accommodation.
• Loading, correcting, and maintaining data from public and private data sources for use in the Projections Suite.
• Running data models using sound statistical methodology to produce projections estimates.
• Analyze, solve, and correct data issues and provide reliable and valid projections data.
• Create reports, charts, graphs, visualizations, and dashboards for conveying projections and other workforce data.
• Effectively interpret and communicate complex projections models and datasets to various stakeholders to assist in their data needs and reporting requirements.
• Query relevant data using Microsoft SQL Server and SQL agent jobs.
• Help in developing, updating, and maintaining reports and data required as federal and other grant deliverables.
• Review occupational employment and wage estimates and produce local area estimates using the Local Employment and Wage Information Systems (LEWIS) software.
• Apply a broad knowledge of demographic, labor market, economic, workforce, and education data and trends to create relevant and timely research products and publications related to Missouri and its regions.
• Create and maintain Tableau dashboards and visualizations.
• Collaborate with IT, public and private data providers, and business teams using collaboration tools.
• Actively participate as the Missouri representative in the Projections Managing Partnership (PMP).
• Clearly present research and data tools to a variety of stakeholders.
• Serve as a regional data liaison and respond to regional requests.
• Perform other related work as assigned.
• Demonstrate regular and reliable attendance.
• Participate in regular training and learning sessions, particularly regarding projections processes.
Minimum Qualifications:
• A Bachelor’s degree in economics, statistics, mathematics, information or computer science and technology, engineering, data science and analytics, or other related program; and
• One or more years of professional or technical experience in statistical analysis and research, data analytics, economics, database management systems, IT, or a closely related area. (Additional qualifying experience may substitute for deficiencies in the required education.)
• Knowledge of statistical tools, statistical analysis, statistical tests, forecasting, regression analysis, and confidence intervals.
• SQL, MS SQL Server Management Studio, Database Management Systems, or Tableau knowledge is a plus.