Snowflake engineer

Persistent Systems; Sydney; Hybrid; AUD 140,000 - 200,000; Full time

Benefits offered by this job

Competitive salary

Benefits package

Talent development

Flexible hours

Insurance coverage

Job summary

Persistent Systems in Sydney, Australia is seeking an experienced Senior Data Engineer to build and maintain dbt models, write Snowflake SQL, and develop Airflow DAGs on AWS. The role requires 12+ years of experience and leverages a modern data stack including Snowflake, dbt Core, and Apache Airflow.

You will work with AWS services and contribute to data ingestion, quality tests, and downstream data sharing, with a hybrid work arrangement and competitive salary.

Qualifications

• Strong SQL skills.
• Proficiency with dbt Core.
• Apache Iceberg table format is a plus.
• Experience with AWS services (S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation, SQS, EventBridge).
• Experience with fixed-format or structured financial data files.
• CI/CD using GitHub Actions.

Responsibilities

• Building and maintaining dbt transformation models across multiple pipeline layers—from raw ingestion to governed, consumer-ready datasets.
• Writing Snowflake SQL for complex transformations: type casting, deduplication, incremental load logic, surrogate key generation.
• Developing and debugging Apache Airflow DAGs on AWS ECS.
• Contributing to AWS Lambda-based ingestion (Python) including file validation, control file generation, S3 event handling.
• Maintaining source-to-target mapping documentation and aligning models to business requirements and data specs.
• Supporting onboarding of downstream consumers via data sharing mechanisms and event-driven notifications.
• Participating in code reviews, writing YAML-based data quality tests, and owning tickets from design through to production.

Skills

Snowflake

dbt Core

Apache Airflow

Tools

AWS

S3

Lambda

MWAA

ECS

Job description

We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what?s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem.

Our disruptor's mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation, leadership, and inclusion. We reported $1,654.4M FY26 revenue with 17.4% Y-o-Y growth. We have delivered 24 sequential quarters of growth with $436.0M in Q4 FY26 revenue, up 3.2% Q-o-Q and 16.2% Y-o-Y growth. Our 27,500+ global team members, located in 18 countries, have been instrumental in helping the market leaders transform their industries. We have been recognized as the Fastest Growing IT Services Brand Globally in the 2026 Brand Finance IT Services 25 Report. We named a Leader in the Everest Group Private Equity (PE) Services PEAK Matrix? Assessment 2026 and Software Product Engineering PEAK Matrix? Assessment 2026.

Location: Sydney, Australia

Experience: 12 + Years

Job Type: Full-Time Employment

Mandatory Mention 3 skills: Snowflake, DBT, Airflow

What You'll Do:

Responsibilities:

• Building and maintaining dbt transformation models across multiple pipeline layers - from raw ingestion through to governed, consumer-ready datasets
• Writing Snowflake SQL for complex transformations: type casting, deduplication, incremental load logic, surrogate key generation
• Developing and debugging Apache Airflow DAGs on AWS ECS
• Contributing to AWS Lambda-based ingestion( Python) - file validation, control file generation, S3 event handling
• Maintaining source-to-target mapping documentation and aligning models to business requirements and data specs
• Supporting onboarding of downstream consumers via data sharing mechanisms and event-driven notifications
• Participating in code reviews, writing YAML-based data quality tests, and owning tickets from design through to production.

Expertise You'll Bring:

• Strong SQL
• Proficiency with dbt Core
• Apache Iceberg Table format (Nice to have)
• AWS - Working Knowledge of S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation, Lambda, SQS, EventBridge
• Experience with fixed-format or structured financial data files
• CICD with Github Actions.
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds. We support hybrid work and flexible hours to fit diverse lifestyles. Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.

If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Let's unleash your full potential at Persistent - persistent.com/careers

Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.?