• Position Posted: August 4, 2022
  • Data Modeller
  • Department of Agriculture, Fisheries and Forestry
  • ACT, Canberra CBD
  • Number of Positions: One (1)

Reference:15093
Job Description:Data Modeller
Australian CitizenshipRequired
Security Clearance Level Required:Baseline
Length of Contract:until 30 June 2023
Contract Extension Options:2 x 12 months

Selection Criteria:

  • Essential criteria: Experience designing ETL/ELT processes for data movement and transformation.
  • Essential criteria: Experience exploring and analyzing structured and non-structured data for ingestion into data transformation processes.
  • Essential criteria: Azure Cloud technology experience working with Engineering, Storage and Analytics services.
  • Essential criteria: Working with multi-disciplinary teams using an Agile methodology.
  • Desirable criteria: Experience working with Infrastructure as Code delivery (Terraform).
  • Desirable criteria: Experience work with Data Lake.



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

Data Modeller

The successful candidate/s 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 and the successful candidate will require experience with the following techniques and technology:

  1. Dimensional Data Modelling

2. Data Warehouse/Lakehouse architectures

3. MS Azure Stack

a. Data Integration

i. Data Factory

ii. SQL Server Integration Services

b. Data Storage

i. SQL Server

ii. Synapse Analytics

iii. Blob/File Storage

iv. Cosmos DB

c. Data Cataloguing

i. Purview

4. Development Tools – DevOps

5. Desirable – Experience with legacy data technology solutions – sourcing (Oracle, Ingres, SQL Server, Wintel Server Network file shares), collecting, ingesting and storing.

Positions are based in our Canberra offices. Whilst the department’s current Working Away from the Office (WAFO) policy encourages staff to work in the office a minimum of 40% of the time (such as 2 days per week or 4 days per fortnight), the team requirements are that people work in the office 60% of the time or 3 days a week. Variations can be discussed with the director however, any requests for any less than 40% in the office needs to be supported by the director and approved by the CIO. Due to the nature of some projects, there are some positions where working from home will not be available.


Expressions of Interest By:asap
Please use the form below to submit a recent CV as your EOI
Full response will be required by:19 August

We welcome applications from all sections of the community.


Enquire / Apply for this Position