Data Engineer: Snowflake, dbt & Airflow Specialist

HCL Technologies Limited; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

HCL Technologies Limited in Sydney is seeking a data engineer to build and maintain dbt transformation models across pipeline layers, from ingestion to governed datasets.

You will write Snowflake SQL for complex transformations, develop and debug Airflow DAGs on AWS ECS, and contribute to Lambda-based ingestion with Python, file validation, and S3 event handling. You will maintain mappings and support downstream data sharing while collaborating across teams.

Qualifications

• Experience with dbt Core, Snowflake and Airflow in data engineering projects.
• Proficiency in Python and SQL for data transformations and automation.
• Experience with AWS services (S3, Lambda, MWAA, ECS) is a plus.

Responsibilities

• Build and maintain dbt transformation models across multiple pipeline layers from raw ingestion to governed datasets.
• Write Snowflake SQL for complex transformations including type casting, deduplication, incremental loads, and surrogate keys.
• Develop and debug Apache Airflow DAGs on AWS ECS to orchestrate data workflows.

Skills

Strong SQL

Python

Airflow

Snowflake

dbt Core

AWS

Data Modeling

ETL/ELT

Tools

dbt Core

Job description

HCL Technologies Limited in Sydney is seeking a data engineer to build and maintain dbt transformation models across pipeline layers, from ingestion to governed datasets.

You will write Snowflake SQL for complex transformations, develop and debug Airflow DAGs on AWS ECS, and contribute to Lambda-based ingestion with Python, file validation, and S3 event handling. You will maintain mappings and support downstream data sharing while collaborating across teams.