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 modern 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.
- Solid 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