Data Engineer

Davidson; City of Brisbane; Hybrid; AUD 150,000 - 190,000; Full time

Benefits offered by this job

Hybrid work arrangements

Onsite onboarding 2–3 weeks

Job summary

Davidson is seeking an experienced Data Engineer in Brisbane to lead data migration and transformation within a Microsoft Fabric environment. You will move legacy data into OneLake, rebuild ETL logic as modular dbt models, and implement automated data quality testing.

You will own migrations across Fabric, build robust pipelines, and establish CI/CD practices with Git. Prior government data projects are highly desirable; hybrid work is available with initial onsite onboarding.

Qualifications

• Proven delivery of legacy database migrations to modern cloud data platforms.
• Strong hands-on dbt experience across models, tests, macros, snapshots and documentation.
• Advanced SQL skills, particularly reverse engineering and modularising stored procedures.
• Microsoft Fabric experience across OneLake, Warehouse/Lakehouse and Data Factory pipelines.

Responsibilities

• Profile legacy databases, stored procedures, jobs and downstream dependencies.
• Migrate data into OneLake using Fabric Data Factory, mirroring and appropriate ingestion patterns.
• Reverse engineer complex SQL and rebuild legacy ETL/stored procedures as modular dbt models.
• Build dbt sources, staging models, business logic and reporting marts across Fabric.
• Reconcile legacy and migrated datasets and implement automated data quality testing.
• Establish Git-based CI/CD, deployment pipelines, monitoring and environment management.

Skills

SQL

dbt

Data migration

Microsoft Fabric

Git

CI/CD

OneLake

Education

Bachelor's degree in Computer Science or related

Tools

Azure DevOps

GitHub

dbt

Job description

• 3 days per week in Brisbane CBD office, must be willing to be onsite fulltime for onboarding (usually 2-3 weeks)
• Previous experience in Government is highly desirable

About the Opportunity

Join a significant data modernisation initiative focused on migrating legacy data assets onto Microsoft Fabric and establishing a modern, governed and maintainable data platform. This is a hands‑on engineering role where you will move data into OneLake, reverse engineer complex legacy SQL and ETL, rebuild transformation logic in dbt and establish the automation, testing and documentation needed for the platform to operate successfully beyond go‑live.

About the Role

You will take ownership of core migration and transformation activities, working across legacy platforms and the new Microsoft Fabric environment.

• Profile legacy databases, stored procedures, jobs and downstream dependencies.
• Migrate data into OneLake using Fabric Data Factory, mirroring and appropriate ingestion patterns.
• Reverse engineer complex SQL and rebuild legacy ETL/stored procedures as modular dbt models.
• Build dbt sources, staging models, business logic and reporting marts across Fabric.
• Reconcile legacy and migrated datasets and implement automated data quality testing.
• Establish Git-based CI/CD, deployment pipelines, monitoring and environment management.

About You

You will be an experienced Data Engineer who combines strong SQL and migration capability with genuine hands‑on experience across Microsoft Fabric and dbt.

• Proven delivery of legacy database migrations to modern cloud data platforms.
• Strong hands‑on dbt experience across models, tests, macros, snapshots and documentation.
• Advanced SQL skills, particularly reverse engineering and modularising stored procedures.
• Microsoft Fabric experience across OneLake, Warehouse/Lakehouse and Data Factory pipelines.
• Strong dimensional modelling, reconciliation, data quality and layered warehouse experience.
• Git and CI/CD experience using Azure DevOps or GitHub for automated data deployments.

The Benefits

• Brisbane-based contract with hybrid arrangements.*
• Hands‑on ownership across Microsoft Fabric, dbt, migration, automation and data quality.
• Opportunity to establish engineering practices that remain in place beyond the engagement.

*The first 2-3 weeks will likely have to be full-time onsite for onboarding