Future Proof

Team Name: 
The Coding Collective

Developer Story

As a team of software developers we understand that machines are replacing labour on both a physical level, and mental level. Automation and business needs to optimise for efficiency are putting people out of work, or significantly reducing the required hours to complete specific tasks. For our population to meet to the challenges presented by these changing employment conditions, we need our current workforce to be able to re-locate, re-skill, or re-educate; the other option - retire - is not available to the great majority of the populace.

For those yet to enter the workforce, we need to provide better pathways to employment in industries that are growing, not shrinking, and have an increasing need for human resources, not an excess of existing trained and experienced staff or job seekers. Thus we need to ensure that our education system is geared up to output more of what is predicted <em>to be</em> needed, and less of what <em>was</em> needed in the past.

We have used several indicators of business investment, growth and profitability (taxation) to highlight industries that are on the rise, mashed up with employment data over time showing how that growth is having an effect on the workforce in either a positive or negative manner. The intent is to highlight industry’s absorbing more of the workforce relative to the population in a statistical area, and industries shedding workforce.

Because industries cannot relocate as easily as people, it makes sense that this data is taken from a National level and mapped over a local area to better give job seekers an idea of where employment opportunities are growing, and where they are falling, and in what industries, then present that data based on a preferred locality. This then gives us the ability to not just rank employment prospects, but also compare it to housing affordability and other social indicators as the expected pay for a particular job may not match the cost of living or expected lifestyle in that area.

Goal

To provide a web based resource that can facilitate the best application of human resources to industry requirements using data to determine latent needs present in the local economy and growth industries of a particular area and the expected financial outcomes for employees based on trends present in related financial, economic and other indicators.

Proof of Concept

The proof of concept host went south late on Sunday so we have transitioned the code to static responses and re-hosted on a simple HTML service to illustrate the intended user interface. The natural language pathways are limited to a strict subset of data sets and the data is static as pulled from the ABS govhack.abs.gov.au site using the API, and then manipulate in Excel.

Additional information

All code and other project data is hosted on our Git repo - https://github.com/madaz/govhack2016

Please see the Git Readme page for any forther details.

 

Region: 
Used Datasets: 
Dataset Name: 
Regional Statistics by ASGS, 2010-2014
Publishing Organisation/Agency: 
ABS
Jurisdiction of Data: 
Australian Government
How did you use this data in your entry?: 
Used to provide extra metadata for our statistical areas
Dataset Name: 
Experimental Industry Estimates by Geographic Area (SA2) - Experimental data and should not be used for analytical, decision or policy making purposes.
Publishing Organisation/Agency: 
ABS
How did you use this data in your entry?: 
Used as primary data source to extract industry performance and employment data for a given statistical area This data set is huge and although we were able to access it through API: http://govhack.abs.gov.au/restsdmx/sdmx.ashx/GetDataStructure/ABS_EIE/ABS we were unable to query the primary values at an aggregated level (State/Region/LGA). This meant that we had to limit the available data returned for our demonstration as what we are demonstrating is a proof of concept.
Dataset Name: 
Census Data 2011_Qld Employment by Industry
Publishing Organisation/Agency: 
Sunshine Coast Council
Jurisdiction of Data: 
Australian Government
How did you use this data in your entry?: 
Used to provide extra metadata such as housing and lifestyle statistics for our detailed location pages
Dataset Name: 
4130.0 - Housing Occupancy and Costs, 2013-14
Publishing Organisation/Agency: 
ABS
Jurisdiction of Data: 
Australian Government
How did you use this data in your entry?: 
Used to highlight housing affordability in a given area
Dataset Name: 
SA3 Region Innovation Data 2009-15
Publishing Organisation/Agency: 
data.gov.au
Jurisdiction of Data: 
Australian Government
How did you use this data in your entry?: 
Used to weight our primary return based on the level of investment over time in a given industry as an absolute for the industry, and relative for the region compared to the industry average. E.g. a local industry with poor investment/innovation compared to the industry as a whole is ranked lower than one with higher levels of investment.
Dataset Name: 
Industry breakdown of PPSR registrations
Publishing Organisation/Agency: 
Australian Financial Security Authority
Jurisdiction of Data: 
Australian Government
How did you use this data in your entry?: 
Used to weight industries based on level of investment as a trend over time
Dataset Name: 
Jobs Services Australia Vacancy Data
Publishing Organisation/Agency: 
Department of Employment
Jurisdiction of Data: 
Australian Government
How did you use this data in your entry?: 
Used to show example (advertised) vacancies for a particular industry in our regional area details, and as a trend over time to weight the employment numbers (FTE) for top 5 employment opportunities when searching for 'best opportunities' as a natural language query
Event Location: 
Sunshine Coast