We are seeking experiencedData Engineersto design, build, and support scalable cloud-based data solutions.
The role will involve developing up-to-date data pipelines, ETL/ELT frameworks, and data integration solutions usingSnowflake, DBT, AWS, Python, and SQL.
The ideal candidate will have strong 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.
Key Responsibilities
Design, develop, and maintain scalable ETL/ELT pipelines usingSnowflake, DBT, AWS, and Python.
Build and optimize data models, transformations, and orchestration workflows.
Develop frameworks to ingest data from databases, APIs, flat files, CSVs, and other enterprise data sources.
Create reusable and automated data transformation processes using DBT.
Design and implement Snowflake data warehouses, schemas, tables, views, and performance optimization strategies.
Develop data quality, validation, reconciliation, and monitoring solutions.
Implement secure data movement and integration patterns across cloud and on-premise systems.
Work closely with business stakeholders, architects, analysts, and downstream consumers to understand requirements and deliver scalable solutions.
Support deployment and release activities across development, test, and production environments.
Ensure compliance with security, governance,



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

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