Data Engineer - SQL, Python & Data Migration

Compas; Canberra; On-site; AUD 120,000 - 160,000; Full time

Job summary

Compas Pty Ltd in Canberra is seeking a Data Engineer skilled in SQL, Python and data migration to design and build enterprise data pipelines, data marts and analytical products for a major government transformation.

You'll migrate legacy data environments, support SAP ERP integration and deliver trusted data assets to enable complex operational decisions across logistics and operations. NV2 clearance may be required; closing date is 20 November 2026.

Qualifications

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

Responsibilities

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

Skills

Advanced SQL

STAR schema design

3NF design

SQL optimization

Python scripting

ETL/ELT pipelines

Data quality verification

Data DevOps

Legacy data migration

Tools

SAP ERP integration

Job description

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.

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