dreamwork_
Data Engineer - SQL, Python & Data Migration

Work on a major government data transformation initiative, designing and developing enterprise data pipelines, data marts and analytical products. Use SQL, Python and ETL/ELT to migrate legacy data environments, support SAP ERP integration and deliver trusted data assets for complex operational decision-making.


Location: Canberra, ACT
Security Clearance Requirement: Minimum NV2
Closing Date: 20 November 2026

Essential Tasks
  • Design, build and optimise data integration pipelines supporting legacy system migration and SAP ERP integration.
  • Develop enterprise data marts, STAR schemas and reusable analytical data products across logistics, sustainment and operational domains.
  • Support migration from legacy data warehouses to enterprise data mesh architectures, improving data quality, governance and interoperability.
  • Collaborate with Business Analysts, Data Architects and developers to deliver data transformations, testing and application enhancements.

Key Criteria
  • Minimum 5 years' dedicated data engineering experience, including advanced SQL, 3NF and STAR schema design, optimisation and refactoring.
  • Strong Python scripting and data transformation experience, including ETL/ELT pipelines, data quality verification and Data DevOps.
  • Experience migrating or refactoring legacy data warehouses or large-scale application data environments, including data mart design, development and testing.
  • Experience working in Agile environments, preferably Scrum. Exposure to Data Vault 2.0, data mesh, SAP logistics or Cloudera/Databricks is desirable.

How to Apply
Does this role sound perfect for you? If so, to register your interest in this role, please apply below and send through your latest CV. If you have further questions or wish to speak with the consultant, please contact Melissa on (02) 6230 0233.

About Compas
Compas Pty Ltd is a Canberra based wholly Australian owned, Recruitment and Services company that has been operating since 1987. We specialise in the provision of permanent, contract and temporary recruitment services, as well as specialised Consulting assignments.

YOUR APPLICATION WILL BE TREATED WITH THE STRICTEST CONFIDENCE
Due to the nature of this environment, candidates must hold a current NV2 clearance.
This listing is tracked by dreamwork from public job postings. Want it prepared into a personalized application pack? Upload your resume →
Posted yesterday