At a Glance
- Tasks: Build and maintain dbt transformation models and write complex Snowflake SQL.
- Company: Join a forward-thinking tech company focused on data innovation.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on continuous learning and development.
- Why this job: Make an impact by transforming raw data into valuable insights.
- Qualifications: Proficiency in dbt Core and experience with AWS tools.
The predicted salary is between 49500 - 60500 $ per year.
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.
Proficiency with: dbt Core (Must have), Apache Iceberg Table format (Nice to have).
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.
Confidentiality is assured, and only shortlisted candidates will be notified for interviews.
DBT Data Engineer in Sydney employer: Tech Aalto
At Tech Aalto, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration. Located in the vibrant city of Sydney, our team enjoys a range of benefits including professional development opportunities, flexible working arrangements, and a commitment to work-life balance, making it an ideal environment for Salesforce Developers looking to grow their careers while contributing to meaningful projects.
