Role Overview

We are looking for an experienced Data Engineer to help design, build, and optimize a modern cloud data platform. The role will focus on developing robust ELT pipelines using Fivetran, managing data infrastructure on AWS, and building scalable data models and transformations in Snowflake using Coalesce.

The ideal candidate will have strong hands-on experience with Snowflake, advanced SQL, cloud data engineering, and contemporary data stack technologies, with a focus on building reliable and high-performance data solutions.

Key Responsibilities

- Design, build, monitor, and maintain automated data ingestion pipelines using Fivetran or similar ELT tools.
- Work with data from SaaS applications, databases, APIs, and other enterprise sources.
- Manage and optimize AWS services supporting the data platform, including S3, IAM, Lambda, and CloudWatch.
- Maintain secure and cost-effective data movement from raw data landing zones into Snowflake.
- Design, develop, and optimize Snowflake data warehouses, including virtual warehouses, clustering, micro-partitioning, and query performance.
- Build scalable data transformation models using Coalesce, leveraging metadata-driven and reusable transformation patterns.
- Develop analytics-ready data models using Kimball dimensional modelling / Star Schema or Data Vault 2.0 methodologies.
- Monitor Snowflake workloads and optimize query performance and compute costs.




- Implement CI/CD processes and Git-based version control for Snowflake objects and data transformation deployments.
- Establish data quality checks, validation processes, and proactive monitoring to ensure data reliability.

Required Skills & Experience

- 3 years of experience in Data Engineering, Data Warehousing, or Business Intelligence.
- Strong hands-on experience with Snowflake, including architecture, query optimization, virtual warehouses, and RBAC.
- Excellent SQL skills, including complex joins, window functions, UDFs, and performance troubleshooting.
- Working experience with AWS, particularly S3, IAM, and CloudWatch.
- Proven experience with Fivetran or similar automated data ingestion/ELT platforms.
- Strong understanding of data warehousing, data modelling, and modern data engineering practices.
- Experience with Git and CI/CD for data engineering deployments.

Preferred Skills

- Hands-on experience with Coalesce.io for Snowflake data modelling and transformation.
- Strong experience with dbt or Dataform will also be considered, with willingness to work with Coalesce.
- Proficiency in Python for scripting, AWS Lambda, or Snowpark-based solutions.
- Experience with Kimball dimensional modelling or Data Vault 2.0.
- SnowPro Core or SnowPro Advanced Architect certification is desirable.

📌 Data Engineer – Snowflake / AWS / Fivetran / Coalesce (Sydney)
🏢 Neuronimbus
📍 Sydney