Senior Technical Lead
Australia
Apply now
Job Description
Senior Technical Lead
Sydney, New South Wales

Job Summary

  • Building and maintaining dbt transformation models across multiple pipeline layers — from raw ingestion through to governed, consumer-ready datasets
  • Writing Snowflake SQL for complex transformations: type casting, deduplication, incremental load logic, surrogate key generation
  • Developing and debugging Apache Airflow DAGs on AWS ECS
  • Contributing to AWS Lambda-based ingestion( Python) — file validation, control file generation, S3 event handling
  • Maintaining source-to-target mapping documentation and aligning models to business requirements and data specs
  • Supporting onboarding of downstream consumers via data sharing mechanisms and event-driven notifications
  • Participating in code reviews, writing YAML-based data quality tests, and owning tickets from design through to production

Tech stack required

  • Strong SQL
  • Proficiency with dbt Core
  • Apache Iceberg Table format (Nice to have)
  • Apache Airflow
  • AWS - Working Knowledge of S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation, Lambda, SQS, EventBridge
  • Experience with fixed-format or structured financial data files
  • CICD with Github Actions.

Key Responsibilities

  • Building and maintaining dbt transformation models across multiple pipeline layers — from raw ingestion through to governed, consumer-ready datasets
  • Writing Snowflake SQL for complex transformations: type casting, deduplication, incremental load logic, surrogate key generation
  • Developing and debugging Apache Airflow DAGs on AWS ECS
  • Contributing to AWS Lambda-based ingestion( Python) — file validation, control file generation, S3 event handling
  • Maintaining source-to-target mapping documentation and aligning models to business requirements and data specs
  • Supporting onboarding of downstream consumers via data sharing mechanisms and event-driven notifications
  • Participating in code reviews, writing YAML-based data quality tests, and owning tickets from design through to production

Tech stack required

  • Strong SQL
  • Proficiency with dbt Core
  • Apache Iceberg Table format (Nice to have)
  • Apache Airflow
  • AWS - Working Knowledge of S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation, Lambda, SQS, EventBridge
  • Experience with fixed-format or structured financial data files
  • CICD with Github Actions.

Skill Requirements

  • Building and maintaining dbt transformation models across multiple pipeline layers — from raw ingestion through to governed, consumer-ready datasets
  • Writing Snowflake SQL for complex transformations: type casting, deduplication, incremental load logic, surrogate key generation
  • Developing and debugging Apache Airflow DAGs on AWS ECS
  • Contributing to AWS Lambda-based ingestion( Python) — file validation, control file generation, S3 event handling
  • Maintaining source-to-target mapping documentation and aligning models to business requirements and data specs
  • Supporting onboarding of downstream consumers via data sharing mechanisms and event-driven notifications
  • Participating in code reviews, writing YAML-based data quality tests, and owning tickets from design through to production

Tech stack required

  • Strong SQL
  • Proficiency with dbt Core
  • Apache Iceberg Table format (Nice to have)
  • Apache Airflow
  • AWS - Working Knowledge of S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation, Lambda, SQS, EventBridge
  • Experience with fixed-format or structured financial data files
  • CICD with Github Actions.

Other Requirements
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.