Senior Snowflake Engineer

PAAR Systems; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

PAAR Systems seeks a hands-on data engineer to deliver secure, scalable Snowflake data products in a regulated banking environment. You will own the end-to-end design, development, and maintenance of data pipelines and governance across the platform.

The role requires collaboration with architecture, risk, and business teams, implementing CI/CD, security, cost optimization, and performance tuning while mentoring junior engineers.

Qualifications

• Strong Snowflake development in an enterprise data environment.
• Advanced SQL with complex transformations and data modelling.
• Experience building cloud-native data solutions on AWS and/or Azure.
• Experience with ELT/ETL frameworks and tools such as dbt, Snowpark, Python, Airflow.
• Proficiency with GitHub and automated testing and deployment pipelines.
• CI/CD and DevOps capabilities for data platforms.
• Data governance, quality, security, privacy, and access-control requirements.
• Familiarity with Agile delivery and stakeholder management.
• Banking/financial-services data handling in regulated environments.
• Experience with AI-enabled analytics and data platforms.

Responsibilities

• Design, develop, and maintain Snowflake databases, schemas, data models, and reusable data products.
• Build and optimize ETL/ELT pipelines using SQL, Python/Snowpark, dbt, Snowflake Tasks, Streams, and stored procedures.
• Integrate data from enterprise sources, APIs, cloud platforms, and third-party data sources.
• Develop and maintain automated deployment pipelines using Git-based version control and CI/CD practices.
• Apply data-engineering practices for performance tuning, workload management, query optimization, and cost control.
• Implement data security and governance controls, including RBAC, masking, secure data sharing, auditing, and data-quality checks.
• Partner with data architects, analysts, product owners, risk/compliance, and stakeholders to translate requirements into scalable solutions.
• Support production incidents, root-cause analysis, monitoring, documentation, and continuous improvement; provide technical leadership via code reviews and patterns.
• Provide technical leadership through code reviews, standards, reusable patterns, and mentoring of junior engineers.

Skills

Snowflake development

Advanced SQL

Cloud-native data solutions

ELT/ETL frameworks

GitHub/CI-CD

Data governance & security

Agile & stakeholder mgmt

Banking/regulatory data

AI-enabled analytics

APIs & event-driven integration

Education

Snowflake certification (SnowPro Core/Advanced)

Tools

dbt

Snowpark

Python

Airflow

GitHub

CI/CD

Snowflake

Snowflake Tasks/Streams

Job description

A hands-on data-engineering role focused on delivering secure, scalable Snowflake data products within a regulated banking environment. The position emphasizes end-to-end ownership, cloud-native platforms, CI/CD, security, governance, performance, cost optimization, and collaboration with business and architecture stakeholders.

Role Purpose

Design, build, enhance, and support scalable data pipelines, data models, and analytical solutions on Snowflake. The role helps enable trusted, governed data for banking products, operations, risk, finance, customer analytics, and regulatory reporting.

Key Responsibilities

• Design, develop, and maintain Snowflake databases, schemas, data models, and reusable data products
• Build and optimize ETL/ELT pipelines using SQL, Python/Snowpark, dbt, Snowflake Tasks, Streams, and stored procedures
• Integrate data from enterprise source systems, APIs, cloud platforms, and third-party data sources
• Develop and maintain automated deployment pipelines using Git-based version control and CI/CD practices
• Apply data-engineering practices for performance tuning, workload management, query optimization, and warehouse cost control
• Implement data security and governance controls, including role-based access control, masking policies, secure data sharing, auditing, and data-quality checks
• Partner with data architects, analysts, product owners, risk and compliance teams, and business stakeholders to translate requirements into scalable technical solutions
• Support production incident resolution, root-cause analysis, monitoring, documentation, and continuous improvementProvide technical leadership through code reviews, standards, reusable patterns, and mentoring of junior engineers

Essential Skills and Experience

• Strong hands-on Snowflake development experience in an enterprise data environment
• Advanced SQL skills, including complex transformations, performance tuning, stored procedures, and data modelling
• Experience building cloud-native data solutions on AWS and/or Azure
• Experience with ELT/ETL frameworks and tools such as dbt, Snowpark, Python, Airflow, or equivalent orchestration tools
• Practical experience with GitHub/Git, automated testing, and deployment pipelines
• Strong CI/CD and DevOps capability
• Experience with data governance, data quality, security, privacy, and access-control requirements
• Familiarity with Agile delivery, stakeholder management, and documenting technical designs
• Banking or financial-services experience, particularly where data handling, auditability, and regulatory controls are important
• Experience with AI-enabled analytics, automation, or data platforms supporting machine-learning workloads
• Knowledge of data observability, metadata management, lineage, and catalogue tooling
• Snowflake certification, such as SnowPro Core or SnowPro Advanced
• Experience with APIs, event-driven integration, and modern data-platform architectures

Candidate Profile

The ideal candidate is a senior, delivery-oriented engineer who can own a solution from technical design through deployment and operational support, balancing speed of delivery with security, governance, performance, and cost optimization, plus strong stakeholder collaboration in a large, regulated environment.