GCP Data Engineer & Modeller

Insignia Financial; City of Melbourne; On-site; AUD 120,000 - 170,000; Full time

Job summary

Insignia Financial is seeking a GCP Data Engineer/Modeller to work on enterprise-wide data assets powering analytics and decision-making. You will contribute to a state-of-the-art data platform on Google Cloud, utilizing BigQuery and paving the way for ML/AI innovations.

The role involves designing scalable analytical data structures across complex source systems. You will collaborate with stakeholders to validate data definitions, build robust pipelines, and drive data quality and lineage.

Qualifications

• 5+ years' experience in data engineering, analytical data modelling, and transformation design.
• Strong knowledge of analytical data modelling concepts, including facts, dimensions, grain, and historical data patterns.
• Experience with Data Vault modelling and enterprise data modelling frameworks.
• Proven ability to analyse complex source systems and translate business requirements into scalable data solutions.
• Advanced SQL skills and experience implementing complex transformation logic, ideally within Google BigQuery environments.
• Experience working with large and complex datasets in enterprise environments.
• Exposure to data orchestration and workflow tools such as Airflow or Composer.
• Tertiary qualifications in Computer Science, Information Technology, or equivalent industry experience.

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 comprehensive documentation for data lineage, mappings, and modelling decisions.
• Build and enhance data pipelines that ingest, transform, and integrate data across multiple platforms and consumption layers.
• Develop and maintain workflow orchestration processes and DAGs with clear dependencies and transformation logic.
• Optimise data pipelines for performance, scalability, reliability, and operational efficiency.
• Partner with business stakeholders, data analysts, and technology teams to validate data definitions and modelling assumptions.
• Support the delivery of high-quality, trusted data assets that enable informed business decision-making.

Skills

Data engineering

Data modelling

SQL

Data transformation

BigQuery

Google Cloud

Education

Tertiary qualifications in Computer Science/IT

Tools

Airflow

Google Cloud Composer

ETL tooling

Job description

Insignia Financial is seeking a GCP Data Engineer/Modeller to work on enterprise-wide data assets powering analytics and decision-making. You will contribute to a state-of-the-art data platform on Google Cloud, utilizing BigQuery and paving the way for ML/AI innovations.

The role involves designing scalable analytical data structures across complex source systems. You will collaborate with stakeholders to validate data definitions, build robust pipelines, and drive data quality and lineage.