GCP Data Engineer & Modeller for BigQuery Analytics

Insignia Financial; City of Hobart; On-site; AUD 120,000 - 160,000; Full time

Job summary

Insignia Financial is seeking a GCP Data Engineer/Modeller to work on enterprise data assets powering analytics, reporting and decision-making. You’ll join a state-of-the-art data platform on Google Cloud using BigQuery and contribute to a scalable data ecosystem.

You will map complex source data into enterprise models, design analytical structures, and build robust pipelines. Applicants must have authority to work in Australia and may undergo police and basic credit checks.

Qualifications

• 5+ years’ experience in data engineering, analytical data modelling, and transformation design.
• Strong knowledge of analytical data modelling concepts (facts, dimensions, grain, history).
• Experience with Data Vault modelling and enterprise modelling frameworks.
• Advanced SQL skills and BigQuery experience.
• Exposure to data orchestration tools such as Airflow or Composer.

Responsibilities

• Analyse complex source systems to map data into enterprise and analytical models.
• Design, develop, and refine analytical data structures for reporting and analytics.
• Create and maintain documentation for data lineage, mappings, and modelling decisions.
• Build and enhance data pipelines to ingest and transform data across platforms.
• Develop and maintain DAGs with clear dependencies and logic.
• Optimise pipelines for performance, scalability, and reliability.
• Partner with stakeholders to validate data definitions and modelling assumptions.
• Support delivery of high-quality, trusted data assets for decision making.

Skills

Data engineering

Analytical data modelling

Transformation design

SQL

Data governance

Education

Bachelor's degree in CS/ IT or equivalent

Tools

BigQuery

Airflow

Composer

Job description

Insignia Financial is seeking a GCP Data Engineer/Modeller to work on enterprise data assets powering analytics, reporting and decision-making. You’ll join a state-of-the-art data platform on Google Cloud using BigQuery and contribute to a scalable data ecosystem.

You will map complex source data into enterprise models, design analytical structures, and build robust pipelines. Applicants must have authority to work in Australia and may undergo police and basic credit checks.