Sr Data Engineer-Snowflake, AWS

Synechron; Sydney; On-site; AUD 150,000 - 230,000; Full time

Job summary

Synechron is seeking a Senior Data Engineer in Sydney to own and advance data pipelines using Snowflake, DBT, and AWS. You will design robust ETL/ELT flows, optimize SQL, and ensure data governance. Expect collaboration across teams, implementing CI/CD for data platforms while handling structured and semi-structured data and real-time streams.

The role emphasizes Python automation, data quality, and scalable architectures within a regulated financial services context.

Qualifications

• Strong experience with Snowflake Data Cloud and data modeling.
• Hands-on expertise with DBT for transformations and data modeling.
• Proficient in AWS services (S3, Lambda, Glue, IAM, CloudWatch).
• Advanced SQL development and query optimization skills.
• Strong Python programming for data engineering and automation.
• Experience building enterprise ETL/ELT pipelines.
• Knowledge of data governance, security, and access management.
• Experience with CI/CD and DevOps practices for data platforms.
• Experience with Airflow, Prefect, or similar orchestration tools.
• Exposure to data lake / lakehouse architectures and real-time data.

Skills

Snowflake Data Cloud

DBT (Data Build Tool)

AWS services

Python for data engineering

ETL/ELT pipelines

SQL development & optimization

Data governance & security

CI/CD for data platforms

Airflow / Prefect / orchestration

Data lake / lakehouse architectures

Real-time & streaming data exposure

Tools

Snowflake

DBT

AWS S3

AWS Lambda

AWS Glue

AWS IAM

AWS CloudWatch

AWS Step Functions

Airflow

Prefect

Job description

We’re looking for a Sr Data Engineer with AWS and Snowflake

Synechron, is a global provider of Information Technology outsourcing services focused on the banking, finance and payments industry. We provide a broad range of IT services and technology solutions that are flexible, cost-effective, efficient and reliable. We pride ourselves on our ability to deliver high quality resources and solutions to our clients. Through Synechron’s Financial innovation labs, we continue to develop innovative solutions by providing engineering payment solutions, creating tools and processes that shape the evolution of technology. For more information on the company, please visit our website: www.synechron.com.

Job Description:

Mandatory Skills & Experience

• Strong experience with Snowflake Data Cloud.
• Hands-on expertise in DBT (Data Build Tool) for transformations and data modeling.
• Strong experience with AWS services 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.