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:
2
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%