We are looking for Data Engineers to join the Digital Transformation Program in the Australian Bureau of Agricultural and Resource Economics and Sciences (ABARES) to work across several data and analytics platforms. We are seeking candidates with strong experience in developing Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes, and /or the development of data products and complex data visualisations.
The role will be responsible for design, development and unit testing activities across several data movement, data transformation, and data visualisation processes within DAFF. The data movement and transformation processes focus on the preparation of data for use in decision making processes across the department, utilising modern cloud technology (Azure) to enable operational analytics use cases.
(A) You must be Australian citizen having the Baseline Security clearance.
(B) You must have:
1. Demonstrated experience developing ETL/ELT processes for complex and/or large data movement, transformation and/or visualisations, particularly in a cloud environment.
2. Experience preparing data optimised for query performance in cloud computed engines. E.g. • Distributed computing engines (Spark) • Azure SQL • Python • R
3. Experience working with Engineering, Storage and Analytics services in cloud infrastructure.
4. Experience working collaboratively in an agile development team
You must have experience with the following techniques and technologies:
- MS Azure Stack
-
- Data Integration - Data Factory, SQL Server Integration Services and/or Databricks, LogicApp and/or FuncationApp
- Data Store - SQL Server and/or Data Lake Storage, Unity Catalog (Medallion Architecture)
- Analytics - Azure Databricks, Azure Machine Learning, ArcGIS Enterprise
- Development tools – DevOps, Visual Studio, VS Code
- Data technology solutions – sourcing (Flat file, Ingres, Azure, SQL Server), collecting, ingesting and storing
- SQL, Python, R, .Net
- Data Preparation
-
- Transformation of data into formats tailored to analytics use cases – Parquet and/or Delta
- Data Visualisation
-
- Analyse and interpret complex data sets, and to identify trends and patterns.
- Design principles to create appropriate visualisations for target audience.
- Visualisation tools - Power BI
Offer ended on 09.09.2024