At a Glance
- Tasks: Build and maintain data transformation models and write complex SQL for data processing.
- Company: Join a leading tech firm focused on data innovation and collaboration.
- Benefits: Attractive salary, flexible work options, and opportunities for professional growth.
- Other info: Dynamic team environment with great potential for career advancement.
- Why this job: Make an impact by transforming data into valuable insights for the business.
- Qualifications: Strong SQL skills and experience with data engineering tools like dbt and Apache Airflow.
The predicted salary is between 54000 - 66000 $ per year.
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, SQS, EventBridge.
- Experience with fixed-format or structured financial data files.
- CICD with Github Actions.
Senior Data Engineer in Sydney employer: Tech Aalto Pte ltd
As a Principal Technical Architect / SME in Banking & Cards, you'll join a dynamic team in Sydney that values innovation and collaboration. Our company fosters a supportive work culture with a strong emphasis on employee growth, offering opportunities for professional development and skill enhancement in cutting-edge technologies. Enjoy the unique advantage of working in a vibrant city known for its thriving financial sector, where your expertise will directly impact the evolution of banking solutions.
We think you need these skills to ace Senior Data Engineer in Sydney
dbt transformation models
Snowflake SQL
Apache Airflow
AWS ECS
AWS Lambda
Python
S3 event handling
