Senior Data Engineer: SQL, Python & Data Migration (NV2)

Compas

Canberra

On-site

AUD 120,000 - 160,000

Full time

4 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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.