Overview
The Talent Neuron dataset is provided by the Ohio Department of Job and Family Services (ODJFS) to the Ohio Education Research Center (OERC). This dataset includes job postings across Ohio, focusing on in-demand occupations identified by industry standards. Data preparation, filtering and processing were conducted by OERC to ensure data accuracy and usability for analysis and visualization.
Data Sources
The Talent Neuron dataset includes details such as job posting dates, date posting was last seen, employer names, job titles, salary estimates, remote work status, and required skills or credentials. The Ohio Education Research Center (OERC) supplements this dataset with additional crosswalks and mappings to group postings by geography and distinguishes skills by occupation. Broadband and 5G-related job postings were identified using Standard Occupational Classification (SOC) system codes assigned by Talent Neuron, specifically those matching Broadband and 5G criteria. Job postings for occupations that fall outside this list of SOC codes were not used in the dashboard.
Preparation and Deduplication
Duplicate postings were removed by keeping only the version with the most recent Date Last Seen for each unique combination of Posting ID and First Seen date. This ensures that the most up-to-date version of each job is retained, including any refinements made by TalentNeuron during their scraping or deduplication process. The original First Seen date is preserved and used as the job’s posting date throughout the dashboard.
Job postings were mapped to Ohio counties and subsequently grouped into regions by county association. Only postings with valid county information were retained.
Job postings were associated with specific SOC codes using the 6-digit SOC code, ensuring alignment with in-demand occupations. Where appropriate, these 6-digit SOC codes were aggregated to the 2-digit SOC level to simplify analysis (linked to O*NET).
The “Skills Frequency” field in each job posting is parsed by separating comma-delimited entries into individual rows, ensuring each skill is analyzed independently. For every SOC-6 occupation code, all associated postings during the selected time period are processed to extract a unique set of skills. Each skill is counted only once per SOC-month combination to prevent overrepresentation from repeated entries within the same time slice. Furthermore, if a skill is found in a posting, it is counted once for that posting.
Skills frequency calculations have been refined to represent the proportion of each skill relative to all skills mentioned within an occupation. Specifically, the occurrences of a given skill across postings are summed up and divided by the occurrence of all skills in postings for that occupation. This ensures that the analysis highlights relative demand for each skill while mitigating the effects of repeated listings.
Two outputs are generated: a long-format table listing each skill by SOC, and a wide-format matrix for SOC-2-level heatmap analysis. Skill counts are currently unweighted and reflect frequency distributions.
Data Sources and Preparation
The institution, training program, and graduates data visualizations use publicly available IPEDS data, processed by OERC and supplemented with information on Broadband & 5G sector participants. They include institutional characteristics such as program levels (e.g., certificates, associate’s, and bachelor’s degrees), Control (public, private not-for-profit, private for-profit) where appropriate, and geographic details. Additional institutions were added based on their engagement with Ohio’s Broadband & 5G Sector Partnership and verified against IPEDS.
Cleaning and Processing
Institutions were mapped to JobsOhio regions using county FIPS codes. Program levels were categorized as “Less than 2 years,” “At least 2 but less than 4 years,” or “Four or more years.” Control classifications were standardized as public, private not-for-profit, or private for-profit. The categorization of program levels and control classifications are aligned with the existing IPEDS taxonomy.
This list includes institutions affiliated with the Ohio Broadband & 5G Sector Partnership. Institutional information and administrative data were collected by the Partnership and managed with Smartsheet. Additional programmatic and institutional details were gathered from sector partnership staff and respective public facing websites.
This institutional-level data was collected through the Integrated Postsecondary Education Data System (IPEDS). Institutions were identified with a curated list of SOC codes formulated by employers, education and training providers, and workforce development experts in the Broadband & 5G Sector Partnership. 6-digit SOC codes were used to ensure alignment with in-demand occupations. Where appropriate, these 6-digit SOC codes were aggregated to the 2-digit SOC level to simplify analysis (linked to O*NET). Utilizing the CIP_SOC crosswalk, a generated list of CIPS were identified which informed a census of Ohio post-secondary providers delivering industry related education and training programs. The sector-specific lists of SOC and CIP codes are available within dedicated tabs, below. Refer to Partnership Affiliated Programs for more information about education providers actively engaged with Ohio’s Broadband & 5G Sector Partnership.
Shows completers over time by program level and region for industry related CIPs identified by the Sector Partnership. Highlights workforce supply trends relevant to the sector. All data is publicly available and supplemented by OERC for improved relevance to the Sector Partnership’s workforce initiative.
The ApprenticeshipOhio data includes details such as program ID number, apprenticeship sponsor, primary contact, and occupations. Each apprentice sponsor is grouped with all occupations related to their program. The Ohio Education Research Center (OERC) supplemented this dataset with additional crosswalks and mappings to group postings by geography and distinguish skills per occupation. Broadband and 5G-related apprenticeships were identified by ApprenticeOhio (Ohio Department of Job and Family Services).
Occupations were individualized to each sponsor to highlight the individual occupation opportunities per program. Geographic information including addresses, cities, states, zip codes, and counties is publicly available on the sponsors’ websites. Latitude, longitude, and all previously mentioned geographic information was verified with Census Geocoder produced by the United States Census Bureau and additional crosswalks at the OERC. Apprenticeships were mapped to Ohio counties and subsequently grouped into regions by county association. Only postings with valid county information were retained.
Program provider information and administrative data is provided by ApprenticeshipOhio (Ohio Department of Jobs and Family Services).
This dashboard was made possible by generous support from Quality Jobs Equity, Strategy, and Training (QUEST) funding from the Ohio Department of Job & Family Services with contributions by partners at the Governor’s Office of Workforce Transformation, Broadband Ohio, and the Wireless Infrastructure Association.
Reach Out To: