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.
- Robust 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.

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

#J-18808-Ljbffr

📌 Data Engineer - SQL, Python & Data Migration (Canberra)
🏢 Compas
📍 Canberra