Most Demanding Skills in General

Question 1: What are the most demanding skills in general?

First, let's look at the skill requirements in general in Australia

The most demanding skill is SQL, followed by Python; both are programming languages.

Other common are cloud services like Aws and Azure, and Spark, a data processing service.

Data visualisation tools - Tableau, PowerBi, and spreadsheet skill - Excel - are also covered in a portion of data jobs.

Demanding Skills Correlation

Question 2: Are those demanding skills correlated with each other in general?

I will continue examining whether high-demanding skills are correlated. I will only take in those that account for more than 5% of all data jobs in the above bar chart of question 1.

The correlation of programming languages among each other is significantly higher than the correlation between programming languages and data visualisation tools, mostly because employers require their candidates to know at least one programming language or more in their job descriptions.

The same phenomenon happens for cloud services where Aws, Azure, and Snowflake are highly correlated.

Spark, a large-scale data processing tool in Data Engineer and Data Science, is highly correlated with programming languages Scala, Java, and Python and also significantly connected to Aws.

Data visualisation tools like Tableau and PowerBi, while correlated to one another to some extent, are not that commonly required with Python, but rather SQL and R in the case of Tableau.

Demanding Skills by Occupations

Question 3: What are most crucial skills for every occupation?

Let's continue by looking in more detail at the required skills for Data occupations - Data Analyst, Data Engineer, and Data Scientist

SQL is highly required among all occupations, making up more than 65% of every single one.

For Data Analysts, Python, Excel, Tableau and R are the next required skills.

Data Engineer should possess good knowledge of cloud services(Aws, Azure, Snowflake) and programming languages(Python, Scala, Java) used in the processing pipeline.

Most Data Scientist jobs require candidates to use two programming languages, Python and R.

Demanding Skills by Levels

Question 4: Are there differences in frequency of required skills for different experience levels?

Let's look at the distribution of demanding skills by different seniority levels in the Data industry, including Entry level, Associate, and Mid-senior level.

SQL and Python are highly and equally required at all seniority levels.

At Mid-Senior level positions, it is more common to expect candidates to possess knowledge in services like Aws, Azure, Spark, and Snowflake while the requirements at entry level and associate level are dramatically lower

Tableau is also more demanding at the Associate and Mid-Senior levels.

Demanding Skills by State

Question 5: Do the job locations influence the required skills?

I will end the analysis section with the demanding skills frequency in different states in Australia. I will only include six states in this analysis, and their proportion can be seen in the following pie chart

New South Wales and Victoria account for approximately 80% of data jobs in Australia, and it should mostly be based in Sydney and Melbourne, two megacities of Australia.

Now let's see the skills dependency in every state and see whether the job locations have an influence on the required skills

There are no patterns in the influence of job locations on the candidate's required skills.

Both New South Wales and Victoria have nearly the same high-demanding skills and services distribution.

In Western Australia, Azure is the most required skill, which we could imply from previous parts of this analysis is that a high proportion of data jobs in this state should be Data Engineer.