GCP Data Engineer - Data Modelling

About the role

Insignia Financials' Data Engineering team is looking for a GCP Data Engineer/Modeller to work on enterprise-wide data assets that power analytics, reporting and business decision-making. The role sits on a modern data platform on Google Cloud, using BigQuery, and involves designing and delivering high-quality analytical data structures from complex source systems.

Key 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 supporting reporting, analytics and integration
• Create and maintain documentation for data lineage, mappings and modelling decisions
• Build and enhance data pipelines that ingest, transform and integrate data across platforms and consumption layers
• Develop and maintain workflow orchestration processes and DAGs with clear dependencies and transformation logic
• Optimise pipelines for performance, scalability, reliability and operational efficiency
• Partner with business stakeholders, data analysts and technology teams to validate data definitions and modelling assumptions

Required profile

• 5+ years of 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
• Ability to turn business requirements into scalable data solutions
• Tertiary qualification in Computer Science, Information Technology or equivalent industry experience
• Eligibility to work in Australia; police and basic credit checks required as a condition of employment

Required skills

• Advanced SQL and complex transformation logic, ideally in Google BigQuery
• Experience with large and complex enterprise datasets
• Data orchestration tools such as Airflow or Composer