Data Analyst/Modeller

Job code:

DM-20892

Location:

ACT

Department:

Department of Agriculture, Fisheries and Forestry

Application closing date:

7 November 2023

Start date:

13 November 2023

Contract duration:

12 months

Number of extensions:

The Department of Agriculture, Fisheries and Forestry (DAFF) is looking for Data Analyst/Modellers with experience in exploring datasets and designing Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes across several data and analytics platforms.

The role will be responsible for analysis and design activities across several data movement and transformation processes within DAFF. These data movement and transformation processes are in the process of being uplifted to Microsoft Azure.

The successful candidate will require experience with the following techniques and technologies:

1. Dimensional Data Modelling

2. Data Warehouse, Lakehouse and Data Mesh architectures

3. MS Azure Stack

a. Data Integration

i. Data Factory

ii. SQL Server Integration Services

iii. Databricks

b. Data Storage

i. SQL Server

ii. Blob/File Storage

iii. Data Lakes

iv. Cosmos DB

c. Data Science

i. Databricks

ii. Azure Machine Learning

4. Development Tools – DevOps

Desirable – Experience working in agile delivery methodologies (e.g. Scaled Agile Frameworks)

Criteria

Essential criteriaWeighting

1. Experience designing ETL/ELT processes for data movement and transformation.25%

2. Experience exploring and analysing structured and non-structured data for ingestion into data transformation processes25%

3. Azure Cloud technology experience working with Engineering, Storage and Analytics services.25%

4. Working with multi-disciplinary teams using an Agile methodology25%

Desirable criteriaWeighting

1. Experience working with Infrastructure as Code delivery (Terraform)50%

2. Experience working with Data Lakes50%