GCP Data Engineer & Modeller for Scalable Analytics

Insignia Financial; City of Brisbane; On-site; AUD 120,000 - 180,000; Full time

Job summary

Insignia Financial is seeking a GCP Data Engineer/Modeller to design and deliver enterprise analytics data structures on a state-of-the-art Google Cloud platform with BigQuery. You will work across complex source systems, applying strong modelling expertise to enable trusted data for analytics and decision-making.

The role emphasizes building scalable data pipelines, data lineage documentation, and collaboration with stakeholders to ensure data quality and usability.

Qualifications

• 5+ years of experience in data engineering, analytical data modelling, and transformation design.
• Experience with Data Vault modelling and enterprise data modelling frameworks.
• Advanced SQL skills and experience with complex transformation logic in Google BigQuery.

Responsibilities

• Analyse complex source systems to understand data structures, semantics, and data quality characteristics.
• Map source system data into enterprise and analytical data models to ensure consistency and usability.
• Design, develop, and refine analytical data structures that support reporting, analytics, and integration requirements.
• Create and maintain documentation for data lineage, mappings, and modelling decisions.
• Build and enhance data pipelines that ingest, transform, and integrate data across platforms.
• Develop and maintain workflow orchestration processes and DAGs with clear dependencies.
• Optimise data pipelines for performance, scalability, reliability, and operational efficiency.
• Partner with stakeholders to validate data definitions and modelling assumptions.

Skills

Data engineering

Data modelling

SQL

BigQuery

Airflow

Education

Bachelor's degree in Computer Science or Information Technology

Tools

Google BigQuery

Airflow

Google Cloud Composer

Job description

Insignia Financial is seeking a GCP Data Engineer/Modeller to design and deliver enterprise analytics data structures on a state-of-the-art Google Cloud platform with BigQuery. You will work across complex source systems, applying strong modelling expertise to enable trusted data for analytics and decision-making.

The role emphasizes building scalable data pipelines, data lineage documentation, and collaboration with stakeholders to ensure data quality and usability.