Job Description
We are seeking experienced Data Engineers to design, build, and support scalable cloud-based data solutions. The role will involve developing modern data pipelines, ETL/ELT frameworks, and data integration solutions using Snowflake, DBT, AWS, Python, and SQL.
n
The ideal candidate will have solid hands-on experience building and operating data platforms, transforming data from multiple sources, implementing robust data quality controls, and developing data models that support analytics and business reporting. Candidates should be self-starters who can work independently, contribute to solution design, and ensure security and governance standards are maintained.
n
Key Responsibilities
n
n
Design, develop, and maintain scalable ETL/ELT pipelines using Snowflake, DBT, AWS, and Python.
n
Build and optimize data models, transformations, and orchestration workflows.
n
Develop frameworks to ingest data from databases, APIs, flat files, CSVs, and other enterprise data sources.
n
Create reusable and automated data transformation processes using DBT.
n
Design and implement Snowflake data warehouses, schemas, tables, views, and performance optimization strategies.
n
Develop data quality, validation, reconciliation, and monitoring solutions.
n
Implement secure data movement and integration patterns across cloud and on-premise systems.
n
Work closely with business stakeholders, architects, analysts, and downstream consumers to understand requirements and deliver scalable solutions.
n
Support deployment and release activities across development, test, and production environments.
n
Ensure compliance with security, governance, and PII data protection requirements.
n




Troubleshoot and resolve production data issues while maintaining high availability and reliability.
n
n
Mandatory Skills & Experience
n
Technical Skills
n
n
Strong experience with Snowflake Data Cloud.
n
Hands-on expertise in DBT (Data Build Tool) for transformations and data modeling.
n
Strong experience with AWS services including:
n
S3
n
Lambda
n
Glue
n
IAM
n
CloudWatch
n
Step Functions (preferred)
n
Advanced SQL development and query optimization skills.
n
Strong Python programming experience for data engineering and automation.
n
Experience building enterprise ETL/ELT pipelines.
n
Experience working with structured and semi-structured data (JSON, XML, CSV).
n
Knowledge of data governance, security, and access management.
n
Experience in CI/CD and DevOps practices for data platforms.
n
n
Snowflake Expertise
n
n
Snowflake architecture and administration.
n
Snowpipe, Streams & Tasks.
n
Data sharing and secure views.
n
Performance tuning and query optimization.
n
Role-based access controls (RBAC).
n
Data ingestion and transformation frameworks.
n
n
DBT Expertise
n
n
DBT models and macros.
n
Incremental loading strategies.
n
Data testing and validation.
n
Source-to-target mapping.
n
Documentation and lineage.
n
CI/CD integration with DBT.
n
Experience with Airflow, Prefect, or similar orchestration tools.
n
Knowledge of data lake and lakehouse architectures.
n
Experience with AI-assisted development tools such as:
n
Amazon Q
n
Experience within Banking, Financial Services, or regulated environments.
n
Exposure to real-time and streaming data solutions.
n
#J-*****-Ljbffr

📌 Data Engineer (Snowflake, Dbt & Aws) (New South Wales)
🏢 Synechron
📍 New South Wales